DP-900 study guide: Azure Data Fundamentals exam domains, plan and common mistakes
Written and reviewed by the DevOpsCode Lab Team. Last updated 19 November 2026.
DP-900 is the Microsoft Azure Data Fundamentals exam. It checks that you understand core data concepts and how Azure handles them: relational databases, non-relational stores, and analytics workloads. It is a common first step for people heading toward data engineering, database administration or reporting roles, and it gives useful background for PL-300 and DP-700.
What the exam tests
DP-900 tests understanding, not hands-on configuration. Questions describe a kind of data or a workload (“store JSON product catalogs”, “run nightly loads into a reporting store”, “query files in a data lake with SQL”) and ask which concept or Azure service fits. You need to recognize data formats, workload types and roles, and match them to the right Azure option.
Domains and how much each counts
| Domain | Weight | What to be able to do | Questions in our bank |
|---|---|---|---|
| Describe core data concepts | 29% | Structured, semi-structured and unstructured data; file formats such as CSV, JSON, Parquet and Avro; transactional (OLTP) versus analytical (OLAP) workloads; database administrator, data engineer and data analyst roles | 62 |
| Identify considerations for relational data on Azure | 24% | Tables, keys and normalization; basic SQL statements (DDL and DML); views, indexes and stored procedures; Azure SQL Database, Azure SQL Managed Instance, SQL Server on Azure VMs and Azure Database for PostgreSQL and MySQL | 52 |
| Describe considerations for working with non-relational data on Azure | 18% | Azure Blob Storage, Data Lake Storage Gen2, Azure Files and Table storage; Azure Cosmos DB and its APIs (NoSQL, MongoDB, PostgreSQL, Cassandra, Gremlin, Table) | 39 |
| Describe an analytics workload on Azure | 29% | Batch versus streaming data; ingestion and ETL/ELT pipelines; data warehouses and lakehouses; Microsoft Fabric and Azure Databricks; real-time analytics; Power BI reports, dashboards and data models | 62 |
Core concepts and analytics together are well over half of the exam. Non-relational data is the smallest domain, but Cosmos DB API questions show up often enough to be worth a focused session.
Exam format
Our practice tests use 45 questions in 45 minutes with a 70% pass mark. Microsoft reports results on a 1–1000 scale with 700 to pass, and the live exam mixes multiple choice with formats such as drag and drop and yes or no statements. Check the official Microsoft exam page for the current format, price and objectives before you book.
Who should take it
- People starting a career in data who want a structured overview of Azure data services.
- Developers, analysts and administrators who work near data and want the shared vocabulary.
- Candidates planning PL-300 or DP-700 who want the fundamentals first.
No prior Azure experience is required. Some familiarity with spreadsheets or basic SQL makes the relational domain much faster.
A 2-week study plan
| Week | Focus | Practice |
|---|---|---|
| 1 | Core data concepts and relational data: data types and formats, OLTP versus OLAP, roles, SQL basics, normalization, the Azure SQL family and open-source database services | Practice mode on the first two domains; take one full test at the end of the week as a baseline |
| 2 | Non-relational and analytics: storage options, Cosmos DB APIs, batch and streaming, warehouses and lakehouses, Fabric, Databricks and Power BI | Domain quizzes for both domains, then two full timed tests and the mistakes quiz; book the exam when you score 80%+ twice |
Create a free Azure account and run a few SELECT, INSERT and JOIN statements against a sample Azure SQL database. Writing the queries once makes the SQL questions easy points.
Topics people often get wrong
- OLTP versus OLAP. OLTP systems handle many small reads and writes with normalized tables; OLAP systems handle large read-heavy queries over denormalized, historical data.
- DDL versus DML. CREATE, ALTER and DROP are DDL and change structure; SELECT, INSERT, UPDATE and DELETE are DML and work with the rows themselves.
- Azure SQL options. Azure SQL Database is a fully managed single database or pool; SQL Managed Instance gives near-complete SQL Server compatibility for lift and shift; SQL Server on a VM gives full control of the OS and instance, and you manage it.
- Cosmos DB APIs. The API is chosen per account and matches the data model and existing code: MongoDB for document apps already using MongoDB drivers, Gremlin for graphs, Cassandra for wide column, Table for key-value apps moving from Table storage.
- Batch versus stream processing. Batch processes collected data on a schedule with higher latency; streaming processes each event or small window as it arrives.
- Data lake versus data warehouse. A data lake stores raw files in any format; a warehouse stores modeled, relational data for reporting. A lakehouse combines both on open file formats.
How to use the practice tests
Start with the free DP-900 questions to see the style. Then take one full timed test in exam mode for a baseline and look at the score by domain. Spend most of your time in the two weakest domains with domain quizzes, and finish with the mistakes quiz before each new full test. The readiness number tells you when your recent scores hold above the pass mark across all four domains.
Frequently asked questions
How hard is DP-900? It is an entry-level exam. People who already work with databases often need about a week of review; newcomers to data usually need two.
Do I need to know SQL? Only the basics. You should read simple SELECT, INSERT, UPDATE and JOIN statements and know what DDL and DML are. You will not write complex queries.
Does the certification expire? No. Microsoft fundamentals certifications do not expire, so there is no renewal assessment.
Are these the real exam questions? No. Every question is written by us for the published skills outline. We never use leaked or recalled exam content.
DevOpsCode Lab is not affiliated with or endorsed by Microsoft. Exam names are trademarks of their owners. Check the official Microsoft exam page for the current price, format and objectives before you book.