Free study guide

Microsoft DP-600 Study Guide

Microsoft Fabric Analytics Engineer DP-600

Microsoft DP-600, Implementing Analytics Solutions Using Microsoft Fabric, is the associate exam for the Fabric Analytics Engineer certification. It covers securing and maintaining analytics assets, preparing data in lakehouses, warehouses and eventhouses, querying with SQL, KQL and DAX, and building and optimizing semantic models, including Direct Lake. It suits analytics engineers and Power BI developers who work in Microsoft Fabric.

  • Exam code DP-600
  • Associate level
  • 3 exam domains

This guide is free, with no sign-up. It explains every Microsoft DP-600 exam topic in plain English, one chapter at a time. Read them in order or jump straight to the topic you need.

  • 3chapters
  • 18topics
  • 5diagrams and exhibits
  • 1 h 33 minfast track
Start with Maintain a Data Analytics Solution
  • Every topic follows the same simple pattern: what it is, how it works, common mistakes
  • Diagrams and real command output where a picture explains it best
  • Exam tips and worked subnetting and IPv6 practice, with answers

How the exam is weighted

Each domain is worth roughly this share of the exam. The exam provider publishes a range for each domain, so the bar marks the middle of it. Spend your study time in proportion, and select a domain to open its chapter.

Chapters

Open a chapter to see its topics and how long each takes.

1Maintain a Data Analytics Solution5 topics · 26 min fast trackFabric workspace and item access, row, column and file security, sensitivity labels, Git, deployment pipelines and XMLA.
  1. 1Workspace and Item Access Controls5 min
  2. 2Row, Column, Object and File Security6 min
  3. 3Sensitivity Labels and Endorsement5 min
  4. 4Git Integration, PBIP and Deployment Pipelines5 min
  5. 5Impact Analysis, XMLA and Reusable Assets5 min
Read the chapter overview →
2Prepare Data7 topics · 35 min fast trackGet data into Fabric, choose a store, build a star schema, and query it with the visual editor, SQL, KQL and DAX.
  1. 1Data Connections and Data Discovery5 min
  2. 2Ingest or Access Data and Choose a Store5 min
  3. 3Views, Functions, Procedures and Enrichment5 min
  4. 4Star Schema, Denormalize, Aggregate and Join5 min
  5. 5Clean, Convert and Filter Data5 min
  6. 6Query with the Visual Query Editor and SQL5 min
  7. 7Query with KQL and DAX5 min
Read the chapter overview →
3Implement and Manage Semantic Models6 topics · 32 min fast trackStorage modes, relationships, DAX, calculation groups, performance tuning, Direct Lake and incremental refresh.
  1. 1Storage Modes and Composite Models6 min
  2. 2Model Star Schema and Relationships5 min
  3. 3DAX Variables, Iterators, Filters and Windows5 min
  4. 4Calculation Groups, Format Strings, Parameters5 min
  5. 5Query, Visual and DAX Performance5 min
  6. 6Direct Lake and Incremental Refresh6 min
Read the chapter overview →

Ready for more practice?

The full Microsoft DP-600 question bank has 648 questions, with timed practice exams and an explanation for every answer.

SubscribeTry Sample Exam

This study guide is independent and is not affiliated with, endorsed by, or sponsored by Microsoft. Vendor names, certification names and exam codes are trademarks of their respective owners and are used for identification only.