Azure · Foundations
Azure Data Fundamentals (DP-900)
Demonstrate core data concepts and how they're implemented with Microsoft Azure data services.
DP-900 exam at a glance
| Exam code | DP-900 |
|---|---|
| Vendor | Azure |
| Level | Foundations |
| Domains | 4 |
| Published practice questions | 62 |
| Our mock exam | 40 questions in 45 minutes |
| Our practice pass target | 70% |
| Checked against the exam guide | July 7, 2026 |
| Official exam page | Microsoft Learn — DP-900 |
The mock exam length, time limit and pass target are our practice settings, not official exam scores or a guarantee of passing. Check the official DP-900 exam page for the current format, price and scoring before you book.
DP-900 exam domains
Weights show our practice allocation, built from the official exam guide; official blueprints may give ranges. Each domain links to its free sample questions (with explanations) and study guide preview once they are published.
Describe core data concepts
29%Ways to represent data, storage options, transactional vs analytical workloads, and data-professional roles.
- Structured, semi-structured, and unstructured data
- Common data file formats (CSV, JSON, Parquet, Avro, XML)
- Features of common data stores and databases
- Azure data stores for common use cases
- Transactional (OLTP) workload characteristics
- Analytical (OLAP) workload characteristics
- Responsibilities of database administrators, data engineers, and data analysts
Free Describe core data concepts practice questions →Describe core data concepts study guide →
Identify considerations for relational data on Azure
23%Relational concepts, normalization, SQL, database objects, and the Azure relational database services.
- Features of relational data: tables, rows, keys, relationships
- Normalization and why it is used
- Common SQL statements: SELECT, INSERT, UPDATE, DELETE, DDL vs DML
- Common database objects: tables, views, stored procedures, indexes
- Azure SQL family: SQL Database, SQL Managed Instance, SQL Server on Azure VMs
- Azure database services for open-source systems: MySQL, MariaDB, PostgreSQL
Free Identify considerations for relational data on Azure practice questions →Identify considerations for relational data on Azure study guide →
Describe considerations for working with non-relational data on Azure
18%Azure Storage capabilities (blobs, files, tables) and Azure Cosmos DB features, APIs, and use cases.
- Azure Blob storage features and use cases
- Azure Files features and use cases
- Azure Table storage features and key/value concepts
- Azure Cosmos DB use cases
- Azure Cosmos DB APIs: NoSQL, MongoDB, Cassandra, Gremlin, Table, PostgreSQL
Free Describe considerations for working with non-relational data on Azure practice questions →Describe considerations for working with non-relational data on Azure study guide →
Describe an analytics workload on Azure
30%Large-scale analytics, data warehousing concepts, real-time analytics, data visualization, and Microsoft Fabric / Power BI fundamentals.
- Elements of large-scale analytics: ingestion, processing, storage, modeling
- Data warehousing concepts: star schema, fact and dimension tables
- Batch vs streaming (real-time) data processing
- Microsoft Fabric components for analytics (lakehouse, OneLake)
- Azure services for real-time analytics (Azure Stream Analytics, Fabric Real-Time Intelligence)
- Power BI: capabilities, building blocks (reports, dashboards, semantic models)
- Appropriate chart types for data visualization
Free Describe an analytics workload on Azure practice questions →Describe an analytics workload on Azure study guide →
DP-900 FAQ
How is the Azure Data Fundamentals (DP-900) practice assessment configured?
Our practice format targets 40 questions in 45 minutes. Availability depends on the published question bank and is shown on this course page. Official exam question counts and formats may differ.
What does the 70% practice target mean?
Microsoft technical exams use a scaled passing score of 700; this is not equivalent to 70% correct. DataCertPrep uses 70% as an internal practice target, not a prediction or guarantee of passing.
How should I assess my progress in Azure Data Fundamentals (DP-900)?
Use practice accuracy to find weak topics. Repeating familiar questions can inflate your score. Check coverage of the current objectives, practise hands-on tasks, and assess yourself on unseen questions.
What is the best way to study Azure Data Fundamentals (DP-900)?
Read the available guides, work through practice explanations, use flashcards and complete practical exercises. Take a timed assessment when available. Check the provider's current exam guide before booking your exam.
Should I use DP-900 exam dumps?
No. "Dumps" are questions copied or recalled from the live exam. Certification exams are covered by a candidate agreement that prohibits sharing or using them, and breaking it can lead to a revoked certification or a ban from future exams. Dumps are also often wrong, and they go out of date when the exam blueprint changes. Memorising answers does not build the skills the exam tests. Study the official Microsoft exam guide and practise with original questions that explain each answer, such as the free sample questions linked on this page.