DP-600 Exam Guide: Fabric Skills and Study Plan

The DP-600 exam leads to the Microsoft Certified: Fabric Analytics Engineer Associate credential. You get 100 minutes, you need a score of 700 to pass, and the biggest share of questions (40–45%) is about preparing and serving data in Microsoft Fabric.

This guide covers the skills, the format, the cost, and a six-week plan you can adjust to your own schedule.

What the DP-600 certification proves and who it suits

The official exam is called Exam DP-600: Implementing Analytics Solutions Using Microsoft Fabric. Microsoft rates the certification at the Intermediate level. Its listed roles are Data Engineer and Data Analyst, and the product is Microsoft Fabric. You can read the details on the official certification page.

The credential says you can design, create, and deploy enterprise-scale data analytics solutions. In practice you turn data into reusable assets with Fabric components:

• Lakehouses and data warehouses

• Notebooks, dataflows, and data pipelines

• Semantic models and reports

You also need to query and analyze data with SQL, Kusto Query Language (KQL), and Data Analysis Expressions (DAX). The study guide adds PySpark, data modeling, Git-based source control, and exploratory analytics.

This exam fits you if you already build Power BI models or SQL warehouses and want to prove Fabric skills. If you are new to data work, start with the fundamentals first. Our DP-900 exam guide is a gentler entry point.

Skills measured and their weights

These are the four skill areas and weights from Microsoft's study guide. Use them to decide where your hours go.

Here is what sits inside each area.

Plan, implement, and manage (10–15%)

Expect capacity SKUs, Fabric admin portal settings, and gateway types. You also cover workspace and item-level access, sensitivity labels, and version control. Deployment topics include Power BI Desktop projects (.pbip), the XMLA endpoint, and reusable files such as .pbit and .pbids.

Prepare and serve data (40–45%)

This is the core of the exam. You ingest data with pipelines, dataflows, and notebooks, and you create shortcuts and partition files. You implement star schemas, including Type 1 and Type 2 slowly changing dimensions, and bridge tables. You also tune performance, including Delta table file sizes.

Implement and manage semantic models (20–25%)

You choose a storage mode, including Direct Lake, and write DAX with variables, iterators, and windowing functions. You build calculation groups, field parameters, and composite models with aggregations. You implement and validate row-level and object-level security. You also use DAX Studio and Tabular Editor 2, and set up incremental refresh.

Explore and analyze data (20–25%)

You profile data and apply descriptive and diagnostic analytics. You query lakehouses and warehouses with SQL or the visual query editor. You also connect to datasets through the XMLA endpoint.

Exam format, official price and our voucher terms

Microsoft's pages state these exam facts.

The study guide notes that most questions cover generally available features. Preview features can appear if they are commonly used.

Price comparison

Microsoft publishes the exam price by country or region. As of November 14, 2026, the official list price is $165.00 (source: Microsoft official exam price in USD, as published by the vendor). Our DP-600 voucher costs $44.99, well below the list price.

Voucher terms

• It is valid for 12 months and redeemed with Pearson VUE.

• We email the code within 12 hours of payment. It also appears in your account.

• You can cancel an order for a full refund before delivery.

• A delivered code is non-refundable unless the test provider rejects it as invalid, already used, or expired on first use.

• In that case, contact support within 14 days with your order number and a screenshot. We replace or refund the code.

Full terms are on our refund page and delivery page.

A six-week study plan with weekly hours

This plan assumes about 8 hours a week, roughly 48 hours in total. It is our suggestion, not an official figure. Cut weeks if you already use Fabric daily. Add weeks if SQL, DAX, or PySpark is new to you.

The hours follow the weights. Prepare and serve data gets two full weeks because it is up to 45% of the exam.

Work inside a Fabric workspace every week. Reading alone rarely covers tasks like "choose a method for copying data" or "identify and resolve duplicate data".

In week 6, use the Practice Assessment on AI Skills Navigator. Microsoft says it more closely matches the exam experience. The legacy Practice Assessment on Microsoft Learn is no longer being updated. Also open the exam sandbox to see the question types and the interface before test day.

If you want to go deeper on SQL first, our DP-300 guide covers Azure SQL skills.

Hands-on practice that matches the exam tasks

Practice the small tasks the study guide lists. These examples map to bullets in the guide.

Find duplicate rows in a warehouse

This matches "identify and resolve duplicate data". Run it against a dimension table in your warehouse.

SELECT CustomerID, COUNT(*) AS RowCount
FROM dbo.DimCustomer
GROUP BY CustomerID
HAVING COUNT(*) > 1;

Then try the same fix in a notebook with PySpark:

df_clean = df.dropDuplicates(['CustomerID'])

Write a DAX measure with variables

This matches "write calculations that use DAX variables and functions". Variables make the logic easier to read and debug.

Sales YoY % =
VAR CurrentSales = [Total Sales]
VAR PriorSales =
    CALCULATE ( [Total Sales], SAMEPERIODLASTYEAR ( 'Date'[Date] ) )
RETURN
    DIVIDE ( CurrentSales - PriorSales, PriorSales )

Checklist before you book

1. You can build a star schema and explain why a bridge table is needed.

2. You can explain Type 1 versus Type 2 slowly changing dimensions.

3. You can pick a storage mode, including Direct Lake, and justify it.

4. You can set up row-level security and test it with a test role.

5. You can read a slow query and name one fix.

6. You have opened the exam sandbox.

Common mistakes that cost points

• Studying every topic equally. Prepare and serve data is up to 45%. Plan, implement, and manage is as low as 10%.

• Skipping the lifecycle topics. Git integration, .pbip projects, and deployment solutions are small in weight but easy to learn with practice.

• Treating PySpark as optional. The study guide names it, and conversion and cleansing tasks can use it.

• Relying on the legacy practice test. Microsoft says it is no longer updated. Prefer the new experience.

• Ignoring Preview features. Microsoft says commonly used Preview features can appear.

• Memorizing dumps. They drift from the current skills outline and teach you nothing for the job. Hands-on work holds up better.

• Booking before reading the current study guide. Microsoft's certification page shows a last-updated date of 10/19/2026, so confirm the skills list on the study guide page before you commit.

After you pass: renewal and next steps

Microsoft says associate certifications expire unless you renew. The renewal frequency is 12 months. You renew at no cost by passing an online assessment on Microsoft Learn. Set a calendar reminder so the credential does not lapse.

Link your certification profile to your Microsoft Learn profile so you can share and print your certificate. For more analytics options, browse our Data & Analytics certifications.

Ready to book? The DP-600 voucher is $44.99 and arrives by email within 12 hours.

Sources

• Microsoft Certified: Fabric Analytics Engineer Associate

• Study guide for Exam DP-600: Implementing Analytics Solutions Using Microsoft Fabric