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
DRAG DROP
Match the processes to the appropriate scenarios.
To answer, drag the appropriate process from the column on the left to its scenario on the right. Each process may be used once, more than once, or not at all. NOTE: Each correct match is worth one point.
In a fully denormalized database, how is data read and written for a single entity?
- A . Data is read from a single table and written to a single table.
- B . Data is read from multiple tables and written to a single table.
- C . Data is read from a single table and written to multiple tables.
- D . Data is read from multiple tables and written to multiple tables.
HOTSPOT
To complete the sentence, select the appropriate option in the answer area.
Explanation:
Reference: https://www.sqlshack.com/graph-database-implementation-with-azure-cosmos-db-using-the-api/
HOTSPOT
To complete the sentence, select the appropriate option in the answer area.
Explanation:
A View
What are two benefits of platform as a service (PaaS) relational database offerings in Azure, such as Azure SQL Database? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
- A . complete control over backup and restore processes
- B . access to the latest features
- C . in-database machine learning services
- D . reduced administrative effort for managing the server infrastructure
B, C
Explanation:
Azure SQL Database is a fully managed platform as a service (PaaS) database engine that handles most of the database management functions such as upgrading, patching, backups, and monitoring without user involvement.
SQL Database delivers predictable performance with multiple resource types, service tiers, and compute sizes. It provides dynamic scalability with no downtime, built-in intelligent optimization, global scalability and availability, and advanced security options. These capabilities allow you to focus on rapid app development and accelerating your time-to-market, rather than on managing virtual machines and infrastructure.
Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview
HOTSPOT
Select the answer that correctly completes the sentence.
For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.
Select the answer that correctly completes the sentence.
