DP-600 cheat sheet
A one-page reference for the Microsoft Fabric Analytics Engineer Associate exam: the format, how the domains are weighted, and the glossary terms for this exam.
Exam at a glance
Vendor
Microsoft
Level
Associate
Questions
60
Time
100 min
Mock pass mark
70%
Domains
3
Practice Qs
150
Code
DP-600
Domain weightings
How much of the exam each domain covers. Spend your study time in proportion — the heavier the domain, the more questions you'll see.
Key terms
- Microsoft Fabric
- Microsoft Fabric is an end-to-end analytics platform that unifies data engineering, warehousing, data science, and business intelligence on OneLake. DP-600 centers on building analytics solutions in Fabric.
- OneLake
- OneLake is the single, unified data lake built into Microsoft Fabric that stores all analytics data for the organization. DP-600 covers OneLake for data discovery and integration.
- Lakehouse
- A lakehouse is a Fabric analytics store that combines a data lake's storage with a warehouse's structured querying over Delta tables. DP-600 covers implementing a star schema in a lakehouse.
- Warehouse
- A warehouse is a Fabric SQL-based analytics store optimized for structured, T-SQL querying. DP-600 covers choosing between a lakehouse and a warehouse and modeling data in each.
- Semantic model
- A semantic model is the Fabric/Power BI data model of tables, relationships, and DAX measures that reports query. DP-600 dedicates a domain to designing, optimizing, and managing semantic models.
- DAX
- DAX (Data Analysis Expressions) is the formula language for calculations in Fabric and Power BI semantic models. DP-600 requires writing DAX with iterators, table filtering, and windowing functions.
- Direct Lake
- Direct Lake is a Fabric semantic-model storage mode that queries Delta tables in OneLake directly, combining import speed with DirectQuery freshness. DP-600 covers configuring Direct Lake, fallback, and refresh.
- Star schema
- A star schema is a data-modeling pattern with central fact tables related to surrounding dimension tables. DP-600 covers implementing a star schema for lakehouses, warehouses, and semantic models.
- KQL
- KQL (Kusto Query Language) is a query language used in Fabric Real-Time Intelligence and Eventhouses. DP-600 requires selecting, filtering, and aggregating data with KQL.
- Shortcut
- A OneLake shortcut is a reference that makes data in another location appear in a Fabric item without copying it. DP-600 covers OneLake integration and discovering data via the OneLake catalog.
- Deployment pipeline
- A deployment pipeline in Fabric promotes content across development, test, and production workspaces. DP-600 covers creating and configuring deployment pipelines for the analytics lifecycle.
- XMLA endpoint
- The XMLA endpoint is an interface for deploying and managing semantic models programmatically with tools like Tabular Editor. DP-600 covers deploying and managing semantic models via the XMLA endpoint.
- Calculation group
- A calculation group is a semantic-model feature that reduces measure duplication by applying reusable calculation items. DP-600 covers implementing calculation groups, dynamic format strings, and field parameters.
- Sensitivity label
- A sensitivity label is a Microsoft Purview classification applied to Fabric items to enforce protection and compliance. DP-600 covers applying sensitivity labels in the security and governance domain.