DP-900

Azure Data Fundamentals DP-900 practice exams

215 questions in 5 timed practice tests. Each test has about 45 questions and a 45-minute limit. The pass mark is 70%. Results are split across the 4 exam domains.

Read the DP-900 study guide: what the exam covers, a 4-week plan and the topics people miss.

Exam at a glance

DP-900 practice exam settings
Practice tests 5
Questions in total 215
Questions per test About 45
Time limit per test 45 minutes
Pass mark 70%
Question types Single answer and multiple answer (20 multiple-answer questions)
Level Foundational
Category Data & Analytics

These are the settings of our practice tests. Check the official Microsoft exam page for the current exam format before you book.

Domains and weights

DP-900 exam domains, weights and question counts
Domain Weight Weight bar Questions in our bank
Describe core data concepts 29% 62
Identify considerations for relational data on Azure 24% 52
Describe considerations for working with non-relational data on Azure 18% 39
Describe an analytics workload on Azure 29% 62

Sample questions

Question 1 of 3

A globally replicated database lets a write in one region become visible in other regions after a short delay, and readers may briefly see older values. Which consistency model does this describe?

  1. A Eventual consistency (correct answer)
  2. B Immediate consistency
  3. C Strong consistency
  4. D Two-phase commit consistency
Why: With eventual consistency, replicas converge over time, so a read in another region may return a stale value until the write propagates. Strong or immediate consistency would guarantee that every read sees the latest committed write, and two-phase commit is a protocol that coordinates a transaction across participants so they commit together, which avoids rather than allows stale reads.

Question 2 of 3

A shopping cart service only ever looks up a cart by its cart ID and replaces the whole cart value on every change. Which type of non-relational data store is the simplest fit?

  1. A A relational database with foreign keys
  2. B A column-family store
  3. C A graph database
  4. D A key-value store (correct answer)
Why: A key-value store retrieves and writes an opaque value by its unique key, which matches lookups and replacements by cart ID with very low latency. Graph databases model relationships between entities, column-family stores organize wide rows into column groups for large sparse datasets, and a relational database adds schema and join overhead that this access pattern does not need.

Question 3 of 3

A reporting query sums one column across 500 million rows of a 60-column table. Why would a columnar store usually complete this query faster than a row store?

  1. A It reads only the needed column's data, which is stored together and compresses well (correct answer)
  2. B It stores each row as a JSON document, so the engine can read individual properties
  3. C It enforces foreign keys between tables, which lets the optimizer skip unrelated rows
  4. D It keeps every row in memory, so no data has to be read from disk at query time
Why: Columnar storage groups each column's values together, so an aggregate over one column reads a small fraction of the data, and similar values compress efficiently. Columnar stores do not require holding all rows in memory, foreign keys do not reduce the data scanned for a single-table aggregate, and storing rows as JSON documents describes a document store, not a columnar one.

What your score report looks like

Example attempt, DP-900 practice test 3

75%

Passed
Pass mark 70%

Score by exam domain
DomainWeightYour score%
Describe core data concepts 29%
88
Identify considerations for relational data on Azure 24%
81
Describe considerations for working with non-relational data on Azure 18%
76
Describe an analytics workload on Azure 29%
58

Study next: Describe an analytics workload on Azure. It is below the pass mark and carries 29% of the exam.

Domains and pass mark from our DP-900 practice tests. Scores are an example attempt.

Study plans

Two weeks

  1. Day 1: take practice test 1 in exam mode to get a baseline.
  2. Days 2 to 5: domain mode on Describe core data concepts and Describe an analytics workload on Azure, the two most heavily weighted domains.
  3. Day 6: practice test 2 in exam mode, then the mistakes quiz.
  4. Days 7 to 12: practice tests 3 to 5, one every other day, each followed by its mistakes quiz.
  5. Days 13 and 14: final mode. Book the exam when your readiness stays above the pass mark.

Four weeks

  1. Week 1: one practice test in practice mode, reading every explanation. Note your two lowest domains.
  2. Week 2: domain mode on those two domains, then a second practice test in exam mode.
  3. Week 3: practice tests 3 and 4 in exam mode, with the mistakes and flagged quizzes after each.
  4. Week 4: practice test 5 and final mode until your readiness holds above the pass mark.

Questions about the DP-900 practice exams

Are these real DP-900 exam questions?
No. We write every question ourselves and map it to the published DP-900 exam objectives. We do not use leaked or recalled questions.
Do the time limit and pass mark match the official exam?
They match the settings of our practice tests. Exam providers change their format from time to time, so check the official exam page before you book.
Can I try it before I pay?
Yes. The free mini exam has 15 questions with full explanations and needs no account.
How long do I keep access?
A single-exam purchase gives you 12 months of access. All-Access includes this exam for as long as your subscription runs.
What happens after I finish a test?
You get a score, a pass or fail against the pass mark, a score per domain and every answer with its explanation.

Last updated November 2026. Written and reviewed by the DevOpsCode Lab team.

DevOpsCode Lab is not affiliated with Microsoft. DP-900 and related names are trademarks of their owners.

Related exams
Exam Vendor Level Questions Minutes Price
AB-400Power Platform Developer AB-400 (formerly PL-400) Microsoft Associate 251 100 $12.99
AB-410AB-410 Building Intelligent Applications Microsoft Associate 250 100 $12.99
AB-620Copilot Studio AB-620 Microsoft Associate 251 100 $12.99
AI-103Azure AI Apps & Agents AI-103 Microsoft Associate 250 100 $12.99
AI-200Azure AI Cloud Developer AI-200 Microsoft Associate 250 100 $12.99
AI-300AI-300 ML and Generative AI Operations Microsoft Associate 251 100 $12.99