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
What is a benefit of the Azure Cosmos DB Table API as compared to Azure Table storage?
- A . supports partitioning
- B . provides resiliency if art Azure region fads
- C . provides a higher storage capacity
- D . supports a multi-master model
D
Explanation:
Multi-master support for Azure Cosmos DB is now available in all public regions.
Azure CosmosDB table API is a key-value storage hosted in the cloud. It’s a part of Azure Cosmos DB, that is Microsoft’s multi-model database.
Reference: https://docs.microsoft.com/en-us/azure/cosmos-db/table-support
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:
YES, NO, YES Normalizing decreases throughput for reading (need to make joins), but increases for writing (Less to write, since there are no duplicates)
You need to create an Azure resource to store data in Azure Table storage.
Which command should you run?
- A . az scorage share create
- B . az scorage account creace
- C . az cosmosdb creace
- D . az scorage concainer creace
D
Explanation:
Reference: https://docs.microsoft.com/en-us/cli/azure/storage/container?view=azure-cli-latest
Which two Azure services can be used to provision Apache Spark clusters? Each correct answer
presents a complete solution. NOTE: Each correct selection is worth one point. (Choose two.)
- A . Azure Time Series Insights
- B . Azure HDInsight
- C . Azure Databricks
- D . Azure Log Analytics
BC
Explanation:
Reference: https://www.sqlshack.com/a-beginners-guide-to-azure-databricks/
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.
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.
HOTSPOT
To complete the sentence, select the appropriate option in the answer area.
Explanation:
Paginated Reports
https://powerbi.microsoft.com/en-us/blog/announcing-paginated-reports-in-power-bi-general-availability/
DRAG DROP
Match the Azure SQL services to the appropriate use cases.
To answer, drag the appropriate service from the column on the left to its use case on the right. Each service may be used once, more than once, or not at all. NOTE: Each correct match is worth one point.
What are two characteristics of real-time data processing? Each correct answer present a complete solution. NOTE: Each correct selection is worth one point.
- A . Data is processed as it is created.
- B . Low latency is expected
- C . High latency acceptable
- D . Data is processed periodically
AB
Explanation:
Real time processing deals with streams of data that are captured in real-time and processed with minimal latency to generate real-time (or near-real-time) reports or automated responses.
Reference: https://docs.microsoft.com/en-us/azure/architecture/data-guide/big-data/real-time-processing