OpenExam.
Azure Data Fundamentals · COVERAGE & GAPS

Azure Data Fundamentals: Coverage Map & Learning Gaps

Selected foundations; all 30 retained official leaves remain partial. Additional evidence is not a full-outline or calibrated simulation claim.

A partial map, not a completion score.

Objective IDs are local retained-guide locators,not Microsoft numbering. Counts are learning assets,not proof of complete official coverage.

Mapping describes the available practice, not your mastery or readiness for the exam. Reviewed 2026-11-03.

30Objectives in this map
30Have partial practice
0Have no mapped practice
Study guide for Exam DP-900: Microsoft Azure Data Fundamentals | Microsoft Learn

Describe common formats for data files

Partial practice

4 linked question families · 7 variants. Variants are not separate syllabus objectives.

What still needs work

  • CSV/JSON/Parquet/Avro/Delta basics;no binary format implementation.
  • Selected foundations;qualified educator review pending and learner trial not_run.
  • Bounded fictional cases only; not complete provider configuration, tenant verification or full objective mastery. Professional review pending; representative learner trial not_run.
Data representationsFiles,databases,and storage fitAnalytical grain, timing and platform evidence
Study guide for Exam DP-900: Microsoft Azure Data Fundamentals | Microsoft Learn

Describe features of common data stores including databases

Partial practice

3 linked question families · 5 variants. Variants are not separate syllabus objectives.

What still needs work

  • File/database/query-update roles only;no complete transaction-engine comparison.
  • Selected foundations;qualified educator review pending and learner trial not_run.
  • Bounded fictional cases only; not complete provider configuration, tenant verification or full objective mastery. Professional review pending; representative learner trial not_run.
Files,databases,and storage fitIngestion and analytical data storesService contracts and transaction boundaries
Study guide for Exam DP-900: Microsoft Azure Data Fundamentals | Microsoft Learn

Identify Azure datastores for common use cases

Partial practice

6 linked question families · 10 variants. Variants are not separate syllabus objectives.

What still needs work

  • Selected SQL,Storage and Cosmos cases;not every Azure datastore.
  • Selected foundations;qualified educator review pending and learner trial not_run.
  • Bounded fictional cases only; not complete provider configuration, tenant verification or full objective mastery. Professional review pending; representative learner trial not_run.
Relational Azure service boundariesObject,file and key/attribute storageService contracts and transaction boundaries
Study guide for Exam DP-900: Microsoft Azure Data Fundamentals | Microsoft Learn

Describe features of transactional workloads

Partial practice

5 linked question families · 7 variants. Variants are not separate syllabus objectives.

What still needs work

  • Conceptual ACID and supplied units only;no transaction-engine operations.
  • Selected foundations;qualified educator review pending and learner trial not_run.
  • Bounded fictional cases only; not complete provider configuration, tenant verification or full objective mastery. Professional review pending; representative learner trial not_run.
Transactional and analytical workNormalize the fact, then check the SQL resultService contracts and transaction boundaries
Study guide for Exam DP-900: Microsoft Azure Data Fundamentals | Microsoft Learn

Describe features of analytical workloads

Partial practice

5 linked question families · 7 variants. Variants are not separate syllabus objectives.

What still needs work

  • Historical measure/grouping tasks only;no full OLAP implementation.
  • Selected foundations;qualified educator review pending and learner trial not_run.
  • Bounded fictional cases only; not complete provider configuration, tenant verification or full objective mastery. Professional review pending; representative learner trial not_run.
Transactional and analytical workPower BI models and visual choicesAnalytical grain, timing and platform evidence
Study guide for Exam DP-900: Microsoft Azure Data Fundamentals | Microsoft Learn

Describe responsibilities for database administrators

Partial practice

3 linked question families · 5 variants. Variants are not separate syllabus objectives.

What still needs work

  • Backup/recovery/permission role only;no DBA operational certification.
  • Selected foundations;qualified educator review pending and learner trial not_run.
  • Bounded fictional cases only; not complete provider configuration, tenant verification or full objective mastery. Professional review pending; representative learner trial not_run.
Task-based data roles
Study guide for Exam DP-900: Microsoft Azure Data Fundamentals | Microsoft Learn

Describe responsibilities for data engineers

Partial practice

3 linked question families · 5 variants. Variants are not separate syllabus objectives.

What still needs work

  • Ingestion/cleaning/mapping role only;no pipeline deployment.
  • Selected foundations;qualified educator review pending and learner trial not_run.
  • Bounded fictional cases only; not complete provider configuration, tenant verification or full objective mastery. Professional review pending; representative learner trial not_run.
Task-based data roles
Study guide for Exam DP-900: Microsoft Azure Data Fundamentals | Microsoft Learn

Describe responsibilities for data analysts

Partial practice

2 linked question families · 3 variants. Variants are not separate syllabus objectives.

What still needs work

  • Analytical model/report role only;no complete analyst tooling.
  • Selected foundations;qualified educator review pending and learner trial not_run.
  • Bounded fictional cases only; not complete provider configuration, tenant verification or full objective mastery. Professional review pending; representative learner trial not_run.
Task-based data roles
Study guide for Exam DP-900: Microsoft Azure Data Fundamentals | Microsoft Learn

Identify features of relational data

Partial practice

5 linked question families · 7 variants. Variants are not separate syllabus objectives.

What still needs work

  • Small typed tables and key relationships;no advanced relational theory.
  • Selected foundations;qualified educator review pending and learner trial not_run.
  • Bounded fictional cases only; not complete provider configuration, tenant verification or full objective mastery. Professional review pending; representative learner trial not_run.
Relational tables, keys, SQL and objectsNormalize the fact, then check the SQL result
Study guide for Exam DP-900: Microsoft Azure Data Fundamentals | Microsoft Learn

Describe normalization and why it is used

Partial practice

2 linked question families · 3 variants. Variants are not separate syllabus objectives.

What still needs work

  • Entity fact ownership/current-vs-history only;no formal proof of all normal forms.
  • Selected foundations;qualified educator review pending and learner trial not_run.
  • Bounded fictional cases only; not complete provider configuration, tenant verification or full objective mastery. Professional review pending; representative learner trial not_run.
  • Lesson12/q045/card36 add current-entity fact ownership and historical-fact boundaries; no formal dependency proof or complete normal-form coverage.
Relational tables, keys, SQL and objectsNormalize the fact, then check the SQL result
Study guide for Exam DP-900: Microsoft Azure Data Fundamentals | Microsoft Learn

Identify common structured query language (SQL) statements

Partial practice

5 linked question families · 7 variants. Variants are not separate syllabus objectives.

What still needs work

  • Selected foundations;qualified educator review pending and learner trial not_run.
  • Bounded fictional cases only; not complete provider configuration, tenant verification or full objective mastery. Professional review pending; representative learner trial not_run.
  • Limited SELECT/WHERE/JOIN, GROUP BY/HAVING counterexample, COUNT(NULL) and schema-versus-row-operation cases; no full SQL dialect, three-valued-logic treatment or collation coverage.
Files,databases,and storage fitRelational tables, keys, SQL and objectsNormalize the fact, then check the SQL result
Study guide for Exam DP-900: Microsoft Azure Data Fundamentals | Microsoft Learn

Describe the Azure SQL family of products, including Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machines

Partial practice

3 linked question families · 5 variants. Variants are not separate syllabus objectives.

What still needs work

  • Database/instance/VM/pool conceptual boundaries;not exhaustive feature compatibility.
  • Selected foundations;qualified educator review pending and learner trial not_run.
  • Bounded fictional cases only; not complete provider configuration, tenant verification or full objective mastery. Professional review pending; representative learner trial not_run.
Relational Azure service boundariesService contracts and transaction boundaries
Study guide for Exam DP-900: Microsoft Azure Data Fundamentals | Microsoft Learn

Describe features of Azure Table storage

Partial practice

2 linked question families · 3 variants. Variants are not separate syllabus objectives.

What still needs work

  • Schemaless key/attribute model only;no key-design performance optimization.
  • Selected foundations;qualified educator review pending and learner trial not_run.
  • Bounded fictional cases only; not complete provider configuration, tenant verification or full objective mastery. Professional review pending; representative learner trial not_run.
Object,file and key/attribute storageService contracts and transaction boundaries
Study guide for Exam DP-900: Microsoft Azure Data Fundamentals | Microsoft Learn

Identify use cases for Azure Cosmos DB

Partial practice

3 linked question families · 4 variants. Variants are not separate syllabus objectives.

What still needs work

  • Document access/granularity only;not every Cosmos use case.
  • Selected foundations;qualified educator review pending and learner trial not_run.
  • Bounded fictional cases only; not complete provider configuration, tenant verification or full objective mastery. Professional review pending; representative learner trial not_run.
Cosmos DB API and partition boundariesService contracts and transaction boundaries
Study guide for Exam DP-900: Microsoft Azure Data Fundamentals | Microsoft Learn

Describe Azure Cosmos DB APIs

Partial practice

3 linked question families · 5 variants. Variants are not separate syllabus objectives.

What still needs work

  • API contract recognition and explicit NoSQL boundary;not all API-specific operations.
  • Selected foundations;qualified educator review pending and learner trial not_run.
  • Bounded fictional cases only; not complete provider configuration, tenant verification or full objective mastery. Professional review pending; representative learner trial not_run.
Cosmos DB API and partition boundariesService contracts and transaction boundaries
Study guide for Exam DP-900: Microsoft Azure Data Fundamentals | Microsoft Learn

Describe considerations for data ingestion and processing

Partial practice

3 linked question families · 5 variants. Variants are not separate syllabus objectives.

What still needs work

  • ETL/ELT and roles only;no production orchestration or error-recovery implementation.
  • Selected foundations;qualified educator review pending and learner trial not_run.
  • Bounded fictional cases only; not complete provider configuration, tenant verification or full objective mastery. Professional review pending; representative learner trial not_run.
Ingestion and analytical data storesBatch and streaming reasoningAnalytical grain, timing and platform evidence
Study guide for Exam DP-900: Microsoft Azure Data Fundamentals | Microsoft Learn

Describe Microsoft cloud services for large-scale analytics, including Azure Databricks and Microsoft Fabric

Partial practice

3 linked question families · 5 variants. Variants are not separate syllabus objectives.

What still needs work

  • Fabric/OneLake and Databricks high-level purpose only;no workspace/capacity setup.
  • Selected foundations;qualified educator review pending and learner trial not_run.
  • Bounded fictional cases only; not complete provider configuration, tenant verification or full objective mastery. Professional review pending; representative learner trial not_run.
  • Lesson14/q061/card40 compare shared Spark/notebook capabilities and insufficient evidence for a unique choice. This is limited comparison, not full Databricks/Fabric capability, workspace, capacity or integration coverage.
Ingestion and analytical data storesBatch and streaming reasoningAnalytical grain, timing and platform evidence
Study guide for Exam DP-900: Microsoft Azure Data Fundamentals | Microsoft Learn

Describe the difference between batch and streaming data

Partial practice

4 linked question families · 6 variants. Variants are not separate syllabus objectives.

What still needs work

  • Batch/stream/buffer distinction and supplied counting rule;no watermark default.
  • Selected foundations;qualified educator review pending and learner trial not_run.
  • Bounded fictional cases only; not complete provider configuration, tenant verification or full objective mastery. Professional review pending; representative learner trial not_run.
Batch and streaming reasoningAnalytical grain, timing and platform evidence
Study guide for Exam DP-900: Microsoft Azure Data Fundamentals | Microsoft Learn

Describe features of data models in Power BI

Partial practice

4 linked question families · 6 variants. Variants are not separate syllabus objectives.

What still needs work

  • Measures and grouping dimensions only;no DAX/relationship-model engineering.
  • Selected foundations;qualified educator review pending and learner trial not_run.
  • Bounded fictional cases only; not complete provider configuration, tenant verification or full objective mastery. Professional review pending; representative learner trial not_run.
Power BI models and visual choicesAnalytical grain, timing and platform evidence
Study guide for Exam DP-900: Microsoft Azure Data Fundamentals | Microsoft Learn

Use the map with care.

  • All retained leaf mappings are partial, none covered/mastered.
  • New question/lesson counts are learning assets, not a claim of full official scope or psychometric calibration.
  • Professional review pending; learner trial not_run; release HOLD.