DP-900 Test QUESTIONS with Correct Verified
Solutions
Descriptive Analytics tells you
what occurred in the past
Normalisation involves eliminating relationships between database tables
NO
Normalising a database reduces data redundancy
YES
Normalisation improves data integrity
YES
An extract, transform and load (ETL) process requires
that the data target be a relational database
In batch processing
latency is expected
Diagnostic
Why did sales increase last month?
Predictive
How do I allocate my budget to buy different inventory items?
Cognitive
,Which people are mentioned in a company's business documents?
Transcribing audio files is an examples of
cognitive analytics
You have the following JSON document: 'customer': { 'first name': 'ben', 'address': {'line
1': '161 Azure Ln', } } . 'social' : [ { 'service: twitter'., 'handle': @bensmitg'}
customer is
a root object
You have the following JSON document: 'customer': { 'first name': 'ben', 'address': {'line
1': '161 Azure Ln', } } . 'social' : [ { 'service: twitter'., 'handle': @bensmitg'}
address is
a nested object
You have the following JSON document: 'customer': { 'first name': 'ben', 'address': {'line
1': '161 Azure Ln', } } . 'social' : [ { 'service: twitter'., 'handle': @bensmitg'}
social media is
a nested array
Customer > sales <product / sales person > Sales < warehouse
The data model is a
, Star schema
Customer > sales <product / sales person > Sales < warehouse
Customer is a
Dimension
The massively parallel processing (MPP) engine of Azure Synapse Analytics
distributes processing across compute nodes
A clustered index
is an object associated with a table that sorts and stores the data rows in the table based on their
key values
A relational database must be used when
strong consistency guarantees are required
Relation data uses ________ to enforce relationships between different tables
keys
A view
is a virtual table that contains content defined by a query
You need to query a table named Products in an Azure SQL database. Which three
requirements must be met to query the table from the internet?
Solutions
Descriptive Analytics tells you
what occurred in the past
Normalisation involves eliminating relationships between database tables
NO
Normalising a database reduces data redundancy
YES
Normalisation improves data integrity
YES
An extract, transform and load (ETL) process requires
that the data target be a relational database
In batch processing
latency is expected
Diagnostic
Why did sales increase last month?
Predictive
How do I allocate my budget to buy different inventory items?
Cognitive
,Which people are mentioned in a company's business documents?
Transcribing audio files is an examples of
cognitive analytics
You have the following JSON document: 'customer': { 'first name': 'ben', 'address': {'line
1': '161 Azure Ln', } } . 'social' : [ { 'service: twitter'., 'handle': @bensmitg'}
customer is
a root object
You have the following JSON document: 'customer': { 'first name': 'ben', 'address': {'line
1': '161 Azure Ln', } } . 'social' : [ { 'service: twitter'., 'handle': @bensmitg'}
address is
a nested object
You have the following JSON document: 'customer': { 'first name': 'ben', 'address': {'line
1': '161 Azure Ln', } } . 'social' : [ { 'service: twitter'., 'handle': @bensmitg'}
social media is
a nested array
Customer > sales <product / sales person > Sales < warehouse
The data model is a
, Star schema
Customer > sales <product / sales person > Sales < warehouse
Customer is a
Dimension
The massively parallel processing (MPP) engine of Azure Synapse Analytics
distributes processing across compute nodes
A clustered index
is an object associated with a table that sorts and stores the data rows in the table based on their
key values
A relational database must be used when
strong consistency guarantees are required
Relation data uses ________ to enforce relationships between different tables
keys
A view
is a virtual table that contains content defined by a query
You need to query a table named Products in an Azure SQL database. Which three
requirements must be met to query the table from the internet?
