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
| 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
| 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?
- A Eventual consistency (correct answer)
- B Immediate consistency
- C Strong consistency
- D Two-phase commit consistency
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?
- A A relational database with foreign keys
- B A column-family store
- C A graph database
- D A key-value store (correct answer)
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?
- A It reads only the needed column's data, which is stored together and compresses well (correct answer)
- B It stores each row as a JSON document, so the engine can read individual properties
- C It enforces foreign keys between tables, which lets the optimizer skip unrelated rows
- D It keeps every row in memory, so no data has to be read from disk at query time
See all 10 free DP-900 questions with answers Read them or quiz yourself.
What your score report looks like
Example attempt, DP-900 practice test 3
75%
Passed
Pass mark 70%
| Domain | Weight | Your 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.
Study plans
Two weeks
- Day 1: take practice test 1 in exam mode to get a baseline.
- Days 2 to 5: domain mode on Describe core data concepts and Describe an analytics workload on Azure, the two most heavily weighted domains.
- Day 6: practice test 2 in exam mode, then the mistakes quiz.
- Days 7 to 12: practice tests 3 to 5, one every other day, each followed by its mistakes quiz.
- Days 13 and 14: final mode. Book the exam when your readiness stays above the pass mark.
Four weeks
- Week 1: one practice test in practice mode, reading every explanation. Note your two lowest domains.
- Week 2: domain mode on those two domains, then a second practice test in exam mode.
- Week 3: practice tests 3 and 4 in exam mode, with the mistakes and flagged quizzes after each.
- 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.
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 |