DP-600 exam topics
The DP-600 exam (Microsoft Certified: Fabric Analytics Engineer Associate) covers 3 domains and 24 topics. This page lists all of them with the weight of each domain, so you can see what the exam tests and where most of the marks are.
Domains and weights
| Domain | Weight | Topics |
|---|---|---|
| Domain 1: Maintain a data analytics solution | 25–30% | 7 |
| Domain 2: Prepare data | 45–50% | 9 |
| Domain 3: Implement and manage semantic models | 25–30% | 8 |
Domain 1: Maintain a data analytics solution · 25–30%
- Plan and Configure the Analytics Environment
Before building anything, an analytics engineer chooses the capacity, the tenant and workspace settings, and the gateways the solution needs. Exam questions here are usually about requirements: which SKU, which setting, which gateway.
- Workspace and Item Access, and Data Sharing
An analytics engineer decides who can build, who can query and who can only view reports. Fabric gives you three layers: workspace roles (everything in a workspace), item permissions (one item) and data-level security (lesson 1.3).
- Row-, Column-, Object- and File-Level Access Control
Workspace roles and sharing decide who can reach an item. Granular controls decide which rows, columns, tables and files they see. Where you enforce them depends on the engine people query through.
- Sensitivity Labels and Endorsement
Governance on DP-600 focuses on semantic models and lakehouses: how to label them so that sensitivity follows the data downstream, and how to endorse them so that people find and trust the right ones.
- Version Control and Power BI Desktop Projects (.pbip)
Version control on DP-600 has two sides. In the service, a workspace is connected to Git. On the desktop, a report and its model are saved as a Power BI Desktop project (.pbip): plain text files that Git can track and that you can review in pull requests.
- Deployment Pipelines and Impact Analysis
Changes have to reach production safely. Deployment pipelines move content between stages, and impact analysis tells you who and what breaks if you change an upstream item.
- XMLA Endpoint and Reusable Assets
Enterprise semantic models are often managed outside Power BI Desktop, through the XMLA endpoint. Teams also save time by reusing templates, data source files and shared models instead of rebuilding them.
Domain 2: Prepare data · 45–50%
- Connect To and Discover Data
Preparing data starts with finding it and connecting to it securely. Fabric gives you catalogs for discovery and reusable connections for access.
- Ingest, Copy and Schedule Data
Fabric has five ways to bring data in. The exam asks you to pick the right one from the source, volume, transformation needs and team skills, and then to schedule and orchestrate it.
- Choose a Store, Use OneLake Integration and Partition Files
An analytics engineer chooses where curated data lives (lakehouse, warehouse or eventhouse), knows how to make data from any engine available in OneLake, and lays out large lakehouse tables so that queries read less.
- Create Views, Functions and Stored Procedures, and Enrich Data
T-SQL objects package logic so that it's reusable, secured and close to the data. Where you can create them depends on the item.
- Star Schemas, Slowly Changing Dimensions and Bridge Tables
A semantic model is only as good as the tables under it. Building a star schema in the lakehouse or warehouse (the gold layer) is core DP-600 work.
- Cleanse and Shape Data
DP-600 lists a set of shaping skills: cleanse, denormalize, aggregate or de-aggregate, merge or join, fix duplicates, missing values and nulls, convert types, filter. You should be able to do each one in SQL, PySpark and Power Query, and spot the right line of code.
- Query Data with SQL and the Visual Query Editor
Analytics engineers explore and validate data with T-SQL, either written by hand or built with the visual query editor, against warehouses and lakehouse SQL analytics endpoints. Exam items show a query and ask what it returns, or ask which clause to change.
- Query Data with KQL
Kusto Query Language (KQL) queries data in eventhouses and KQL databases. It reads top to bottom as a pipeline of operators joined by the pipe character. You need to be able to select, filter and aggregate with it, and read short queries.
- Optimize Loading Performance and Delta File Sizes
DP-600 asks you to find and fix bottlenecks in dataflows, notebooks and SQL, and to fix Delta tables whose files are too small or too many. These tables slow down every engine that reads them, Direct Lake included.
Domain 3: Implement and manage semantic models · 25–30%
- Choose a Storage Mode, Including Direct Lake
Storage mode is a property of each table in a semantic model. It decides where the data lives at query time, how fresh it is, and how fast visuals respond.
- Star Schema and Relationships in a Semantic Model
Power BI models are built for star schemas. Relationships carry filters from dimensions to facts, and most modeling questions are really about cardinality, filter direction and many-to-many cases.
- DAX Calculations: Variables, Iterators, Filtering, Windowing and Information Functions
DP-600 tests whether you can read and choose DAX. The skills outline names four families: iterators, table filtering, windowing and information functions, plus variables.
- Calculation Groups, Dynamic Format Strings and Field Parameters
These three features make models smaller and more flexible. Instead of writing 30 measures (10 base measures × YTD, PY, YoY), you write the logic once and let users switch.
- Large Semantic Models, Composite Models and Aggregations
Enterprise models outgrow default limits. You can raise the limits with the large semantic model storage format, or keep the detail at the source with composite models and aggregations.
- Implement and Validate Dynamic Row-Level and Object-Level Security
Model security limits what report users see inside one semantic model. RLS filters rows. OLS hides tables or columns completely. Both must be implemented and tested.
- Optimize Queries, Visuals and DAX with Performance Tools
Slow reports are diagnosed from the visual down to the engine: which visual is slow, which DAX query it sends, where the engine spends its time, and what in the model causes it. Each tool covers one step.
- Implement Incremental Refresh
Incremental refresh splits an Import table into date-based partitions. A refresh then reloads only the recent ones, so large models refresh faster, more reliably and with less load on the source.
DP-600 exam facts
| Questions | About 40–60 |
|---|---|
| Time limit | 100 minutes |
| Passing score | 700 on a scale of 1–1,000 |
| Exam fee | $165 USD (varies by country) |
| Certification valid for | 12 months, renewable free online |
| Delivery | Pearson VUE, online proctored or at a test centre. Microsoft Learn is open during the exam |
| Retakes | After 24 hours the first time; longer waits for later retakes |
Study these topics
- Read the free DP-600 study guide: one lesson per topic above, each with its sources in Microsoft Learn.
- See how to prepare for DP-600 for a study plan ordered by domain weight.
- Test yourself with the free 10-question DP-600 mock test, or the full DP-600 practice exam.
Skillmarked is independent and not affiliated with Microsoft. The topic list follows the public exam outline; check the official exam page for the current version before you book.