
Exam DP-900: Microsoft Azure Data Fundamentals is the entry-level Azure data certification. It checks that you understand core data concepts, relational data in the Azure SQL family, non-relational data in Blob storage, Azure Files, Table storage and Cosmos DB, and analytics with Microsoft Fabric, Azure Databricks and Power BI. The skills measured were last updated on 21 July 2026. Students and freshers can take it without prior experience.
This guide follows the official study guide: four skill areas with weights, the data concepts in plain language, a 3-week plan and 15 original practice questions.
Quick facts (Microsoft Learn, November 2026)
| Item | Detail |
|---|---|
| Certification | Microsoft Certified: Azure Data Fundamentals |
| Level | Fundamentals; no prerequisites |
| Passing score | 700 |
| Skills measured | As of 21 July 2026 (minor changes to data representation, Azure storage and real-time analytics) |
| Practice | Free Practice Assessment; new version on AI Skills Navigator |
| Price | Based on the country where you take the exam (Pearson VUE); students can often get discounts |
Read the official DP-900 study guide before booking. DP-900 helps with role-based exams such as DP-700 and PL-300, but it isn't a prerequisite for them.
Skills measured and weights
| Skill area | Weight |
|---|---|
| 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% |
| Describe an analytics workload | 25–30% |
1. Core data concepts (25–30%)
- Structured, semi-structured and unstructured data.
- Common file formats (CSV, JSON, Parquet and others) and data stores; choosing Azure datastores for common uses.
- Transactional (OLTP) vs analytical (OLAP) workloads.
- Roles: database administrator, data engineer, data analyst.
| Data type | Example | Typical Azure home |
|---|---|---|
| Structured | Orders table with fixed columns | Azure SQL Database |
| Semi-structured | JSON product catalogue | Azure Cosmos DB |
| Unstructured | Images, videos, PDFs | Azure Blob storage |
2. Relational data (20–25%)
- Relational features; normalisation and why it's used; common SQL statements (DDL, DML); database objects such as views, indexes and stored procedures.
- The Azure SQL family: Azure SQL Database, Azure SQL Managed Instance, SQL Server on Azure VMs; Azure services for open-source databases (MySQL, PostgreSQL).
-- The SQL basics DP-900 expects you to recognise
CREATE TABLE customers (id INT PRIMARY KEY, name VARCHAR(100), city VARCHAR(50));
INSERT INTO customers VALUES (1, 'Ravi', 'Hyderabad');
SELECT city, COUNT(*) AS customers FROM customers GROUP BY city;
UPDATE customers SET city = 'Bengaluru' WHERE id = 1;
| Option | Choose it when |
|---|---|
| Azure SQL Database | New cloud apps; fully managed; least admin work |
| Azure SQL Managed Instance | Moving an existing SQL Server with near-100% compatibility |
| SQL Server on Azure VMs | You need full control of the OS and SQL Server |
3. Non-relational data (15–20%)
- Azure storage: Blob storage (objects and files for apps, data lakes); Azure Files (SMB/NFS file shares); Table storage (simple key-value).
- Azure Cosmos DB: use cases (global apps, low latency, flexible schema) and its APIs, such as NoSQL, MongoDB, Apache Cassandra, Apache Gremlin (graph) and Table.
4. Analytics (25–30%)
- Large-scale analytics: ingestion and processing; analytical stores (data warehouse, data lake, lakehouse); Microsoft services including Azure Databricks and Microsoft Fabric.
- Real-time analytics: batch vs streaming; Microsoft services for real-time data.
- Power BI: capabilities; data models (tables, relationships, measures); choosing the right visual.
3-week study plan
| Week | Focus | Practice |
|---|---|---|
| 1 | Data types, file formats, OLTP vs OLAP, data roles; SQL basics and normalisation | DP-900 Learn path modules 1–2; write 10 SQL queries |
| 2 | Azure SQL family, open-source databases, Blob, Files, Table storage, Cosmos DB APIs | Create a free Azure SQL Database and a Cosmos DB account |
| 3 | Analytics: lakehouse, Fabric, Databricks, streaming, Power BI; practice tests | Build one Power BI report; Practice Assessment twice; book the exam |
15 practice questions with answers
These are original practice questions written for this guide, not exam questions.
1. A JSON document with nested fields is which type of data?
Semi-structured.
2. Recording each bank transaction as it happens is which workload?
Transactional (OLTP).
3. Monthly sales trends across five years is which workload?
Analytical (OLAP).
4. Who builds pipelines that move and transform data?
A data engineer.
5. Splitting data into related tables to avoid duplication is called what?
Normalisation.
6. Which SQL statement adds new rows?
INSERT.
7. A company wants to move SQL Server with minimal code changes to a managed service. Which option?
Azure SQL Managed Instance.
8. Which Azure service hosts managed PostgreSQL?
Azure Database for PostgreSQL.
9. Where do you store millions of product images?
Azure Blob storage.
10. On-premises servers need a shared network drive in Azure. Which service?
Azure Files.
11. A global mobile app needs single-digit millisecond reads and a flexible schema. Which database?
Azure Cosmos DB.
12. An existing MongoDB app should move to Azure with few changes. Which Cosmos DB API?
The API for MongoDB.
13. Data from IoT sensors must be analysed as it arrives. Batch or streaming?
Streaming (real-time) analytics.
14. Which Microsoft SaaS platform brings data engineering, warehousing, real-time analytics and Power BI together?
Microsoft Fabric.
15. Which visual best shows sales over time?
A line chart.
After DP-900
- Choose a role-based path: PL-300 (Power BI analyst), DP-600 (Fabric analytics engineer) or DP-700 (Fabric data engineer).
- Read the data analyst roadmap for freshers and practise SQL interview questions.
- See live jobs for freshers.
Cloud Soft Solutions in Ameerpet, Hyderabad teaches SQL, Power BI, Microsoft Fabric and Azure data engineering for freshers with real-time projects. See the APEX program and all courses.
📞 Call +91 96660 19191 · WhatsApp · Flat No. 513, 5th Floor, Nilagiri Block, Aditya Enclave, Ameerpet, Hyderabad
Frequently Asked Questions
Is DP-900 good for freshers?
Yes. It is a fundamentals exam with no prerequisites, for people beginning to work with data in the cloud.
What is the DP-900 passing score?
700.
Which DP-900 skill areas have the most weight?
Describe core data concepts and describe an analytics workload, each at 25–30%.
When were the DP-900 skills last updated?
The current skills measured apply as of 21 July 2026.
Does DP-900 cover Microsoft Fabric?
Yes. Microsoft Fabric and Azure Databricks are named as Microsoft services for large-scale analytics.
What should I take after DP-900?
PL-300 (Power BI analyst), DP-600 (Fabric analytics engineer) or DP-700 (Fabric data engineer).



