Microsoft DP-900 Practice Exam Questions & Answers

7 Free Questions Last reviewed November 15, 2026 Prepared & Reviewed by the ValidExamDumps Editorial Team

372 Practice Questions (Our Bank)
45 minutes Exam Duration
700 out of 1000 Passing Score
USD 99 Official Exam Fee (United States)
Exam Facts

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
Practice Questions

Free DP-900 Practice Questions

Each question shows the correct answer and an explanation of why it is right

VA
ValidExamDumps Editorial Team Every question and its answer is checked by our DP-900 exam preparation team, who also write the explanation shown with each one. How we research and review these pages

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?

Correct Answer D
Explanation

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?

Correct Answer A
Explanation

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.

Correct Answer A, C

Get the complete DP-900 question set $20$40

Get Full Access

Question 4 Domain 2 Identify considerations for relational data on Azure

Which command-line tool can you use to query Azure SQL databases?

Correct Answer A

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?

Correct Answer D
Explanation

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?

Correct Answer B

Question 7 Domain 3 Describe considerations for working with non-relational data on Azure

Which type of database contains nodes and edges?

Correct Answer A
Explanation

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.

Study Guide

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.

Sample questions from this domain above Q2Q3Q4

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.

Sample questions from this domain above Q5Q7

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

FAQ

DP-900 Exam FAQ

Common questions about the exam itself

Is DP-900 a beginner exam or do I need prior data experience?
DP-900 is designed for candidates beginning to work with data in the cloud and assumes only foundational knowledge of core data concepts. You should have familiarity with basic IT tasks and simple data-related concepts like reading tables and charts, but no prior professional data experience is required.
How long should I study to prepare for DP-900?
Preparation time varies depending on your background, but most candidates spend between two to four weeks studying. Microsoft recommends combining self-paced learning modules on Microsoft Learn with hands-on practice in the Azure portal to reinforce the concepts.
What is the passing score for DP-900?
You need a score of 700 or greater out of 1000 to pass the DP-900 exam.
Can I take DP-900 as an online proctored exam or only at a test centre?
DP-900 is proctored and can be taken either online from your home or office or at a Pearson VUE test centre. Both options are available when you schedule your exam.
Is DP-900 a prerequisite for the Azure Data Engineer Associate or Azure Database Administrator Associate certifications?
No, DP-900 is not a prerequisite for either of these role-based certifications. However, passing DP-900 provides useful foundational knowledge that can help you prepare for them.
What is the hardest domain in DP-900 and how should I approach it?
Most candidates find the analytics workload domain challenging because it introduces multiple Azure services like Azure Databricks, Microsoft Fabric, and Power BI. Get hands-on experience in the Azure portal exploring these services and work through practical scenarios involving data ingestion and visualization.
How many questions are on the DP-900 exam and how much time do I have?
The exam contains multiple question types and formats. You have 45 minutes of testing time to complete the exam, which may include interactive components as part of the assessment.
How long is my DP-900 certification valid after I pass?
Microsoft certifications remain valid for a set period and have renewal requirements. Check your certification details in your Microsoft Learn profile for the specific validity period and renewal options for your DP-900 credential.
Can I retake DP-900 if I fail the first attempt?
Yes, you can retake the exam. Microsoft allows you to schedule retakes following their standard exam policies. There is typically a waiting period between attempts, so check the scheduling system for current retake requirements.
What job roles does DP-900 prepare me for?
DP-900 prepares you for foundational roles working with Azure data services, including entry-level positions in data engineering, data analysis, and database administration. It is designed to launch you toward role-based certifications in these specializations rather than a specific job itself.

Other Microsoft Exams

Free practice questions for more Microsoft certification exams

All Microsoft exams