EnglishDeutschFrançaisEspañolPortuguês

Microsoft · DP-900 · Fundamentals

Microsoft Azure Data Fundamentals

The DP-900 certification demonstrates foundational knowledge of core data concepts and how they are implemented using Azure data services. 50+ AI-generated practice questions with explanations. Free trial, pass guarantee.

Start Free Trial

7-day free trial, no credit card required

50 Questions
45min Time Limit
700/ 1000 Pass Score

About the exam

The DP-900 certification demonstrates foundational knowledge of core data concepts and how they are implemented using Azure data services. It covers relational and non-relational data, analytics workloads, data storage, data processing, and Azure services such as Azure SQL, Azure Cosmos DB, Azure Synapse Analytics, Azure Data Factory, and Microsoft Fabric. The exam tests conceptual understanding rather than hands-on implementation.

This is an ideal starting point for anyone exploring data roles or wanting to understand Azure data services, including IT professionals, students, business analysts, and aspiring data engineers or database administrators. No prior data experience is required, making it accessible to those beginning their data platform journey.

What's on the exam

The exam consists of 40–60 questions to be completed in approximately 45 minutes. Question types include multiple-choice, multiple-select, drag-and-drop, and hot area formats. Questions focus on identifying correct data concepts and matching them to Azure services rather than testing implementation details. Pace yourself steadily as most questions are concept-based and straightforward.

Describe core data concepts 29%

Ways to represent data, options for data storage, common data workloads, and roles and responsibilities for data workloads

Identify considerations for relational data on Azure 24%

Relational concepts including normalization and SQL statements, and Azure relational data services including Azure SQL family and open-source databases

Describe considerations for working with non-relational data on Azure 18%

Azure storage capabilities including Blob, File, and Table storage, and Azure Cosmos DB capabilities and APIs

Describe an analytics workload 29%

Large-scale analytics elements, real-time data analytics, and data visualization in Microsoft Power BI

What to expect

multiple choice
42%
drag drop
18%
multiple response
18%
dropdown selection
12%
true false
10%

Where candidates struggle

Despite being a fundamentals exam, DP-900 covers both relational and non-relational data paradigms plus analytics. Candidates who focus only on SQL databases often miss questions about Cosmos DB, data lakes, and analytics services.

  1. 01
    Data Model Types — Confusing relational, document, key-value, graph, and column-family data models and which Azure service supports each.
  2. 02
    OLTP vs OLAP — Not clearly distinguishing transactional (OLTP) from analytical (OLAP) workloads and the Azure services suited for each.
  3. 03
    Azure Data Services — Mixing up Azure SQL Database, Azure Cosmos DB, Azure Data Lake Storage, and Azure Synapse Analytics use cases.
  4. 04
    ETL vs ELT — Struggling to differentiate ETL and ELT patterns and when to use Azure Data Factory vs Synapse pipelines vs Fabric.
  5. 05
    Data Visualization — Overlooking Power BI concepts and how they relate to the broader Azure data analytics ecosystem.

Exam logistics

Delivered via Pearson VUE online or at testing centers. Available in English, Japanese, Chinese, Korean, French, German, Spanish, Portuguese, and more. This fundamentals certification does not expire and requires no renewal.

Delivery Pearson VUE online proctored or at authorized testing centers worldwide
Retake policy 24-hour wait after the first attempt, 14 days between subsequent attempts, maximum 5 attempts per exam within a 12-month period
Career outcomes Data-Aware IT Professional, Cloud Data Analyst, stepping stone to DP-300, DP-600, or DP-700 certifications
Renewal Fundamentals certifications do not expire and do not require renewal. However, Microsoft recommends staying current with evolving data services.
Study time ~15 hours
Official guide View on vendor site

Ready to pass?

Join thousands of professionals who passed with AI-powered practice.

Start Free Trial