Launch Deal · 50% off 1st month ·
← DP-600 study guide

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

DomainWeightTopics
Domain 1: Maintain a data analytics solution25–30%7
Domain 2: Prepare data45–50%9
Domain 3: Implement and manage semantic models25–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%

DP-600 exam facts

QuestionsAbout 40–60
Time limit100 minutes
Passing score700 on a scale of 1–1,000
Exam fee$165 USD (varies by country)
Certification valid for12 months, renewable free online
DeliveryPearson VUE, online proctored or at a test centre. Microsoft Learn is open during the exam
RetakesAfter 24 hours the first time; longer waits for later retakes

Study these topics

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.