Azure Mastery Exam DP-900 Download
Azure Mastery

Microsoft Certification DP-900

DP-900: Predict your score. Know what to study next.

See your predicted score, follow a study plan based on your answers, and revisit topics you're starting to forget. It all runs on your device.

346 practice questions AI score prediction 100% offline
Download free iPhone & iPad · Free to start QR code — scan with your iPhone to open Azure Mastery on the App Store On your Mac?
Scan to install

DP-900 Practice Questions & Exam Prep — Microsoft Azure Data Fundamentals

Get exam-ready for DP-900 (Microsoft Azure Data Fundamentals) on iPhone or iPad. Azure Mastery uses on-device AI to predict your readiness score, build a personalised study plan, and surface topics you're forgetting. Core study stays on-device and works offline; optional sync uses your private iCloud account.

The exam

What is the DP-900 exam?

DP-900 is the Microsoft Certified: Azure Data Fundamentals credential — the entry-level exam for anyone working with data in the Microsoft Azure cloud. It's pitched at candidates who have basic familiarity with relational vs non-relational data and transactional vs analytical workloads, but doesn't require database-administration experience.

Common audiences include data analysts about to step into Power BI work, software engineers crossing into a data role, and product/operations partners who need to discuss data architecture credibly.

The exam doesn't ask you to write SQL queries from scratch or design a star schema. It expects you to recognise scenarios:

Microsoft updated the DP-900 skills outline on 21 July 2026. Every question in Azure Mastery's DP-900 bank is mapped to the current outline — no leftover questions on retired services. Read the official outline at learn.microsoft.com.

Skills measured · 21 July 2026

DP-900 exam objectives

Four domains, with weights set by Microsoft's 21 July 2026 update. Every domain below lists Microsoft's own skill groups verbatim from the official skills outline, so you always know which domain you're being tested on and where your weak spots cluster.

Aura presents a visual map of data sources, transformation, storage, and analysis skills.
Data skill map

Describe core data conceptsPublished weight 25–30%

89 exam-scoped practice questions in the app

Explore Core Data topics
  • Describe ways to represent data
  • Identify options for data storage
  • Describe common data workloads
  • Identify roles and responsibilities for data workloads
  • Telling structured, semi-structured, and unstructured data apart, then matching a dataset to the right database type, is the core skill here.
  • Get the OLTP vs OLAP split wrong here and every later domain gets harder to reason about.
  • Learn the four data roles by task, not job title: database admin, data engineer, data analyst, data scientist.

Identify considerations for relational data on AzurePublished weight 20–25%

86 exam-scoped practice questions in the app

Explore Relational topics
  • Describe relational concepts
  • Describe relational Azure data services
  • Tests choosing between Azure SQL Database, SQL Managed Instance, and SQL Server on Azure VMs for a stated need.
  • The wrong SQL option usually gets picked because it sounds similar to the right one, not because the scenario was misread.
  • Match migration, compatibility, and management-overhead clues to exactly one of the three options before answering.

Describe considerations for working with non-relational data on AzurePublished weight 15–20%

68 exam-scoped practice questions in the app

Explore Non-Relational topics
  • Describe the capabilities of Azure storage
  • Describe the capabilities and features of Azure Cosmos DB
  • Picking the right storage shape — Blob tier, Table storage, or a Cosmos DB API — matters more than writing a query.
  • Candidates treat Cosmos DB's five APIs as interchangeable when each is built around a different data model.
  • Match relationships and traversals to Gremlin, existing MongoDB code to the MongoDB API — not whichever sounds newest.

Describe an analytics workload on AzurePublished weight 25–30%

103 exam-scoped practice questions in the app

Explore Analytics topics
  • Describe common elements of large-scale analytics
  • Describe considerations for real-time data analytics
  • Describe data visualization in Microsoft Power BI
  • Tests warehousing concepts, Microsoft Fabric vs Synapse Analytics, ingestion, streaming, and Power BI visualisation choices.
  • Candidates default to Fabric on every question since recent outline updates, but some scenarios still point at Synapse specifically.
  • Read what the scenario actually asks about — ingestion, unified analytics, or a warehousing feature — before picking a service.

Common traps

Where DP-900 candidates slip

Five recurring misconceptions that trip up otherwise well-prepared DP-900 candidates, grounded in the current skills outline.

OLTP and OLAP describe workloads, not products

Candidates try to memorise which service is OLTP or OLAP, but the same service can support either depending on how it's configured.

  • Many small transactions point to OLTP; large aggregated reads point to OLAP — the access pattern is the tell, not the service name.
  • Read the workload description, not a product name, before deciding whether it's OLTP or OLAP.

Three SQL options solve overlapping but different problems

Azure SQL Database, Managed Instance, and SQL Server on a VM all run SQL Server workloads, which makes them feel interchangeable.

  • Azure SQL Database is fully managed, Managed Instance targets instance-level compatibility, and a VM hands you the whole OS.
  • A named compatibility or control requirement in the scenario usually rules out two of the three straight away.

A Cosmos DB API choice is a data-model choice, not a preference

Cosmos DB's five APIs aren't styling options on one database — each commits you to a different underlying data model.

  • Relationships and traversals point to Gremlin; existing MongoDB code points to the MongoDB API — the data shape decides it.
  • Pick the API the data model calls for, never the one that simply sounds more modern.

Microsoft Fabric and Azure Synapse Analytics aren't competitors in every question

Candidates default to picking Fabric on every analytics question since it expanded in recent skills-outline updates.

  • A Synapse pipeline or dedicated-pool feature named specifically in the scenario still rules out the default Fabric answer.
  • Read what the scenario is actually asking — ingestion, a unified experience, or one warehousing feature — before choosing.

Structured, semi-structured, and unstructured are about shape, not size

Unstructured doesn't mean unimportant or small — it means the data doesn't fit a predefined schema.

  • Video files and free text stay unstructured regardless of size, while JSON or XML count as semi-structured whatever their length.
  • Get this classification wrong and it cascades into picking the wrong storage service for the described file type.

Designed for DP-900

How Azure Mastery helps you pass DP-900

Exam-specific practice

  • 346 DP-900 practice questions, each written against the current 21 July 2026 skills outline.
  • Every question is tagged to one of the official four domains.
  • Practise recognising a data shape or service fit — the exam's actual scenario style, not raw recall.

Predicted score

  • Exam IQ forecasts your DP-900 score on-device after roughly 30 questions, with a confidence range attached.
  • It names the specific SQL, Cosmos DB, or analytics topic dragging your score down.
  • See which of the four domains needs the most work before you book.

Adaptive study plan

  • Your plan leans hardest on analytics workloads, the domain Microsoft weights joint-heaviest at 25–30%.
  • Miss a Fabric or Cosmos DB API question and the next session surfaces that domain first.
  • Master a topic across three sessions and the plan backs off it automatically.

Knowledge decay

  • DP-900's domains reinforce each other — forget OLTP vs OLAP and relational and analytics both get harder.
  • A padlock icon flags topics approaching decay so you revisit before you forget.
  • Weak-spot drills automatically pull from decayed topics first.

Exam rehearsal

  • Practise a full 45-minute session with no jumping back to flag-and-review, like the real exam.
  • The mix follows the published domain weights, using original questions rather than reproduced content.
  • The live DP-900 interface and question mix are Microsoft's to control, not ours.

Answer Coach

  • Untangles DP-900's near-identical service choices: SQL Managed Instance vs Azure SQL Database, Gremlin vs MongoDB.
  • See the specific distinction and the rule to apply next time, beyond simply which option was correct.
  • Supported devices can optionally reword a note on-device, always checked against the written guidance first.

Aura guidance

  • Aura adjusts what it suggests as your first week of DP-900 sessions goes on.
  • Get a short recap after each session: what shifted, what needs another look, where to go next.

Private by design

  • Your DP-900 answer history, readiness gauge, and Answer Coach notes stay private by default.
  • No Azure Mastery account or server ever touches your study data.
  • Optional sync uses your private iCloud account.

2-week revision plan

Suggested DP-900 study plan

Build a map of data concepts and Azure services in the first week. Use the second week of this route for focused revision and timed practice.

  1. Core data concepts

    • Study the core data concepts first.
    • Use practice questions to check understanding.
    • Review explanations before moving on.

  2. Relational data

    • Compare Azure SQL Database and Managed Instance.
    • Review SQL Server on Azure VMs.
    • Match each service to a scenario.

  3. Non-relational data

    • Explore Cosmos DB API options.
    • Review Azure Storage tiers.
    • Practise selecting a suitable service.

  4. Analytics workloads

    • Compare Microsoft Fabric and Synapse Analytics.
    • Review Data Factory and Stream Analytics.
    • Explore Power BI scenarios.

  5. Target weaker topics

    • Run Focus Weak Spots sessions.
    • Review explanations for missed questions.
    • Revisit topics you have not practised recently.

  6. Timed rehearsal

    • Complete two 45-minute Exam Simulator sessions.
    • Review each run carefully.
    • Record topics that need more attention.

  7. Check your progress

    • Complete another simulator session.
    • Look for recurring mistakes.
    • Use the results to plan any further study.

  8. Light review

    • Revisit your key notes.
    • Allow time to rest.
    • Decide whether you are ready to move ahead.

Inside the app

Nine interactive practice formats, on iPhone

Azure Mastery has nine interactive formats for exam practice. The examples below show original DP-900 practice questions in Azure Mastery on iPhone and iPad. The exam simulator uses timed sessions with the published domain weights. Microsoft's live interface and question mix may differ.

Which file format stores data as plain text with values separated by commas?

  • ORC
  • CSV
  • Avro
  • Parquet

Multiple choice

An original DP-900 practice question with one correct answer. The app explains every option after you answer.

Exam-specific sample

Which TWO of the following file formats use columnar storage? Select TWO.

  • Avro
  • CSV
  • ORC
  • Parquet

Multi-select

An original DP-900 multi-select question. Select all the correct options to earn the mark.

All-or-nothing

Drag-and-drop

An original DP-900 ordering question you can answer by touch on iPhone and iPad.

Interactive item

Hotspot

An original DP-900 question with a visual prompt, designed for touch on iPhone and iPad.

Tap target

Case studies

An original DP-900 case study with several questions about the same requirements and environment.

Multi-question

Answer Coach

Answer Coach explains why the answer is correct and, where available, why each option is right or wrong. It helps you understand a mistake and remember the distinction. Read explanations after each question or at the end of a practice test. On supported devices, optional AI can reword a note on your device after checking it against the written guidance.

App exclusive

Frequently asked

DP-900 FAQs

Do I need database experience before sitting DP-900?

Very little. Microsoft doesn't expect database-administration experience or hands-on SQL — just a basic sense of what a spreadsheet, a database, and "the cloud" are. If you can explain why a company might store data in more than one place, you already have enough of a starting point.

What does the DP-900 exam actually look like?

DP-900 gives you 45 minutes for the assessed portion. Microsoft says Fundamentals exams usually contain 35–50 items, although the exact count and interaction types can change. Azure Master's original data-fundamentals bank includes single-answer, scenario, multi-select, drag-and-drop, dropdown, hotspot, and linked case-study practice.

DP-900 vs PL-900 — which should I take first?

Neither is a prerequisite for the other, so pick based on your role. DP-900 covers data concepts and Azure's data services; PL-900 covers the low-code Power Platform — Power Apps, Power Automate, Dataverse, Copilot Studio. Data people start with DP-900, business makers with PL-900.

What's the DP-900 exam fee, and does it vary by region?

The DP-900 voucher costs USD $99 in the United States, or around £77 in the UK. Microsoft occasionally runs free-voucher promotions around events like Build or Ignite — check your Learn profile before booking.

Is a passed DP-900 permanent, or does it lapse?

No — Fundamentals certifications including AZ-900, DP-900, AI-901, MS-900, and PL-900 don't expire. Once you pass, it's yours for life. Associate and Expert certs such as DP-300 or AZ-104 are different — those need an annual free renewal assessment.

Is relational vs non-relational the hardest DP-900 call?

For most candidates, yes. DP-900 repeatedly asks you to match a workload to the right storage model — a relational schema with joins, or a document, key-value, or graph store built for a different access pattern. Answer Coach flags exactly which property should have driven the choice.

I failed DP-900 once — what's the wait before I can resit?

Each DP-900 retake needs its own voucher, and the wait time depends on your attempt number.

  • First retake: after 24 hours.
  • Second and third retakes: a 14-day wait each.
  • Cap: five attempts per rolling 12 months.
Is DP-900 worth sitting if I'm not a developer or DBA?

Yes. Microsoft designed DP-900 for technical and non-technical candidates alike — data analysts moving into Power BI, engineers crossing into a data role, product managers who need the vocabulary. Nobody writes a SQL query; you just pick the right service for a described scenario.

Can I try Azure Mastery's DP-900 bank before paying?

Yes — the app is free to download, with a free allowance of DP-900 questions so you can try every feature. The full bank of 346 DP-900 practice questions unlocks with a one-time exam-pack purchase, or unlock every exam with a subscription or lifetime upgrade.

Can I revise for DP-900 with no internet connection?

Yes. Question practice, scoring, and the readiness prediction all run on-device, so a flight or a commute with no signal is no obstacle. No account is required, and your study data stays on your device with optional private iCloud sync.

Free study guides

Free guides that pair with DP-900

Where DP-900 fits

Certification paths that start with DP-900

DP-900 is the foundational entry point for Microsoft's Data and BI role-based tracks. It's optional but strongly recommended — Microsoft markets it as preparation for the Database Administrator and Data Engineer Associate paths, even though it's not a formal prerequisite. If your interest is general Azure infrastructure, look at AZ-900 (Azure Fundamentals) instead.

Database Administrator path

Associate tier
  1. DP-900 Fundamentals
  2. DP-300 Database Administrator Associate

MLOps and GenAIOps path

Associate tier
  1. DP-900 Fundamentals
  2. AI-901 recommended sibling
  3. AI-300 MLOps Engineer Associate

Power BI Data Analyst path

Associate tier
  1. DP-900 Fundamentals
  2. PL-300 Power BI Data Analyst Associate

Ready to pass DP-900?

Download Azure Mastery free. 346 DP-900 practice questions, AI score prediction, and a personalised study plan that adapts to your weak spots. iPhone & iPad.

Download Azure Mastery — free iPhone & iPad · Free to start · No account required
DP-900 practice — free on the App Store Download