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
Which Azure SQL offering provides near-IOO percent compatibility with on-premises Microsoft SQL Server instances, while providing automated updates, backups, and maintenance tasks?
- A . Azure SQL Managed Instance
- B . SQL Server on Azure Virtual Machines
- C . Azure SQL Edge
- D . Azure SQL Database
Your company is designing a data store tor internet-connected temperature sensors. The collected data will be used to analyze temperature trends.
Which type of data store should you use?
- A . relational
- B . columnar
- C . graph
- D . time series
D
Explanation:
Time series data is a set of values organized by time. Time series databases typically collect large amounts of data in real time from a large number of sources. Updates are rare, and deletes are often done as bulk operations. Although the records written to a time-series database are generally small, there are often a large number of records, and total data size can grow rapidly.
Reference: https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview
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:
Box 1: Yes
For read access to the secondary region, configure your storage account to use read-access geo-redundant storage (RA-GRS) or read-access geo-zone-redundant storage (RA-GZRS).
Box 2: No
Box 3: Yes
Box 4: Yes
Azure Cosmos DB supports multi-region writes.
Reference:
https://docs.microsoft.com/en-us/azure/storage/common/storage-redundancy
https://manojchoudhari.wordpress.com/2019/12/16/azure-cosmos-db-enable-multi-region-writes
You have data saved in the following format.
Which format was used?
- A . HTML
- B . CSV
- C . JSON
- D . YAML
Which Azure Cosmos DB API should you use for a graph database?
- A . Azure Cosmos DB for Apache Gremlin
- B . Azure Cosmos DB for NoSQL
- C . Azure Cosmos DB for Apache Cassandra
- D . Azure Cosmos DB for Table
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://www.sqlshack.com/what-is-database-normalization-in-sql-server/
DRAG DROP
Match the types of activities to the appropriate Azure Data Factory activities.
To answer, drag the appropriate activity type from the column on the left to its Data Factory activity on the right. Each activity type may be used once, more than once, or not at all. NOTE: Each correct match is worth one point.
Explanation:
Reference: https://docs.microsoft.com/en-us/azure/data-factory/concepts-pipelines-activities#data-transformation-activities
You need to develop a solution to provide data to executives. the solution must provide an interactive graphic interface, depict various key performance indications, and support data exploration by using drill down.
What should you use in Microsoft Power BI?
- A . a dashboard
- B . Microsoft Power Apps
- C . a dataflow
- D . a report
D
Explanation:
Reference: https://docs.microsoft.com/en-us/power-bi/consumer/end-user-dashboards
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-kpi
https://docs.microsoft.com/en-us/power-bi/consumer/end-user-drill
HOTSPOT
To complete the sentence, select the appropriate option in the answer area.
