DP-900 Practice QUESTIONS with Correct
Verified Solutions
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.
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.
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.
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.
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.
Transcribing audio files is an example of <box 1> analytics.
Answer Area for <box 1>:
cognitive
descriptive
predictive
prescriptive
cognitive
Instruction
Match the types of analytics that can be used to answer the business questions. 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?
Diagnostic: Why did sales increase last month?
Prescriptive: How do I allocate my budget to buy different inventory items?
Descriptive: Which people are mentioned in a company’s business documents?
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?
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
Verified Solutions
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.
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.
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.
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.
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.
Transcribing audio files is an example of <box 1> analytics.
Answer Area for <box 1>:
cognitive
descriptive
predictive
prescriptive
cognitive
Instruction
Match the types of analytics that can be used to answer the business questions. 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?
Diagnostic: Why did sales increase last month?
Prescriptive: How do I allocate my budget to buy different inventory items?
Descriptive: Which people are mentioned in a company’s business documents?
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?
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
