Microsoft Certified: Azure Data Fundamentals (DP-900) · EXAM GUIDEReviewed 2026-11-03
Selected foundations; all 30 retained official leaves remain partial. Additional evidence is not a full-outline or calibrated simulation claim.
Azure Data Fundamentals: Exam Guide & Official Sources
Use 14 lessons, 64 original formal tasks, 42 retrieval cards and 4 independent guides for selected foundations. Editorial durations are uncalibrated.
What these foundations prepare you to do
DP-900 concerns core data concepts and related Microsoft cloud data services. This route develops selected representations, workloads, relational/non-relational decisions and analytical reasoning through fictional cases. It does not replace the full official skills guide.
Current official scope and dated facts
The retained English guide lists skills as of July 21,2026 and four domain percentage ranges. The certification page states 45 minutes for the proctored assessment and possible interactive components. Our local accuracy is not an official score or simulation of all official formats. Recheck current official conditions before scheduling.
How to use the 14 day route
Days 1–11 build the existing foundation sequence. Days 12–14 add SQL-result reasoning, service/transaction contracts and analytical-grain/timing teaching with new worked and transfer cases. Related earlier tasks are explicitly marked as reinforcement. Minutes are editorial estimates, not measured learner completion times or official preparation requirements.
Data representations
Use the real lesson, practice, card and article links in this day. Read its completion and remediation criteria; repeat work is consolidation rather than a new independent question.
Data representations
50 suggested minutes
- Read or revisit the complete linked lesson; solve its worked/transfer cases before checking the reasoning.
- Attempt the listed formal tasks before reading explanations; state the controlling requirement and reject the strongest alternative.
- Retrieve the linked cards; when an article is listed, attempt both application checks before opening their answers.
Completion: Attempt every listed object and explain at least one error or unresolved boundary in your own words. Completion is activity evidence, not a mastery/score claim.
If you need another pass: Return to the relevant condition/source-backed distinction, write why the wrong route fails, and retry after a delay. Record remembered-answer success separately from a fresh diagnostic.
Files,databases,and storage fit
Use the real lesson, practice, card and article links in this day. Read its completion and remediation criteria; repeat work is consolidation rather than a new independent question.
Files,databases,and storage fit
50 suggested minutes
- Read or revisit the complete linked lesson; solve its worked/transfer cases before checking the reasoning.
- Attempt the listed formal tasks before reading explanations; state the controlling requirement and reject the strongest alternative.
- Retrieve the linked cards; when an article is listed, attempt both application checks before opening their answers.
Completion: Attempt every listed object and explain at least one error or unresolved boundary in your own words. Completion is activity evidence, not a mastery/score claim.
If you need another pass: Return to the relevant condition/source-backed distinction, write why the wrong route fails, and retry after a delay. Record remembered-answer success separately from a fresh diagnostic.
Transactional and analytical work
Use the real lesson, practice, card and article links in this day. Read its completion and remediation criteria; repeat work is consolidation rather than a new independent question.
Transactional and analytical work
50 suggested minutes
- Read or revisit the complete linked lesson; solve its worked/transfer cases before checking the reasoning.
- Attempt the listed formal tasks before reading explanations; state the controlling requirement and reject the strongest alternative.
- Retrieve the linked cards; when an article is listed, attempt both application checks before opening their answers.
Completion: Attempt every listed object and explain at least one error or unresolved boundary in your own words. Completion is activity evidence, not a mastery/score claim.
If you need another pass: Return to the relevant condition/source-backed distinction, write why the wrong route fails, and retry after a delay. Record remembered-answer success separately from a fresh diagnostic.
Task-based data roles
Use the real lesson, practice, card and article links in this day. Read its completion and remediation criteria; repeat work is consolidation rather than a new independent question.
Task-based data roles
50 suggested minutes
- Read or revisit the complete linked lesson; solve its worked/transfer cases before checking the reasoning.
- Attempt the listed formal tasks before reading explanations; state the controlling requirement and reject the strongest alternative.
- Retrieve the linked cards; when an article is listed, attempt both application checks before opening their answers.
Completion: Attempt every listed object and explain at least one error or unresolved boundary in your own words. Completion is activity evidence, not a mastery/score claim.
If you need another pass: Return to the relevant condition/source-backed distinction, write why the wrong route fails, and retry after a delay. Record remembered-answer success separately from a fresh diagnostic.
Relational tables, keys, SQL and objects
Use the real lesson, practice, card and article links in this day. Read its completion and remediation criteria; repeat work is consolidation rather than a new independent question.
Relational tables, keys, SQL and objects
50 suggested minutes
- Read or revisit the complete linked lesson; solve its worked/transfer cases before checking the reasoning.
- Attempt the listed formal tasks before reading explanations; state the controlling requirement and reject the strongest alternative.
- Retrieve the linked cards; when an article is listed, attempt both application checks before opening their answers.
Completion: Attempt every listed object and explain at least one error or unresolved boundary in your own words. Completion is activity evidence, not a mastery/score claim.
If you need another pass: Return to the relevant condition/source-backed distinction, write why the wrong route fails, and retry after a delay. Record remembered-answer success separately from a fresh diagnostic.
Relational Azure service boundaries
Use the real lesson, practice, card and article links in this day. Read its completion and remediation criteria; repeat work is consolidation rather than a new independent question.
Relational Azure service boundaries
50 suggested minutes
- Read or revisit the complete linked lesson; solve its worked/transfer cases before checking the reasoning.
- Attempt the listed formal tasks before reading explanations; state the controlling requirement and reject the strongest alternative.
- Retrieve the linked cards; when an article is listed, attempt both application checks before opening their answers.
Completion: Attempt every listed object and explain at least one error or unresolved boundary in your own words. Completion is activity evidence, not a mastery/score claim.
If you need another pass: Return to the relevant condition/source-backed distinction, write why the wrong route fails, and retry after a delay. Record remembered-answer success separately from a fresh diagnostic.
Object,file and key/attribute storage
Use the real lesson, practice, card and article links in this day. Read its completion and remediation criteria; repeat work is consolidation rather than a new independent question.
Object,file and key/attribute storage
50 suggested minutes
- Read or revisit the complete linked lesson; solve its worked/transfer cases before checking the reasoning.
- Attempt the listed formal tasks before reading explanations; state the controlling requirement and reject the strongest alternative.
- Retrieve the linked cards; when an article is listed, attempt both application checks before opening their answers.
Completion: Attempt every listed object and explain at least one error or unresolved boundary in your own words. Completion is activity evidence, not a mastery/score claim.
If you need another pass: Return to the relevant condition/source-backed distinction, write why the wrong route fails, and retry after a delay. Record remembered-answer success separately from a fresh diagnostic.
Cosmos DB API and partition boundaries
Use the real lesson, practice, card and article links in this day. Read its completion and remediation criteria; repeat work is consolidation rather than a new independent question.
Cosmos DB API and partition boundaries
50 suggested minutes
- Read or revisit the complete linked lesson; solve its worked/transfer cases before checking the reasoning.
- Attempt the listed formal tasks before reading explanations; state the controlling requirement and reject the strongest alternative.
- Retrieve the linked cards; when an article is listed, attempt both application checks before opening their answers.
Completion: Attempt every listed object and explain at least one error or unresolved boundary in your own words. Completion is activity evidence, not a mastery/score claim.
If you need another pass: Return to the relevant condition/source-backed distinction, write why the wrong route fails, and retry after a delay. Record remembered-answer success separately from a fresh diagnostic.
Ingestion and analytical data stores
Use the real lesson, practice, card and article links in this day. Read its completion and remediation criteria; repeat work is consolidation rather than a new independent question.
Ingestion and analytical data stores
50 suggested minutes
- Read or revisit the complete linked lesson; solve its worked/transfer cases before checking the reasoning.
- Attempt the listed formal tasks before reading explanations; state the controlling requirement and reject the strongest alternative.
- Retrieve the linked cards; when an article is listed, attempt both application checks before opening their answers.
Completion: Attempt every listed object and explain at least one error or unresolved boundary in your own words. Completion is activity evidence, not a mastery/score claim.
If you need another pass: Return to the relevant condition/source-backed distinction, write why the wrong route fails, and retry after a delay. Record remembered-answer success separately from a fresh diagnostic.
Batch and streaming reasoning
Use the real lesson, practice, card and article links in this day. Read its completion and remediation criteria; repeat work is consolidation rather than a new independent question.
Batch and streaming reasoning
50 suggested minutes
- Read or revisit the complete linked lesson; solve its worked/transfer cases before checking the reasoning.
- Attempt the listed formal tasks before reading explanations; state the controlling requirement and reject the strongest alternative.
- Retrieve the linked cards; when an article is listed, attempt both application checks before opening their answers.
Completion: Attempt every listed object and explain at least one error or unresolved boundary in your own words. Completion is activity evidence, not a mastery/score claim.
If you need another pass: Return to the relevant condition/source-backed distinction, write why the wrong route fails, and retry after a delay. Record remembered-answer success separately from a fresh diagnostic.
Power BI models and visual choices
Use the real lesson, practice, card and article links in this day. Read its completion and remediation criteria; repeat work is consolidation rather than a new independent question.
Power BI models and visual choices
50 suggested minutes
- Read or revisit the complete linked lesson; solve its worked/transfer cases before checking the reasoning.
- Attempt the listed formal tasks before reading explanations; state the controlling requirement and reject the strongest alternative.
- Retrieve the linked cards; when an article is listed, attempt both application checks before opening their answers.
Completion: Attempt every listed object and explain at least one error or unresolved boundary in your own words. Completion is activity evidence, not a mastery/score claim.
If you need another pass: Return to the relevant condition/source-backed distinction, write why the wrong route fails, and retry after a delay. Record remembered-answer success separately from a fresh diagnostic.
Normalize the fact, then check the SQL result
Study the new linked lesson 12, attempt its worked and transfer cases, then use this day's linked formal questions and retrieval cards. The SQL article supplies separate WHERE/GROUP BY/HAVING teaching and application checks. The optional 8-question worksheet remains a separate reused resource; it is not this daily question list. Follow the day’s completion and targeted remediation criteria.
Normalize the fact, then check the SQL result
65 suggested minutes
- Read or revisit the complete linked lesson; solve its worked/transfer cases before checking the reasoning.
- Attempt the listed formal tasks before reading explanations; state the controlling requirement and reject the strongest alternative.
- Retrieve the linked cards; when an article is listed, attempt both application checks before opening their answers.
- Related reinforcement: q051 revisits schema-definition versus row-change teaching in lesson 05; it is not a new lesson-12 objective.
Completion: Attempt every listed object and explain at least one error or unresolved boundary in your own words. Completion is activity evidence, not a mastery/score claim.
If you need another pass: Return to the relevant condition/source-backed distinction, write why the wrong route fails, and retry after a delay. Record remembered-answer success separately from a fresh diagnostic.
Service contracts and transaction boundaries
Study the new linked lesson 13, attempt its worked and transfer cases, then use this day's linked formal questions and retrieval cards. The optional 8-question worksheet remains a separate reused resource; it is not this daily question list. Follow the day’s completion and targeted remediation criteria.
Service contracts and transaction boundaries
55 suggested minutes
- Read or revisit the complete linked lesson; solve its worked/transfer cases before checking the reasoning.
- Attempt the listed formal tasks before reading explanations; state the controlling requirement and reject the strongest alternative.
- Retrieve the linked cards; when an article is listed, attempt both application checks before opening their answers.
Completion: Attempt every listed object and explain at least one error or unresolved boundary in your own words. Completion is activity evidence, not a mastery/score claim.
If you need another pass: Return to the relevant condition/source-backed distinction, write why the wrong route fails, and retry after a delay. Record remembered-answer success separately from a fresh diagnostic.
Analytical grain, timing and platform evidence
Study the new linked lesson 14, attempt its worked and transfer cases, then use this day's linked formal questions and retrieval cards. q059 is explicit mixed reinforcement from lesson 04. The optional 8-question worksheet remains a separate reused resource; it is not this daily question list. Follow the day’s completion and targeted remediation criteria.
Analytical grain, timing and platform evidence
60 suggested minutes
- Read the complete linked lesson 14 and work its order-grain example and separate transfer check before opening their reasoning.
- Attempt the linked formal questions before feedback; keep q059 marked as mixed reinforcement from lesson 04 rather than new lesson-14 coverage.
- Retrieve the three linked cards, explaining the shared-platform capability, order-grain and bounded-rerun distinctions. The optional downloadable worksheet is a separate reused question set, not this daily list.
Completion: Work the lesson example and transfer check, attempt each linked formal task, and retrieve each linked card. Record one corrected or uncertain distinction about grain, time or evidence; explain why a plausible competing answer fails. Completion is activity evidence, not mastery or a score prediction.
If you need another pass: For a grain or timing error, return to the relevant lesson-14 section and try its changed condition. For mixed q059, revisit the role distinction in lesson 04. Reattempt after a delay and label remembered-answer success separately from a fresh diagnostic.
The syllabus and your next lesson.
Core data concepts
- Data representations
- Files,databases,and storage fit
- Transactional and analytical work
- Task-based data roles
Relational data on Azure
- Relational tables, keys, SQL and objects
- Relational Azure service boundaries
Non-relational data on Azure
- Object,file and key/attribute storage
- Cosmos DB API and partition boundaries
Analytics on Azure
- Ingestion and analytical data stores
- Batch and streaming reasoning
- Power BI models and visual choices
Linked lessons cover selected foundations. Use the official syllabus to plan any topics beyond this pilot.
Dates and scheduling
Scheduling
No appointment, availability or deadline verified. Use the current official certification entry.
Fees and regional differences
Local payable fee
Not quoted in this sample; check current official registration conditions for your location.
Book with the exam provider.
- 01
Review current official conditions
Start from the official certification page and review its current scheduling, delivery and preparation information. No authenticated registration flow was tested.
OpenExam does not accept exam registrations or payments.
Make a final check.
0 of 1 checked · for this visit
Official resources.
Official skills and preparation-resource entry; broader than this sample.
Recheck current official assessment and scheduling conditions.
Eight existing practice tasks in the same order as day 14. A short selected-foundation worksheet, not a complete study-guide PDF.
64 original formal tasks; related-concept reinforcement is included and is not 64 independent competencies.
14 lessons, 42 retrieval cards and 4 independent guides support selected foundations; every retained official leaf remains partial.
The 14-day route links real learning objects; the short worksheet reuses 8 tasks.
No official/recalled exam items, score prediction or provider/tenant deployment certification.
Professional review pending; representative learner trial not_run; release HOLD.
Exam names belong to their respective owners. OpenExam is an independent learning project.