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
Your company needs to design a database that shows how changes traffic in one area of a network
affect other components on the network.
Which type of data store should you use?
- A . Key/value
- B . Graph
- C . Document
- D . columnar
B
Explanation:
Data as it appears in the real world is naturally connected. Traditional data modeling focuses on defining entities separately and computing their relationships at runtime. While this model has its advantages, highly connected data can be challenging to manage under its constraints.
A graph database approach relies on persisting relationships in the storage layer instead, which leads to highly efficient graph retrieval operations. Azure Cosmos DB’s Gremlin API supports the property graph model.
Reference: https://docs.microsoft.com/en-us/azure/cosmos-db/graph-introduction#introduction-to-graph-databases
Select the answer that correctly completes the sentence.
Which Azure SQL offering supports automatic database scaling and automatic pausing of the database during inactive periods?
- A . Azure SQL Database Hyperscale
- B . Azure SQL managed instance
- C . Azure SQL Database serveless
- D . Azure SQL Database elastic pod
What is required to provision Azure Data Lake Storage in an Azure Storage account?
- A . Versioning must be enabled.
- B . Hierarchical namespace must be enabled.
- C . Hierarchical namespace must be disabled.
- D . Versioning must be disabled.
HOTSPOT
To complete the sentence, select the appropriate option in the answer area.
Explanation:
Reference: https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/etl
DRAG DROP
Match the Azure services to the appropriate locations in the architecture.
To answer, drag the appropriate service from the column on the left to its location on the right. Each service may be used once, more than once, or not at all. NOTE: Each correct match is worth one point.
Your company has a reporting solution that has paginated reports. The reports query a dimensional model in a data warehouse.
Which type of processing does the reporting solution use?
- A . stream processing
- B . Online Transaction Processing (OLTP)
- C . batch processing
- D . Online Analytical Processing (OLAP)
B
Explanation:
Reference: https://datawarehouseinfo.com/how-does-oltp-differ-from-olap-database/
DRAG DROP
Match the types of workloads the appropriate scenario.
To answer, drag the appropriate workload type from the column on the left to its scenario on the right. Each workload type may be used once, more than once or not at all. NOTE: Each correct match is worth one point.
