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
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/cosmos-db/high-availability
Which three actions are used when performing diagnostic analytics?
- A . • Identify data anomalies
• Collect anomaly-related data
• Discover relationships and trends that explain anomalies. - B . • Identify data anomalies
• Predict when anomalies are likely to recur
• Use analytical tools such as decision trees and regression. - C . • Apply serf-learning loops to draw inferences from anomalies.
• Predict when anomalies are likely to recur
• Use analytical tools such as decision trees and regression. - D . • Identify data anomalies
• Use machine learning to find patterns in large datasets.
• Discover relationships and trends that explain anomalies.
DRAG DROP
Match the datastore services to the appropriate descriptions.
To answer, drag the appropriate service from the column on the left to its description on the right.
Each service may be used once, more than once, or not at all. NOTE: Each correct match is worth one point.
Explanation:
Box 1: Azure Cosmos DB
In Azure Cosmos DB’s SQL (Core) API, items are stored as JSON. The type system and expressions are restricted to deal only with JSON types.
Box 2: Azure Files
Azure Files offers native cloud file sharing services based on the SMB protocol.
Reference:
https://docs.microsoft.com/en-us/azure/cosmos-db/sql-query-working-with-json
https://cloud.netapp.com/blog/azure-smb-server-message-block-in-the-cloud-for-azure-files
DRAG DROP
Match the types of analytics that can be used to answer the business questions.
To answer, drag the appropriate analytics type from the column on the left to its question on the right. Each analytics type may be used once, more than once, or not at all. NOTE: Each correct match is worth one point.
Explanation:
Reference: https://demand-planning.com/2020/01/20/the-differences-between-descriptive-diagnostic-predictive-cognitive-analytics/
HOTSPOT
To complete the sentence, select the appropriate option in the answer area.
Explanation:
Reference: https://docs.microsoft.com/en-us/sql/relational-databases/views/views
HOTSPOT
For each of the following statements, select yes if he statement is true, Otherwise select No. NOTE: Each correct selection 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.
What are three characteristics of an Online Transaction Processing (OLTP) workload? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point. (Choose three.)
- A . denormalized data
- B . heavy writes and moderate reads
- C . light writes and heavy reads
- D . schema on write
- E . schema on read
- F . normalized data
BDF
Explanation:
Reference: https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/online-transaction-processing
HOTSPOT
To complete the sentence, select the appropriate option in the answer area.
Explanation:
Reference: https://docs.microsoft.com/en-us/azure/storage/blobs/data-lake-storage-namespace
What should you use to build a Microsoft Power BI paginated report?
- A . Power BI report Builder
- B . Power BI Desktop
- C . Charticulator
- D . the Power BI service
A
Explanation:
Power BI Report Builder is the standalone tool for authoring paginated reports for the Power BI service.
https://docs.microsoft.com/en-us/power-bi/paginated-reports/paginated-reports-quickstart-aw