# Azure Data Fundamentals DP-900 practice exams

> 5 timed DP-900 practice tests with 215 questions and a 70% pass mark. See your score in Describe core data concepts and every other domain.

Page: https://devopscodelab.com/exams/microsoft-dp-900/

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.

## Exam at a glance

| Setting | Value |
| --- | --- |
| 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 format before you book.

## Domains and weights

| Domain | Weight | 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 |

## Price and access

- DP-900 practice exams: $9.99 for 12 months of access.
- Free mini exam: 15 questions with explanations (free account): https://devopscodelab.com/app/exams/microsoft-dp-900/mini/
- All-Access subscription includes every exam: https://devopscodelab.com/pricing/
- 10 free questions with answers: https://devopscodelab.com/exams/microsoft-dp-900/free-practice-questions/

## 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
- B. Immediate consistency
- C. Strong consistency
- D. Two-phase commit consistency

**Answer:** A

**Explanation:** 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?

- A. A relational database with foreign keys
- B. A column-family store
- C. A graph database
- D. A key-value store

**Answer:** D

**Explanation:** 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?

- A. It reads only the needed column's data, which is stored together and compresses well
- 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

**Answer:** A

**Explanation:** 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.


## 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.

DevOpsCode Lab is not affiliated with Microsoft. DP-900 and related names are trademarks of their owners. We write every question ourselves; these are not real exam questions.
