Study guide

DP-600 study guide

DP-600Microsoft Certified: Fabric Analytics Engineer Associate

What the exam covers, how much each part weighs and how to study, based on Microsoft’s official study guide.

Checked on · skills measured as of Official study guide(opens in a new tab)

The exam changes often. Always check the official page before you book it.

About the exam

Exam name
Implementing Analytics Solutions Using Microsoft Fabric
Passing score
700 or higher, on a 1 to 1000 scale. It is a scaled score: it does not mean 70% of correct answers.
Duration
100 minutes.
Languages
Includes Portuguese (Brazil). English is updated first; other languages about 8 weeks later. If the exam is not available in your language, you can request 30 extra minutes.
Price
USD 99 in Brazil. The price varies by the country where you take the exam.
Renewal
Yearly and free, through an online assessment on Microsoft Learn (no need to retake the exam).
If you fail
You can retake it 24 hours after the first attempt. For later attempts, the waiting time varies.

Candidate profile

Someone with expertise in designing, creating and managing analytical assets such as semantic models, warehouses and lakehouses.

  • Prepare and enrich data for analysis
  • Secure and maintain analytics assets
  • Implement and manage semantic models

You are also expected to query and analyze data with SQL, KQL and DAX.

Domain weights

Prepare data is almost half of the exam. People coming from Power BI tend to underestimate this domain. A sensible time split is ~30% / 45% / 25%.

Microsoft states that most questions cover GA features, but the exam may include Preview features if they are commonly used.

Skills measured

The official topics for each domain. Tap a domain to open it.

1Maintain a data analytics solution25–30%11 topics

Implement security and governance

  • Workspace-level access controls
  • Item-level access controls
  • Row-level (RLS), column-level (CLS), object-level and file-level access control
  • Apply sensitivity labels to items
  • Endorse items (Promoted / Certified)

Official docs:Fabric permission model (opens in a new tab)Row-level security (opens in a new tab)Column-level security (opens in a new tab)Apply sensitivity labels (opens in a new tab)Endorsement (Promoted / Certified) (opens in a new tab)

Maintain the analytics development lifecycle

  • Configure version control for a workspace
  • Create and manage a Power BI Desktop project (.pbip)
  • Create and configure deployment pipelines
  • Perform impact analysis of downstream dependencies from lakehouses, warehouses, dataflows and semantic models
  • Deploy and manage semantic models through the XMLA endpoint
  • Create and update reusable assets: .pbit templates, .pbids data source files and shared semantic models

Official docs:Git integration (opens in a new tab)Power BI Desktop projects (.pbip) (opens in a new tab)Deployment pipelines (opens in a new tab)Impact analysis (opens in a new tab)XMLA endpoint (opens in a new tab)

2Prepare data45–50%15 topics

Get data

  • Create a data connection
  • Discover data with the OneLake catalog and Real-Time hub
  • Ingest or access data as needed
  • Choose between different data stores (lakehouse × warehouse × eventhouse)
  • Implement OneLake integration for Eventhouse and semantic models

Official docs:Choose a data store (opens in a new tab)OneLake catalog (opens in a new tab)Real-Time hub (opens in a new tab)Eventhouse OneLake availability (opens in a new tab)

Transform data

  • Create views, functions and stored procedures
  • Enrich data with new columns or tables
  • Implement a star schema in a lakehouse or warehouse
  • Denormalize, aggregate, merge/join
  • Identify and resolve duplicate, missing or null data
  • Convert column types and filter

Official docs:Dimensional modeling in Fabric Data Warehouse (opens in a new tab)Dataflow Gen2 (opens in a new tab)

Query and analyze data

  • Select, filter and aggregate with the Visual query editor
  • ... with SQL
  • ... with KQL
  • ... with DAX

Official docs:Visual query editor (opens in a new tab)SQL query editor (opens in a new tab)KQL queryset (opens in a new tab)DAX query view (opens in a new tab)

Study tip: answer the same 3 business questions in all 4 languages.

3Implement and manage semantic models25–30%12 topics

Design and build semantic models

  • Choose a storage mode
  • Implement a star schema in the semantic model
  • Relationships, including bridge tables and many-to-many
  • Calculations with DAX variables and functions such as iterators, table filtering, windowing and information functions
  • Calculation groups, dynamic format strings and field parameters
  • Identify use cases for and configure the large semantic model storage format
  • Design and build composite models

Official docs:Storage mode (opens in a new tab)Star schema (opens in a new tab)Many-to-many relationships (opens in a new tab)Calculation groups (opens in a new tab)Field parameters (opens in a new tab)Large semantic models (opens in a new tab)Composite models (opens in a new tab)

Optimize enterprise-scale semantic models

  • Improve query and report visual performance
  • Improve DAX performance
  • Configure Direct Lake, including default fallback and refresh behavior
  • Choose between Direct Lake on OneLake and Direct Lake on SQL analytics endpoint
  • Implement incremental refresh

Official docs:Optimization guide for Power BI (opens in a new tab)Performance Analyzer (opens in a new tab)Direct Lake overview (opens in a new tab)Direct Lake: OneLake × SQL (opens in a new tab)Incremental refresh (opens in a new tab)

Direct Lake in 30 seconds

  • Direct Lake loads data straight from OneLake, with no import step.
  • Direct Lake on SQL: the expression points to the SQL analytics endpoint, which is used to discover schema and security and allows fallback to DirectQuery. Use it when you rely on security rules defined on the SQL analytics endpoint or need the fallback.
  • Direct Lake on OneLake: the expression points straight to OneLake storage; it supports composite models.

Study strategy

  1. Don’t memorize, actually learn. The goal is to be ready for the job and for technical interviews.
  2. Follow the official Microsoft Learn path for DP-600 (the certification page lists the learning paths).
  3. Do the hands-on labs from the mslearn-fabric repository, not just the theory.
  4. Read the official documentation: many questions come from it.
  5. Use the official Practice Assessment only to validate, not as your main guide.
  6. Practice on a Fabric trial capacity and document what you learn (e.g. LinkedIn posts).
  7. Try the exam sandbox before exam day so you don’t learn the interface on the spot.

8-week plan

6 to 8 hours a week, with time split according to each domain’s weight.

  1. Weeks1–2

    Fabric fundamentals and Get data (lakehouse × warehouse × eventhouse, OneLake catalog, Real-Time hub)

    Hands-on task: Ingest the same dataset into a lakehouse and a warehouse and compare

    Official docs:What is a lakehouse? (opens in a new tab)What is data warehousing? (opens in a new tab)Choose a data store (opens in a new tab)OneLake catalog (opens in a new tab)Real-Time hub (opens in a new tab)

  2. Weeks3–4

    Transform and Query (star schema, views, SQL, KQL, DAX, Visual query editor)

    Hands-on task: Model a messy file into a star schema and answer 3 questions in all 4 languages

    Official docs:Dimensional modeling (opens in a new tab)Visual query editor (opens in a new tab)SQL query editor (opens in a new tab)KQL queryset (opens in a new tab)DAX query view (opens in a new tab)

  3. Weeks5–6

    Semantic models (storage modes, advanced DAX, calculation groups, Direct Lake, incremental refresh)

    Hands-on task: Take a slow report and make it measurably faster

    Official docs:Storage mode (opens in a new tab)Calculation groups (opens in a new tab)Direct Lake overview (opens in a new tab)Incremental refresh (opens in a new tab)Performance Analyzer (opens in a new tab)

  4. Weeks7

    Security, governance and lifecycle (RLS/CLS/OLS/file-level, labels, git, .pbip, deployment pipelines, XMLA)

    Hands-on task: Set up a workspace with Git + a deployment pipeline

    Official docs:Fabric permission model (opens in a new tab)Row-level security (opens in a new tab)Apply sensitivity labels (opens in a new tab)Git integration (opens in a new tab)Deployment pipelines (opens in a new tab)XMLA endpoint (opens in a new tab)

  5. Weeks8

    Practice Assessment, timed mock exam, sandbox, gap review

    Hands-on task: Redo (don’t reread) everything that scored below 70%

    Official docs:Practice Assessment DP-600 (opens in a new tab)Exam sandbox (opens in a new tab)Study guide DP-600 (opens in a new tab)

DP-600 × DP-700 × PL-300

ExamFocus
PL-300Data analyst in Power BI
DP-600Analytics engineer: semantic models, star schema, DAX, Direct Lake, analytics governance
DP-700Data engineer: ingestion, pipelines, transformation, orchestration

DP-600 and DP-700 share lakehouse and warehouse fundamentals.

Resources and links