DP-900 Azure Azure Data Fundamentals
- Vendor
- Azure
- Level
- Foundational
- Questions
- 45
- Time
- 45 min
- Domains
- 4
- In the bank
- 285
Practice 285 questionsTake a timed mock examDay-by-day study plan
Guides for this exam
- DP-900 Study Guide: Three Questions to Ask About Any Data Before You Pick an Azure Service · 한국어
- Seven Mistakes That Repeat Across the Azure Exams, from AZ-900 to AI-103 · 한국어
- Azure SQL Database vs SQL Managed Instance vs SQL Server on Azure VMs: The Feature Clues That Decide · 한국어
The exam at a glance
| Level | Foundational |
|---|---|
| Questions | 45 |
| Time | 45 minutes (about 1 minutes per question) |
| Passing mark | 700 on a scaled score of 100–1,000 |
Domains and weights
| Domain | Weight | Practice questions here |
|---|---|---|
| D1 · Describe core data concepts | 27.5% | 82 |
| D2 · Identify considerations for relational data on Azure | 22.5% | 67 |
| D3 · Describe considerations for working with non-relational data on Azure | 17.5% | 53 |
| D4 · Describe an analytics workload | 27.5% | 83 |
58 of the 285 practice questions (20%) ask for more than one answer.
D1 · Describe core data concepts 27.5%
Questions about core data concepts are recognition tasks. A short description of a file, a data source, a processing job or a daily task asks you to name the format, data category, processing style or data role. Read the defining detail carefully: one feature, such as braces and name and value pairs, or a pipeline that fails overnight, usually settles it.
What to watch for
- Sort data by how fixed its shape is: identical columns, flexible fields in JSON or XML, and media or documents are three different categories.
- Separate the data roles by daily work: access and backups belong to one role, building and watching pipelines to another.
- Batch processing works on complete datasets, so the trade-off to remember is the delay before results appear.
Tasks in the official exam guide (4)
D2 · Identify considerations for relational data on Azure 22.5%
Relational questions cover two things: SQL statement groups and the choice between Azure SQL options. Many items describe a database feature, an operating system need or a licensing goal and ask which service fits with the fewest changes. The usual difference between options is how much control is kept over the instance and the operating system.
What to watch for
- Group SQL statements by purpose: defining objects, controlling permissions, and reading or changing rows each have their own category.
- Place each Azure SQL option on a control scale, from fully managed database to full control of a virtual machine, and match it to the features the app needs.
- Existing SQL Server licenses can lower cost across several Azure SQL options; remember the benefit that allows this.
Tasks in the official exam guide (2)
D3 · Describe considerations for working with non-relational data on Azure 17.5%
Non-relational items pair a data need with a storage service or a Cosmos DB setting: hybrid file access, a read guarantee, an existing MongoDB skill set, or suitable workloads. You pick the service, API or consistency level. Wrong answers are often services that store the same data but serve another access pattern or another kind of application.
What to watch for
- For Cosmos DB, let existing skills and drivers guide the API choice, and let the read guarantee guide the consistency level.
- Remember which workloads suit Cosmos DB and which do not; join-heavy relational apps and data warehousing point elsewhere.
- Azure File Sync helps branch offices keep fast local access to cloud file shares through a Windows Server.
Tasks in the official exam guide (2)
D4 · Describe an analytics workload 27.5%
Analytics questions mix architecture and reporting. Some ask about stream processing parts or Fabric items such as a lakehouse endpoint; others describe what a report must show and ask for a visual or a star schema element. The answer comes from matching the purpose (a trend, a single key figure, read-only versus write access) to the right tool or visual.
What to watch for
- Choose a Power BI visual by the message it must carry: one key number, a trend over time, or many related values need different visuals.
- In a star schema, dimension tables describe entities for grouping and filtering; numeric events belong elsewhere.
- Check whether a Fabric endpoint allows writes. A lakehouse SQL analytics endpoint and a Fabric warehouse differ on this point.
Tasks in the official exam guide (3)
A study order that works
The 14-day study plan for DP-900 takes the domains in this order. Each day has a short reading, key terms and a quiz from the bank.
- Days 1–4: D1 · Describe core data concepts
- Days 5–7: D2 · Identify considerations for relational data on Azure
- Days 8–9: D3 · Describe considerations for working with non-relational data on Azure
- Days 10–13: D4 · Describe an analytics workload
- Day 14: Final Review: Exam Format, Commonly Confused Pairs, and Test-Day Plan
Recent changes to these questions
- : 4 answer choice sets changed, 4 answer keys corrected, 4 explanations rewritten
- : 60 questions added
- : 1 answer choice set changed, 1 answer key corrected, 1 explanation rewritten
About these questions
Every question is original, written from the public exam guide and checked against the vendor's own documentation. None comes from a real exam. Each one has an explanation of why the answer is right and why the other options are wrong. How the questions are written.