Skip to main content
Ameerpet, Hyderabad · Classroom & live online
Cloud Soft Solutions

DP-900 Exam Guide 2026: Azure Data Fundamentals for Freshers, SQL, Cosmos DB, Fabric, 3-Week Plan and 15 Questions

DP-900 (Azure Data Fundamentals): pass mark 700, no prerequisites, skills updated 21 July 2026. Core data concepts, Azure SQL, Blob storage and Cosmos DB, analytics with Fabric, Databricks and Power BI, a 3-week plan and 15 questions for freshers.

DP-900 Azure Data Fundamentals exam guide 2026, Cloud Soft Solutions
Last updated · 5 min read · 1,057 words

DP-900 Azure Data Fundamentals exam guide 2026, Cloud Soft Solutions

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)

ItemDetail
CertificationMicrosoft Certified: Azure Data Fundamentals
LevelFundamentals; no prerequisites
Passing score700
Skills measuredAs of 21 July 2026 (minor changes to data representation, Azure storage and real-time analytics)
PracticeFree Practice Assessment; new version on AI Skills Navigator
PriceBased 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 areaWeight
Describe core data concepts25–30%
Identify considerations for relational data on Azure20–25%
Describe considerations for working with non-relational data on Azure15–20%
Describe an analytics workload25–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 typeExampleTypical Azure home
StructuredOrders table with fixed columnsAzure SQL Database
Semi-structuredJSON product catalogueAzure Cosmos DB
UnstructuredImages, videos, PDFsAzure 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;
OptionChoose it when
Azure SQL DatabaseNew cloud apps; fully managed; least admin work
Azure SQL Managed InstanceMoving an existing SQL Server with near-100% compatibility
SQL Server on Azure VMsYou 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

WeekFocusPractice
1Data types, file formats, OLTP vs OLAP, data roles; SQL basics and normalisationDP-900 Learn path modules 1–2; write 10 SQL queries
2Azure SQL family, open-source databases, Blob, Files, Table storage, Cosmos DB APIsCreate a free Azure SQL Database and a Cosmos DB account
3Analytics: lakehouse, Fabric, Databricks, streaming, Power BI; practice testsBuild 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

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).

Share𝕏inf✉
EnrollWhatsAppCall us