Microsoft · DP-900 · Fundamentals
Microsoft Azure Data Fundamentals (DP-900) — Practice Questions and Mock Exam
Practice real DP-900 questions, never dumps. Alex explains every answer, and your readiness score tells you when you're ready to pass.
Checked against Microsoft · July 2026Current exam version
Overview
About the exam
The DP-900 certification demonstrates foundational knowledge of core data concepts and how they are implemented using Azure data services. It covers relational and non-relational data, analytics workloads, data storage, data processing, and Azure services such as Azure SQL, Azure Cosmos DB, Azure Synapse Analytics, Azure Data Factory, and Microsoft Fabric. The exam tests conceptual understanding rather than hands-on implementation.
This is an ideal starting point for anyone exploring data roles or wanting to understand Azure data services, including IT professionals, students, business analysts, and aspiring data engineers or database administrators. No prior data experience is required, making it accessible to those beginning their data platform journey.
Exam Domains
What's on the exam
The exam consists of 40–60 questions to be completed in approximately 45 minutes. Question types include multiple-choice, multiple-select, drag-and-drop, and hot area formats. Questions focus on identifying correct data concepts and matching them to Azure services rather than testing implementation details. Pace yourself steadily as most questions are concept-based and straightforward.
Ways to represent data, options for data storage, common data workloads, and roles and responsibilities for data workloads
Relational concepts including normalization and SQL statements, and Azure relational data services including Azure SQL family and open-source databases
Azure storage capabilities including Blob, File, and Table storage, and Azure Cosmos DB capabilities and APIs
Large-scale analytics elements, real-time data analytics, and data visualization in Microsoft Power BI
SourceMicrosoft study guide
Format
What to expect
Watch out
Where candidates struggle
Despite being a fundamentals exam, DP-900 covers both relational and non-relational data paradigms plus analytics. Candidates who focus only on SQL databases often miss questions about Cosmos DB, data lakes, and analytics services.
- 01Data Model Types — Confusing relational, document, key-value, graph, and column-family data models and which Azure service supports each.
- 02OLTP vs OLAP — Not clearly distinguishing transactional (OLTP) from analytical (OLAP) workloads and the Azure services suited for each.
- 03Azure Data Services — Mixing up Azure SQL Database, Azure Cosmos DB, Azure Data Lake Storage, and Azure Synapse Analytics use cases.
- 04ETL vs ELT — Struggling to differentiate ETL and ELT patterns and when to use Azure Data Factory vs Synapse pipelines vs Fabric.
- 05Data Visualization — Overlooking Power BI concepts and how they relate to the broader Azure data analytics ecosystem.
Details
Exam logistics
Delivered via Pearson VUE online or at testing centers. Available in English, Japanese, Chinese, Korean, French, German, Spanish, Portuguese, and more. This fundamentals certification does not expire and requires no renewal.
SourceMicrosoft exam page
Before you book the exam
Would you pass DP-900 today?
Take the free readiness check. Answer real DP-900 questions and get your readiness score across every domain.
Take the free readiness check20 questions · freeReach 80% readiness by exam day. Pass, or your money back.