DP-900: Azure Data Fundamentals certification and exam guide
What the certification validates, who it is for, and the relational, non-relational, and analytics data topics it covers.
Read article Microsoft DP-900 Certification Study 
All articles · English
0 of 10 read 0%Core Data Concepts: Formats, Storage, and Processing
Study structured, semi-structured, unstructured, and vector data; file formats; relational and NoSQL models; OLTP, ACID, ETL, ELT, lakehouses, Fabric, Databricks, Purview, and Power BI.
Read articleData Roles and Microsoft Azure Data Services
Explore data roles, PaaS and SaaS, Azure SQL, Azure Storage, Data Factory, Microsoft Fabric, Power BI, Databricks, real-time analytics, Purview, and Foundry.
Read articleRelational Data, Normalization, SQL, and Database Objects
Study tables, keys, normalization, SQL dialects, DDL, DCL, DML, joins, views, stored procedures, indexes, and relational database performance trade-offs.
Read articleAzure Relational Database Services and Capabilities
Compare SQL Server on Azure VMs, Azure SQL Managed Instance, Azure SQL Database, elastic pools, serverless, Hyperscale, MySQL, and PostgreSQL services.
Read articleAzure Storage Services: Blob, Data Lake, OneLake, Files, and Tables
Compare blob types and access tiers, redundancy, Azure Data Lake Storage Gen2, OneLake, Azure Files, Azure File Sync, and Table Storage partitions.
Read articleAzure Cosmos DB: Architecture, Scale, Consistency, and APIs
Study the Cosmos DB hierarchy, partitions, global distribution, consistency levels, RU/s, throughput modes, autoscale, and five compatible APIs.
Read articleData Warehousing Architecture, Ingestion Pipelines, and Analytical Stores
Compare Microsoft Fabric and Azure Databricks, ETL and ELT, semantic models, ingestion choices, warehouses, lakes, lakehouses, and Delta Lake.
Read articleBatch and Stream Processing with Fabric Real-Time Intelligence and Spark
Compare batch and streaming, lambda and kappa patterns, windows, sources, sinks, Fabric Real-Time Intelligence, Structured Streaming, and Delta Lake.
Read articleData Modeling and Visualization with Microsoft Power BI
Study Power BI tools and workflow, Fabric integration, semantic models, star schemas, VertiPaq, hierarchies, visual selection, interactivity, Copilot, and AI visuals.
Read article
Practice Test 01 - Microsoft DP-900
Timed test with 50 questions on core data concepts, relational and non-relational data, and analytics workloads on Azure.
50 questions50 min
Open practice test Practice Test 02 - Microsoft DP-900
Timed test with 50 questions on core data concepts, relational and non-relational data, and analytics workloads on Azure.
50 questions50 min
Open practice test Practice Test 03 - Microsoft DP-900
Timed test with 50 questions on core data concepts, relational and non-relational data, and analytics workloads on Azure.
50 questions50 min
Open practice test Practice Test 04 - Microsoft DP-900
Timed test with 35 questions on core data concepts, relational and non-relational data, and analytics workloads on Azure.
35 questions35 min
Open practice test Practice Test 05 - Microsoft DP-900
Timed test with 35 questions on core data concepts, relational and non-relational data, and analytics workloads on Azure.
35 questions35 min
Open practice test Practice Test 06 - Microsoft DP-900
Timed test with 35 questions on core data concepts, relational and non-relational data, and analytics workloads on Azure.
35 questions35 min
Open practice test Practice Test 07 - Microsoft DP-900
Timed test with 35 questions on core data concepts, relational and non-relational data, and analytics workloads on Azure.
35 questions35 min
Open practice test Practice Test 08 - Microsoft DP-900
Timed test with 35 questions on core data concepts, relational and non-relational data, and analytics workloads on Azure.
35 questions35 min
Open practice test Practice Test 09 - Microsoft DP-900
Timed test with 66 questions on core data concepts, relational and non-relational data, and analytics workloads on Azure.
66 questions66 min
Open practice test