All study guides
DP-900

Azure Data Fundamentals Study Guide

A study path for Microsoft Certified: Azure Data Fundamentals — what to know before you start, and the order worth doing things in.

Exam at a glance

Length45 min (65 min seat time)
Questions40–60
Passing score700 / 1000
FormatsMultiple choice, drag-and-drop, hot area — no case studies
Microsoft Learn accessNot available (closed-book)
RenewalDoes not expire
PrerequisiteNone

DP-900: exam domains

Key areas covered in the exam, weighted by how much of the exam they make up.

25-30%
Describe core data concepts
Structured, semi-structured, and unstructured data, plus common data roles
20-25%
Identify considerations for relational data on Azure
Azure SQL, PostgreSQL, MySQL, and SQL Managed Instance
15-20%
Describe considerations for non-relational data on Azure
Azure Cosmos DB, storage accounts, and data lake storage
25-30%
Describe an analytics workload on Azure
Modern data warehousing, ingestion, processing, and visualization

Where this exam fits

Prerequisites

None — DP-900 is an entry-level exam. General familiarity with core data concepts (what a database is, structured vs unstructured data) is helpful but not assumed.

Recommended background

  • Core data concepts — structured, semi-structured, and unstructured data
  • Relational vs non-relational database basics
  • General awareness of analytics workloads (batch vs streaming)

Step-by-step study plan

1
Review the official study guide

Open Microsoft's official skills-measured breakdown and use it as your checklist — it's updated whenever the exam changes.

Official DP-900 study guide
2
Schedule your exam

Pick a date through the official Microsoft certification page and plan your study time backwards from it. Give yourself 2–4 weeks if you already use the tech weekly, 4–8 weeks if you're newer to it.

Exam & scheduling page
3
Go through the official learning path

Complete Microsoft's free, self-paced modules for this exam. Take notes on anything you can't explain simply — that's what to revisit.

Official documentation
4
Get hands-on practice

DP-900 rewards recognizing real scenarios and trade-offs, not memorization. Spin up a free-tier environment and actually try the concepts — resource provisioning, networking, access controls — rather than just reading about them.

5
Benchmark your knowledge

Use FabricPrep's DP-900 practice questions to find weak spots, and sit the timed Shield exam to build comfort with exam-day pacing.

Practice DP-900 now — 72 free questions
6
Take the exam

The day before: review only your weak topics, don't cram new material. On exam day: read each question carefully, eliminate wrong answers first, and watch for wording that implies a constraint (least privilege, cost, performance).

Additional resources

Ready to test yourself?

72 realistic DP-900 practice questions with instant feedback and detailed explanations.

Practice DP-900 now