Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Location Chicago IL, USA

Microsoft DP-900 Exam Actual Questions

The questions for DP-900 were last updated at Oct. 18, 2021.
  • Viewing page 1 out of 32 pages.
  • Viewing questions 1-4 out of 131 questions

Topic 1 - Single Topic

Question #1 Topic 1

HOTSPOT -
To complete the sentence, select the appropriate option in the answer area.
Hot Area:

Reveal Solution Hide Solution   Discussion   29

Correct Answer:
Reference:
https://demand-planning.com/2020/01/20/the-differences-between-descriptive-diagnostic-predictive-cognitive-analytics/

Question #2 Topic 1

HOTSPOT -
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:

Reveal Solution Hide Solution   Discussion   15

Correct Answer:
Reference:
https://www.sqlshack.com/what-is-database-normalization-in-sql-server/

Question #3 Topic 1

HOTSPOT -
To complete the sentence, select the appropriate option in the answer area.
Hot Area:

Reveal Solution Hide Solution   Discussion   92

Correct Answer:
In the ELT pipeline, the transformation occurs in the target data store. ELT only works well when the target system is powerful enough to transform the data efficiently.
Incorrect Answers:
✑ The data does not need to be fully processed: Often, the three ETL phases are run in parallel to save time. For example, while data is being extracted, a transformation process could be working on data already received and prepare it for loading, and a loading process can begin working on the prepared data, rather than waiting for the entire extraction process to complete.
✑ The target does need to be a relational database.
Reference:
https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/etl

Question #4 Topic 1

HOTSPOT -
To complete the sentence, select the appropriate option in the answer area.
Hot Area:

Reveal Solution Hide Solution   Discussion   7

Correct Answer:
Reference:
https://www.bmc.com/blogs/what-is-batch-processing-batch-processing-explained/


SaveCancel