DP-900: Microsoft Azure Data Fundamentals
Ace DP-900 Azure Data Fundamentals with free practice questions on relational data, non-relational data, analytics workloads, and data processing on Azure.
Pick how to study
The DP-900 exam
- Questions: 288
What DP-900 covers
Every question and flashcard is mapped to the DP-900: Microsoft Azure Data Fundamentals skills outline so you only revise what is on the exam.
- Describe core data concepts
- Identify considerations for relational data on Azure
- Describe considerations for working with non-relational data on Azure
- Describe an analytics workload on Azure
Why earn the DP-900 certification in 2026
DP-900 is Microsoft's fundamentals-level certification for Azure data services. Microsoft aims it at candidates beginning to work with data in the cloud, with familiarity with relational and non-relational data concepts. There is no prerequisite certification. The exam covers core data concepts, relational data on Azure, non-relational data on Azure, and analytics workloads, naming Azure Databricks, Microsoft Fabric, Power BI, the Azure SQL family, and Azure Cosmos DB.
Who should sit this exam
People starting out with data on Azure, including future database administrators, data engineers and data analysts, and business staff who work alongside data teams.
Exam tips
- Know structured, semi-structured and unstructured data, and common formats for data files
- Compare Azure SQL Database, Azure SQL Managed Instance and SQL Server on Azure Virtual Machines
- Match Azure Blob storage, Azure Files, Azure Table storage and the Azure Cosmos DB APIs to use cases
- Review batch and streaming data, Microsoft Fabric, Azure Databricks and Power BI data models
DP-900 skill areas and weights
The DP-900 skills outline was updated on 21 July 2026. The change log lists minor edits to three objective groups: ways to represent data, the capabilities of Azure storage, and real-time data analytics.
- Describe core data concepts: 25 to 30%
- Identify considerations for relational data on Azure: 20 to 25%
- Describe considerations for working with non-relational data on Azure: 15 to 20%
- Describe an analytics workload on Azure: 25 to 30%
Source: Microsoft Learn study guide for DP-900, skills measured as of 21 July 2026.
DP-900 traps: free decision sheets
Each sheet settles one choice the exam tests, with every rule cited to a practice question.
- Which Cosmos DB API to choose: NoSQL vs MongoDB vs Cassandra vs Gremlin vs Table
- Which data file format fits (CSV/JSON/XML vs Avro vs Parquet)
- Which data role owns a task: data engineer vs database administrator vs data analyst
- Which data store type fits the workload (relational vs document vs key-value vs graph vs time-series)
- OneLake vs Lakehouse vs Warehouse vs Shortcut: which Fabric analytics piece fits
- Line vs column vs pie vs scatter vs map: which Power BI visual fits the goal
- Power BI Desktop vs Power BI service (author vs publish and share)
- Which relational database object fits: index vs view vs stored procedure
- Primary key vs foreign key in a relational table
- Azure SQL Database compute choice: single database vs elastic pool vs serverless
- SQL Server on Azure VM vs Azure SQL Managed Instance vs Azure SQL Database vs Azure Database for MySQL/PostgreSQL
- Which category of SQL statement (DDL vs DML vs DCL)
- Blob vs Files vs Table vs Queue: which Azure Storage service fits the workload
DP-900 study resources
- Build a study plan: tell us your exam date and we schedule daily practice and review sessions backwards from the date.
- Decision sheets: each sheet settles one choice between look-alike services, verdict first, then the comparison, then the traps.
- DP-900 comparison: how AzurePrep, MeasureUp, and Whizlabs compare for DP-900.
Frequently asked about DP-900
How many questions are in the DP-900 practice exam?
The DP-900 practice exam covers core data concepts, relational and non-relational data, analytics workloads, and data visualization on Azure. The current question count is shown on the DP-900 landing page.
Is the DP-900 practice exam free?
DP-900 offers 10 free preview questions to help you evaluate the platform. For full access to the complete question bank, upgrade to a paid subscription.
What data services does DP-900 cover?
DP-900 covers Azure SQL Database, Cosmos DB, Azure Synapse Analytics, Azure Data Factory, Azure Databricks, Power BI, and both relational and non-relational database concepts.
Other Fundamentals certifications
Ready for DP-900?
Try the practice surface for free. Answer a few questions, see the spacing loop, then decide. Try 10 free DP-900 questions or browse the catalogue.
AzurePrep is an independent practice-exam platform and is not affiliated with or endorsed by Microsoft.