Microsoft DP-900 Practice Exams
Last updated on Oct 23,2026- Exam Code: DP-900
- Exam Name: Microsoft Azure Data Fundamentals
- Certification Provider: Microsoft
- Latest update: Oct 23,2026
HOTSPOT
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. NOTE: Each correct selection is worth one point
Explanation:
Reference:
https://en.wikipedia.org/wiki/Snowflake_schema
https://azure.microsoft.com/en-us/blog/data-models-within-azure-analysis-services-and-power-bi/
HOTSPOT
To complement the sentence, select the appropriate option in the answer area.
What is a characteristic of batch processing?
- A . The data ingested during batch processing must be processed as soon as the data is received.
- B . Large datasets must be split into batches of less than 1 GB before the data can be processed.
- C . There is a noticeable time delay between ingesting data and obtaining the data processing results.
- D . Batch processing can only process data that is structured.
HOTSPOT
To complete the sentence, select the appropriate option in the answer area.
Explanation:
With ELT, the data store used to perform the transformation is the same data store where the data is ultimately consumed.
Reference: https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/etl
DRAG DROP
Match the job roles to the appropriate tasks.
To answer, drag the appropriate job role from the column on the left to its task on the right Each role may be used once, more than once, or not at all. NOTE: Each correct match is worth one point.
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.
Explanation:
Reference:
https://docs.microsoft.com/en-us/azure/databricks/scenarios/what-is-azure-databricks
https://docs.microsoft.com/en-us/azure/analysis-services/analysis-services-overview
https://docs.microsoft.com/en-us/azure/data-factory/introduction
HOTSPOT
Select the answer that correctly completes the sentence.
Explanation:
A treemap chart divides the chart area into rectangles that represent the different levels and relative sizes of the data hierarchy.
Reference: https://docs.microsoft.com/en-us/sql/reporting-services/report-design/tree-map-and-sunburst-charts-in-reporting-services?view=sql-server-ver15
HOTSPOT
You have the following SQL query.
NOTE: Each correct selection is worth one point.
DRAG DROP
Match the terms to the appropriate descriptions.
To answer, drag the appropriate term from the column on the left to its description on the right. Each term may be used once, more than once, or not at all. NOTE: Each correct match is worth one point.
Select the answer that correctly completes the sentence.
