Microsoft / Associate / DP-600
Fabric Analytics Engineer
Prepare reliable analytical data, govern its lifecycle and build enterprise semantic models.
This guide targets the already-published October 19, 2026 outline, which is later than the October 10 review. For an earlier sitting, compare the outline attached to your booking; localized versions can update later.
THE REVISION PATH
Your topics, in order.
Read. Recall. Explain the alternative.
Workspace, Item and Data Security
Access to the room is different from access to every record.
Versioning, Deployment and Reusable Analytics Assets
Version the definition; validate the environment and data separately.
Connections, OneLake and Choosing a Data Store
Choose the engine for the work, then decide whether to copy.
Data Transformation and Dimensional Preparation
Fix the grain before fixing the formula.
SQL, KQL and DAX Query Decisions
Same question, different execution and context.
Star Schemas, Relationships and Date Tables
Facts measure events; dimensions describe them.
DAX Context, Time Intelligence and Performance
A measure answers the current filter context.
Direct Lake, Refresh and Enterprise Model Performance
Refresh defines visibility; storage mode defines the query path.
Enterprise DAX and Reusable Model Behavior
Reuse a calculation without losing its context.
How this guide is organised
Original revision notes arranged around practical decisions. The linked official objectives define the mapped scope; primary technical documentation supports the explanations. Read, recall without looking, then explain why another option would fail.
- Official exam guide ↗ Scope authority
Revision material supports preparation; it does not guarantee every possible exam question. Check the exam version and official objectives before booking.