Microsoft DP-900 Practice Exam Questions & Answers
Microsoft DP-900 Exam Details
Key details for this exam, checked against the published exam outline
- Exam Code
- DP-900
- Full Name
- Microsoft Azure Data Fundamentals
- Issuing Body
- Microsoft
- Question Format (Our Bank)
- Multiple Choice, Hotspot, Drag & Drop
- Delivery
- Online proctored exam through Pearson VUE or in-person at a testing center
- Eligibility
- No prerequisites or prior certification required
- Full Question Set
- 372 questions Get All Questions
Free DP-900 Practice Questions
Each question shows the correct answer and an explanation of why it is right
Question 1 Domain 4 Describe an analytics workload
A bank needs to ensure that after an account transfer transaction completes, the revised account balances persists even if the database system hosting the transaction becomes temporarily unavailable.
Of which ACID semantic is this an example?
This is an example of the Durability semantic in ACID (Atomicity, Consistency, Isolation, Durability):
- Durability ensures that once a transaction is committed, the data persists permanently, even in the event of system failures, crashes, or temporary unavailability
- In the scenario, after the account transfer completes and the revised balances are committed, the data is guaranteed to persist regardless of what happens to the database system afterward
The other ACID properties are:
- Atomicity - Transaction is all-or-nothing
- Consistency - Data moves from one valid state to another
- Isolation - Concurrent transactions don't interfere with each other
Question 2 Domain 2 Identify considerations for relational data on Azure
You need to implement a visual that will display the stages of a sales pipeline and the number of leads from each stage. Which type of visual should you use?
A Funnel chart is the ideal visual for displaying the sales pipeline because:
- Pipeline Stages - Funnel charts excel at showing sequential stages or steps in a process, which perfectly represents the stages of a sales pipeline (e.g., Prospecting, Qualification, Proposal, Negotiation, Closed)
- Comparative Values - The chart displays the number of leads at each stage, typically getting smaller as you move through stages, showing the natural filtering or conversion that occurs in a sales pipeline
- Visual Clarity - Funnel charts use progressively narrowing sections to intuitively communicate how quantities decrease through each stage
Other alternatives like bar charts or column charts could show the data but would not convey the sequential, flowing nature of a pipeline as effectively as a funnel chart.
Question 3 Domain 2 Identify considerations for relational data on Azure
At which two levels can you set the throughput for an Azure Cosmos DB account? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
Get the complete DP-900 question set
$20$40
Question 4 Domain 2 Identify considerations for relational data on Azure
Which command-line tool can you use to query Azure SQL databases?
Question 5 Domain 3 Describe considerations for working with non-relational data on Azure
Which setting can only be configured during the creation of an Azure Cosmos DB account?
You must create a separate account for each API.
https://docs.microsoft.com/en-us/azure/cosmos-db/how-to-manage-database-account
Question 6 Domain 1 Describe core data concepts
You have a SQL pool in Azure Synapse Analytics that is only used actively every night for eight hours.
You need to minimize the cost of the SQL pool during idle times. The solution must ensure that the data
remains intact.
What should you do on the SQL pool?
Question 7 Domain 3 Describe considerations for working with non-relational data on Azure
Which type of database contains nodes and edges?
A graph database is the type of database that contains nodes and edges. Nodes represent entities (data points), and edges represent the relationships or connections between those entities. Graph databases are optimized for traversing relationships and are useful for scenarios involving social networks, recommendation systems, knowledge graphs, and complex relational queries.
What the Microsoft DP-900 Exam Covers
Exam domains verified against the Official Microsoft DP-900 exam guide, last checked November 2026.
Domain 1 Describe core data concepts
25% - 30%Covers the fundamentals of how data is represented and stored, including structured, semi-structured, and unstructured formats. Also covers common data storage options and the different types of workloads such as transactional and analytical processing, plus the roles and responsibilities of database administrators, data engineers, and data analysts in managing data systems.
Sample question from this domain above Q6
Domain 2 Identify considerations for relational data on Azure
20% - 25%Focuses on relational database concepts including normalization, schema design, and SQL fundamentals. Covers the Azure SQL product family including Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machines, as well as open-source database options available on Azure.
Domain 3 Describe considerations for working with non-relational data on Azure
15% - 20%Explores Azure storage services including Blob storage, Files, and Table storage, along with their specific use cases. Also covers Azure Cosmos DB, a multi-model database service, including its various APIs and scenarios where it is the right choice for applications.
Domain 4 Describe an analytics workload
25% - 30%Covers large-scale data analytics concepts including ingestion, processing, and storage of analytical data. Includes Microsoft cloud services like Azure Databricks and Microsoft Fabric, as well as real-time analytics solutions, and data visualization using Power BI including models and appropriate chart selection.
Sample question from this domain above Q1
DP-900 Exam FAQ
Common questions about the exam itself
Is DP-900 a beginner exam or do I need prior data experience?
How long should I study to prepare for DP-900?
What is the passing score for DP-900?
Can I take DP-900 as an online proctored exam or only at a test centre?
Is DP-900 a prerequisite for the Azure Data Engineer Associate or Azure Database Administrator Associate certifications?
What is the hardest domain in DP-900 and how should I approach it?
How many questions are on the DP-900 exam and how much time do I have?
How long is my DP-900 certification valid after I pass?
Can I retake DP-900 if I fail the first attempt?
What job roles does DP-900 prepare me for?
Other Microsoft Exams
Free practice questions for more Microsoft certification exams
