DP-900 EXAM ELABORATIONS
1. Question
Descriptive analytics tells you <box 1> Answer Area for <box
1>:
what is most likely to occur in the future. what occurred in the
past.
which actions you can perform to affect outcomes.
why something occurred in the past.: what occurred in the past.
2. For each of the following statements, select Yes if the statement is true. Otherwise, select No.
Question
Normalization involves eliminating relationships between database tables. Normalizing a database reduces data
redundancy.
Normalization improves data integrity.: No. Yes.
Yes.
3. Instruction
To complete the sentence, select the appropriate option in the answer area. Question
An extract, transform, and load (ETL) process requires <box 1> Answer Area for <box 1>:
a matching schema in the data source and the data target. a target data store powerful
enough to transform data.
data that is fully processed before being loaded to the target data store.
that the data target be a relational database.: Answer
data that is fully processed before being loaded to the target data store.
1/
56
, DP-900 EXAM ELABORATIONS
Explanation
Extract, transform, and load (ETL) is a data pipeline used to collect data from various sources, transform the data
according to business rules, and load it into a destination data store.
4. In batch processing, <box 1>
Answer Area for <box 1>:
data is always inserted one row at a time. data is processed in
real-time.
latency is expected.
processing can only execute serially.: latency is expected.
5. Transcribing audio files is an example of <box 1> analytics.
Answer Area for <box 1>:
cognitive descriptive
predictive
prescriptive: cognitive
6. Instruction
Match the types of analytics that can be used to answer the business ques- tions. Each analytics type may be used
once, more than once, or not at all.
Question Analytics Types:
Cognitive Diagnostic
Descriptive Predictive
Prescriptive
Business Questions:
Why did sales increase last month?
How do I allocate my budget to buy different inventory items?
Which people are mentioned in a company's business documents?: Diagnos- tic: Why did sales increase last month?
Prescriptive: How do I allocate my budget to buy different inventory items? Descriptive: Which people are mentioned in
company's business documents?
2/
56
, DP-900 EXAM ELABORATIONS
Explanation
Descriptive, to answer the question: What's happening? Diagnostic, to answer the question:
Why's happening?
Predictive, to answer the question: What will happen?
Prescriptive, to answer the question: What actions should we take?
7. You have the following JSON document.
Use the drop-down menus to select the answer choice that completes each statement based on the information
presented in the JSON document.
Customer is <box 1>. Answer Area
for <box 1>:
a nested array a
nested object a root
object
Address is <box 2>. Answer Area for
<box 2>:
a nested array a
nested object a root
object
Social media is <box 3>. Answer
Area for <box 3>:
a nested array a
nested object
a root object: <box 1>: a root object
<box 2>: a nested object
<box 3>: a nested array
8. You are reviewing the data model shown in the following exhibit.
Use the drop-down menus to select the answer choice that completes each statement based on the information
presented in the graphic.
The data model is a <box 1>. Answer Area for <box
1>: transactional model
star schema snowflake
schema
3/
56
, DP-900
Study online at
https://quizlet.com/_brbjvz
Customer is a <box 2> table. Answer Area for <box
2>:
fact dimension
bridge: <box 1>: star schema
<box 2>: dimension
9. The massively parallel processing (MPP) engine of Azure Synapse Analytics
<box 1>
Answer Area for <box 1>:
distributes processing across compute nodes. distributes processing across
control nodes. redirects client connections across compute nodes.
redirects client connections across control nodes.: distributes processing across compute nodes.
10.<box 1> is an object associated with a table that sorts and stores the data rows in the table based on their key
values.
Answer Area for <box 1>:
A clustered index A
FileTable
A foreign key
A stored procedure: A clustered index
11.A relational database is appropriate for scenarios that involve a high volume of <box 1>
Answer Area for <box 1>:
changes to relationships between entities geographically
distributed writes transactional writes
writes that have varying data structures: transactional writes
12.For each of the following statements, select Yes if the statement is true. Otherwise, select No.
Question
Batch processing can output data to a file store.
Batch processing can output data to a relational database.
4/
56
1. Question
Descriptive analytics tells you <box 1> Answer Area for <box
1>:
what is most likely to occur in the future. what occurred in the
past.
which actions you can perform to affect outcomes.
why something occurred in the past.: what occurred in the past.
2. For each of the following statements, select Yes if the statement is true. Otherwise, select No.
Question
Normalization involves eliminating relationships between database tables. Normalizing a database reduces data
redundancy.
Normalization improves data integrity.: No. Yes.
Yes.
3. Instruction
To complete the sentence, select the appropriate option in the answer area. Question
An extract, transform, and load (ETL) process requires <box 1> Answer Area for <box 1>:
a matching schema in the data source and the data target. a target data store powerful
enough to transform data.
data that is fully processed before being loaded to the target data store.
that the data target be a relational database.: Answer
data that is fully processed before being loaded to the target data store.
1/
56
, DP-900 EXAM ELABORATIONS
Explanation
Extract, transform, and load (ETL) is a data pipeline used to collect data from various sources, transform the data
according to business rules, and load it into a destination data store.
4. In batch processing, <box 1>
Answer Area for <box 1>:
data is always inserted one row at a time. data is processed in
real-time.
latency is expected.
processing can only execute serially.: latency is expected.
5. Transcribing audio files is an example of <box 1> analytics.
Answer Area for <box 1>:
cognitive descriptive
predictive
prescriptive: cognitive
6. Instruction
Match the types of analytics that can be used to answer the business ques- tions. Each analytics type may be used
once, more than once, or not at all.
Question Analytics Types:
Cognitive Diagnostic
Descriptive Predictive
Prescriptive
Business Questions:
Why did sales increase last month?
How do I allocate my budget to buy different inventory items?
Which people are mentioned in a company's business documents?: Diagnos- tic: Why did sales increase last month?
Prescriptive: How do I allocate my budget to buy different inventory items? Descriptive: Which people are mentioned in
company's business documents?
2/
56
, DP-900 EXAM ELABORATIONS
Explanation
Descriptive, to answer the question: What's happening? Diagnostic, to answer the question:
Why's happening?
Predictive, to answer the question: What will happen?
Prescriptive, to answer the question: What actions should we take?
7. You have the following JSON document.
Use the drop-down menus to select the answer choice that completes each statement based on the information
presented in the JSON document.
Customer is <box 1>. Answer Area
for <box 1>:
a nested array a
nested object a root
object
Address is <box 2>. Answer Area for
<box 2>:
a nested array a
nested object a root
object
Social media is <box 3>. Answer
Area for <box 3>:
a nested array a
nested object
a root object: <box 1>: a root object
<box 2>: a nested object
<box 3>: a nested array
8. You are reviewing the data model shown in the following exhibit.
Use the drop-down menus to select the answer choice that completes each statement based on the information
presented in the graphic.
The data model is a <box 1>. Answer Area for <box
1>: transactional model
star schema snowflake
schema
3/
56
, DP-900
Study online at
https://quizlet.com/_brbjvz
Customer is a <box 2> table. Answer Area for <box
2>:
fact dimension
bridge: <box 1>: star schema
<box 2>: dimension
9. The massively parallel processing (MPP) engine of Azure Synapse Analytics
<box 1>
Answer Area for <box 1>:
distributes processing across compute nodes. distributes processing across
control nodes. redirects client connections across compute nodes.
redirects client connections across control nodes.: distributes processing across compute nodes.
10.<box 1> is an object associated with a table that sorts and stores the data rows in the table based on their key
values.
Answer Area for <box 1>:
A clustered index A
FileTable
A foreign key
A stored procedure: A clustered index
11.A relational database is appropriate for scenarios that involve a high volume of <box 1>
Answer Area for <box 1>:
changes to relationships between entities geographically
distributed writes transactional writes
writes that have varying data structures: transactional writes
12.For each of the following statements, select Yes if the statement is true. Otherwise, select No.
Question
Batch processing can output data to a file store.
Batch processing can output data to a relational database.
4/
56
