Microsoft

Microsoft Fabric Analytics Engineer (DP-600)
exam objectives

Validates hands-on skill designing, creating, and managing analytical assets in Microsoft Fabric -- semantic models, warehouses, and lakehouses -- including preparing and enriching data, securing and maintaining analytics assets, and implementing semantic models, using SQL, KQL, and DAX.

Questions
60
Duration
100 min
Passing score
700
Domains
3

340 practice questions available for DP-600 on CertPilot AI, mapped to the domains below.

DP-600 exam domains and weightings

The DP-600 exam is split into 3 domains. The percentage next to each is the share of the exam it accounts for — study time is best spent proportionally.

1.0Maintain a data analytics solution

27%

92 practice questions in this domain

  • 1.1Implement security and governance (workspace-level, item-level, row/column/object/file-level access control, sensitivity labels, endorsement)
  • 1.2Maintain the analytics development lifecycle (version control, Power BI Desktop projects, deployment pipelines, impact analysis, XMLA endpoint deployment, reusable assets)

2.0Prepare data

46%

157 practice questions in this domain

  • 2.1Get data (data connections, OneLake catalog and Real-Time hub discovery, ingestion, choosing data stores, OneLake integration for Eventhouse and semantic models)
  • 2.2Transform data (views/functions/stored procedures, enrichment, star schema, denormalization, aggregation, merge/join, data quality issues, type conversion, filtering)
  • 2.3Query and analyze data (select/filter/aggregate using Visual Query Editor, SQL, KQL, and DAX)

3.0Implement and manage semantic models

27%

91 practice questions in this domain

  • 3.1Design and build semantic models (storage mode, star schema, relationships incl. bridge tables and many-to-many, DAX calculations, calculation groups, dynamic format strings, field parameters, large semantic model format, composite models)
  • 3.2Optimize enterprise-scale semantic models (query and report visual performance, DAX performance, Direct Lake configuration and fallback/refresh behavior, Direct Lake on OneLake vs SQL analytics endpoint, incremental refresh)

How to prepare for Microsoft Fabric Analytics Engineer

Most candidates fail DP-600 not because they didn't know the material, but because they couldn't tell which material they were weakest on. Reading the objectives end to end treats every domain as equally important — the exam doesn't. On DP-600, Prepare data alone is 46% of your score.

CertPilot AI works the other way around. It tracks your accuracy per domain, weights each domain by its real exam share, and pulls most of each practice session from wherever you're currently weakest. The result is a single readiness score — at 90% you're in the range where candidates typically pass, so you book the exam on evidence instead of a hunch.

Every question comes with an AI explanation of why the right answer is right and why each distractor is wrong. The Exam Decoder goes further and breaks down how to read a question — the qualifiers, the scenario framing, and the trap options — which is the skill that separates a 740 from a 700.

Microsoft Fabric Analytics Engineer (DP-600) FAQ

How many questions are on the Microsoft Fabric Analytics Engineer (DP-600) exam?

The DP-600 exam has up to 60 questions and you get 100 minutes to complete it.

What score do you need to pass Microsoft Fabric Analytics Engineer?

Microsoft Fabric Analytics Engineer requires a scaled score of 700. Scaled scoring means the raw number of correct answers is adjusted for the difficulty of the specific question set you were served, so there is no fixed percentage that guarantees a pass.

What domains does the DP-600 exam cover?

Microsoft Fabric Analytics Engineer is divided into 3 domains: Maintain a data analytics solution (27%), Prepare data (46%), Implement and manage semantic models (27%). The heaviest weighted domain is Prepare data at 46% of the exam.

How do I know when I'm ready to book the DP-600 exam?

CertPilot AI calculates a readiness score by weighting your accuracy in each domain by that domain's share of the real exam, then scaling it by how many questions you've actually answered — so a domain you've barely touched can't inflate the number. At 90% you're in the range where candidates typically pass.

How much does the DP-600 exam cost?

The Microsoft Fabric Analytics Engineer exam voucher typically costs around $165 USD. Pricing varies by region and vendors periodically adjust it, so confirm on the official vendor site before booking.

Free to start

Start practising DP-600 questions

Adaptive sessions weighted to the domains above, AI explanations on every question, and a readiness score that tells you when to book.

Start free

Other Microsoft certifications