DP-900 Exam 2025- QUESTIONS with Correct
Verified Solutions
Descriptive analytics
What occured in the past
Yes or no: Normalization involves eliminating relationships between database tables
No
Yes or no: normalizing a database reduces redundancy
Yes
Yes or no: normalization improves data integrity
Yes
Complete the sentence: An extract, transform, and load (etl) process requires
A target data store powerful enough to transform data
Complete the sentence: In batch processing
Latency is expected
Transcribing audio files is an example of what type of analytics?
Cognitive
What type of analytics would answer: why did sales increase last month
Diagnostic
, What type of analytics would answer: how do I allocate my budget to buy different
inventory items?
Prescriptive
What type of analytics would answer: which people are mentioned in a companies business
documents ?
Descriptive
The massively parallel processing (map) engine of azure synapse analytics...
Distributes processing across compute nodes
______ is an object associated with a table that sorts and stores the data rows in the table
based in their key values
A clustered index
A relational database is appropriate for scenarios that involve a high volume of...
Transactional writes
Yes or no: batch processing can output data to a file store
Yes
Yes or no: Batch processing can output data to a relational database
No
Batch processing can output data to a noSQL database
No
Verified Solutions
Descriptive analytics
What occured in the past
Yes or no: Normalization involves eliminating relationships between database tables
No
Yes or no: normalizing a database reduces redundancy
Yes
Yes or no: normalization improves data integrity
Yes
Complete the sentence: An extract, transform, and load (etl) process requires
A target data store powerful enough to transform data
Complete the sentence: In batch processing
Latency is expected
Transcribing audio files is an example of what type of analytics?
Cognitive
What type of analytics would answer: why did sales increase last month
Diagnostic
, What type of analytics would answer: how do I allocate my budget to buy different
inventory items?
Prescriptive
What type of analytics would answer: which people are mentioned in a companies business
documents ?
Descriptive
The massively parallel processing (map) engine of azure synapse analytics...
Distributes processing across compute nodes
______ is an object associated with a table that sorts and stores the data rows in the table
based in their key values
A clustered index
A relational database is appropriate for scenarios that involve a high volume of...
Transactional writes
Yes or no: batch processing can output data to a file store
Yes
Yes or no: Batch processing can output data to a relational database
No
Batch processing can output data to a noSQL database
No
