cert-bank

Exams

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

The exam at a glance

LevelFoundational
Questions45
Time45 minutes (about 1 minutes per question)
Passing mark700 on a scaled score of 100–1,000

Domains and weights

DomainWeightPractice questions here
D1 · Describe core data concepts27.5%82
D2 · Identify considerations for relational data on Azure22.5%67
D3 · Describe considerations for working with non-relational data on Azure17.5%53
D4 · Describe an analytics workload27.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

Tasks in the official exam guide (4)
  • 1.1 Describe ways to represent data
  • 1.2 Identify options for data storage
  • 1.3 Describe common data workloads
  • 1.4 Identify roles and responsibilities for data workloads

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

Tasks in the official exam guide (2)
  • 2.1 Describe relational concepts
  • 2.2 Describe relational Azure data services

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

Tasks in the official exam guide (2)
  • 3.1 Describe the capabilities of Azure storage
  • 3.2 Describe the capabilities and features of Azure Cosmos DB

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

Tasks in the official exam guide (3)
  • 4.1 Describe common elements of large-scale analytics
  • 4.2 Describe considerations for real-time data analytics
  • 4.3 Describe data visualization in Microsoft Power BI

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.

  1. Days 1–4: D1 · Describe core data concepts
  2. Days 5–7: D2 · Identify considerations for relational data on Azure
  3. Days 8–9: D3 · Describe considerations for working with non-relational data on Azure
  4. Days 10–13: D4 · Describe an analytics workload
  5. Day 14: Final Review: Exam Format, Commonly Confused Pairs, and Test-Day Plan

Recent changes to these questions

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.