Microsoft DP-900 (Azure Data Fundamentals)
Azure Data Fundamentals — core data concepts, relational and non-relational services, and analytics
Jump into a topic All 10 topics ↓
- Relational Data Concepts, Normalization & SQL16 questions
- Azure Storage: Blob, Data Lake, Files & Tables14 questions
- Data Formats, Storage & Databases12 questions
- Azure SQL Family & Open-Source Database Services12 questions
- Azure Cosmos DB & its APIs12 questions
- Data Warehousing & Ingestion Pipelines12 questions
- Batch & Stream Processing12 questions
- Transactional & Analytical Workloads10 questions
- Data Roles & Azure Data Services Overview8 questions
- Power BI & Data Visualization6 questions
100% free · no sign-up needed · works on any device
Where can I practise Microsoft DP-900 (Azure Data Fundamentals) for free?
PassNova offers free Microsoft DP-900 (Azure Data Fundamentals) practice questions covering core data concepts (structured, semi-structured and unstructured data, transactional versus analytical workloads, data roles), relational data and SQL (normalization, common SQL statements, the Azure SQL family and open-source database services), non-relational data (Azure Blob Storage, Data Lake Storage, Files, Tables and Azure Cosmos DB with its APIs) and analytics (data warehousing, ingestion pipelines, batch and stream processing, Microsoft Fabric and Power BI), each with a clear explanation. The real exam has a 700 pass score across four domains weighted 25–30% core concepts, 20–25% relational, 15–20% non-relational and 25–30% analytics. PassNova mirrors it — 100% free, no sign-up. Updated for 2026.
Last reviewed
A complete map of the Microsoft DP-900 syllabus
Tap a topic to start practising it — every question comes with a clear explanation. Or work the whole bank in study mode.
- Relational Data Concepts, Normalization & SQL16 questions
- Azure Storage: Blob, Data Lake, Files & Tables14 questions
- Data Formats, Storage & Databases12 questions
- Azure SQL Family & Open-Source Database Services12 questions
- Azure Cosmos DB & its APIs12 questions
- Data Warehousing & Ingestion Pipelines12 questions
- Batch & Stream Processing12 questions
- Transactional & Analytical Workloads10 questions
- Data Roles & Azure Data Services Overview8 questions
- Power BI & Data Visualization6 questions
Jobs and roles this helps you get
Microsoft's foundation-level data certification and a common on-ramp towards the Azure Database Administrator and Data Engineer certifications.
Database administrator (entry route)
Valued by employersMicrosoft positions DP-900 as useful preparation for the Azure Database Administrator Associate certification.
Official sourceData engineer (entry route)
Valued by employersMicrosoft positions DP-900 as useful preparation for the Azure Data Engineer Associate certification.
Official sourceData analyst / business analyst
Valued by employersCovers the core data concepts and Power BI fundamentals an analyst uses day to day.
National Careers ServiceRequirements are checked against the National Careers Service, the relevant regulator or the awarding body — follow each source for the current rules.
How you'll get exam-ready
Built to get you exam-ready
Instant, worked explanations
Every question — right or wrong — comes with a clear explanation, so you learn the why, not just the what.
Real, timed mock papers
Sit full-length papers under exam conditions and an indicative pass mark, so the day itself feels familiar.
A live readiness scoreFree + Premium
See how ready you are at a glance — Premium turns it into a predicted result.
Nova, your AI tutorPremium
Stuck on a question? Nova explains it step by step, in plain English, the moment you ask.
No paywall. No taster limit. No sign-up.
Every question and every mock paper for Microsoft DP-900 is free to practise. A free account just saves your progress — Premium is entirely optional.
Start practising free →- ✓All 114 questions across every topic
- ✓All 4 full mock papers
- ✓A worked explanation on every question
- ✓A live readiness score
- ✓No sign-up, no paywall, no limits
Mock papers under real conditions
DP-900 explained — Azure Data Fundamentals
DP-900: Microsoft Azure Data Fundamentals is Microsoft's entry-level data certification, intended for candidates beginning to work with data in the cloud. It earns the Microsoft Certified: Azure Data Fundamentals credential, which does not expire.
Format
Pass score 700 out of 1000; fundamentals exams run 45 minutes; UK price £64 at Pearson VUE. The skills measured were updated on 21 July 2026.
The four domains
- Describe core data concepts (25–30%): structured, semi-structured and unstructured data; common data file formats and data stores; transactional versus analytical workloads; the roles of database administrators, data engineers and data analysts.
- Identify considerations for relational data on Azure (20–25%): relational concepts, normalization, common SQL statements and database objects; the Azure SQL family (Azure SQL Database, Azure SQL Managed Instance, SQL Server on Azure Virtual Machines) and Azure's open-source database services.
- Describe considerations for working with non-relational data on Azure (15–20%): Azure Blob Storage, Azure Data Lake Storage Gen2, Azure Files and Azure Tables; the capabilities of Azure Cosmos DB and its APIs.
- Describe an analytics workload on Azure (25–30%): data warehousing architecture and ingestion pipelines; Microsoft Fabric and Azure Databricks for large-scale analytics; batch versus streaming data and real-time analytics; data visualization and modeling in Power BI.
How to revise
Work through Microsoft's four free learning paths, then use PassNova's topics, which map onto the same modules, in study mode until the concepts and service names are second nature. DP-900 rewards knowing which Azure service fits which scenario more than deep technical detail — finish with timed mocks once you can match a workload description to the right service without hesitating.
Free official practice & past papers
Straight from the exam body — official free practice and past papers for Microsoft DP-900 (Azure Data Fundamentals). PassNova's own questions are original exam-style practice; these are the awarding body's materials.
External official sites — free where shown; some may require a free account. Links open in a new tab.
Where the real exam comes from
PassNova is free practice — you sit the official Microsoft DP-900 (Azure Data Fundamentals) with the body that runs it.
External official sites — fees and booking are handled by the provider, not PassNova.
Microsoft DP-900 (Azure Data Fundamentals): your questions answered
Four domains, as of the 21 July 2026 skills measured: Describe core data concepts (25–30%) — ways to represent data, data storage options and common data workloads; Identify considerations for relational data on Azure (20–25%) — relational concepts, SQL and the Azure SQL family; Describe considerations for working with non-relational data on Azure (15–20%) — Azure storage and Cosmos DB; and Describe an analytics workload on Azure (25–30%) — data warehousing, ingestion, batch and stream processing, and Power BI.
The pass score is 700 out of 1000. Microsoft's fundamentals exams give you 45 minutes to complete the assessment. The UK price is £64, booked through Pearson VUE.
No. DP-900 is a fundamentals exam that tests concepts and service capabilities rather than hands-on configuration — you should be familiar with the ideas of relational versus non-relational data and transactional versus analytical workloads, but no SQL scripting or coding is required.
No, but Microsoft says you can use Azure Data Fundamentals to prepare for role-based certifications such as Azure Database Administrator Associate or Azure Data Engineer Associate. It is a useful on-ramp rather than a formal requirement.
Microsoft Fabric is Microsoft's unified analytics platform, and the DP-900 analytics domain covers it alongside classic Azure services — including OneLake (Fabric's unified data lake) and Fabric Real-Time Intelligence for stream processing. Expect questions on where Fabric components fit alongside data warehousing and Power BI.
Microsoft's foundation-level data certification and a common on-ramp towards the Azure Database Administrator and Data Engineer certifications. Database administrator (entry route): Microsoft positions DP-900 as useful preparation for the Azure Database Administrator Associate certification. Data engineer (entry route): Microsoft positions DP-900 as useful preparation for the Azure Data Engineer Associate certification. Data analyst / business analyst: Covers the core data concepts and Power BI fundamentals an analyst uses day to day.
Yes — Microsoft DP-900 (Azure Data Fundamentals) practice on PassNova is 100% free. There's no paywall and no sign-up needed to start. A free account is optional and only saves your progress and badges.
No. You can start practising Microsoft DP-900 (Azure Data Fundamentals) instantly with no account, no email and no card. 104 courses are fully free; every Premium question bank has a free 15-question taster.
PassNova has 114 exam-style Microsoft DP-900 (Azure Data Fundamentals) questions and 4 timed mock tests, each with a clear explanation, plus topic-by-topic study mode.
DP-900 (Microsoft Azure Data Fundamentals) is Microsoft's entry-level data certification. Verified against Microsoft Learn in September 2026: the skills measured were updated on 21 July 2026 and sit in four domains — Describe core data concepts (25–30%), Identify considerations for relational data on Azure (20–25%), Describe considerations for working with non-relational data on Azure (15–20%) and Describe an analytics workload on Azure (25–30%); the pass score is 700 out of 1000; Microsoft's fundamentals exams run 45 minutes; the UK price is £64 through Pearson VUE. The certification is Microsoft Certified: Azure Data Fundamentals — beginner level, no expiry — and is useful preparation for (but not a prerequisite of) the Azure Database Administrator Associate and Azure Data Engineer Associate certifications. No coding or hands-on configuration is required for DP-900; it tests concepts and service capabilities. PassNova's questions are written from the four official DP-900 learning paths and use Microsoft's current terminology, including Microsoft Fabric and OneLake alongside the established Azure SQL, Cosmos DB, Blob Storage and Data Lake Storage services. Check the study guide before you book.
Ready to pass your Microsoft DP-900?
No paywall, no sign-up. Jump straight into Microsoft DP-900 (Azure Data Fundamentals) practice and learn at your own pace.