🔒 Guided

Pre-launch preview. Authorised access only.

Incorrect code

Guided by A Guide to Cloud
Explore AB-900 AI-901
DP-600

Fabric Analytics Engineer
Associate

The Microsoft Fabric analytics certification. Lakehouses, warehouses, Direct Lake, DAX, semantic models, and deployment pipelines — explained with real-world scenarios from retail, finance, healthcare, and consulting.

📖

Study Guide

29 interactive modules

5 study modules (Fabric Big Picture, Lakehouses, Warehouses, Choosing Data Store, Star Schema) + 16 practice questions. No account needed.

Start Free →
✍️

Practice Exam

200 exam-style questions

Study mode with explanations + timed exam simulation. 16 free questions.

Try Free Questions →

29

Modules

200

Questions

3

Domains

Free

Domain 2 included

📝 Sample Question

Anita at FreshCart has 200M rows in a Fabric lakehouse. She needs fast Power BI dashboards with near real-time data. Which storage mode should she choose?

A. Import — load all rows for fastest queries
B. DirectQuery — query the lakehouse live
C. Direct Lake — read Delta tables from OneLake into memory on demand ✓

📊 What you'll cover

Maintain a Data Analytics Solution 7 modules
Prepare Data (Free) 14 modules
Implement and Manage Semantic Models 8 modules

What you'll learn

🏗️

Fabric Architecture

OneLake, lakehouses, warehouses, Eventhouse — understand every data store and when to use each. Star schema design with worked examples.

⚡

Direct Lake & DAX

Fabric's game-changing storage mode explained in depth. DAX variables, iterators, calculation groups, and performance optimization.

🔒

Security & Governance

RLS, CLS, OLS, sensitivity labels, Git integration, and deployment pipelines. Enterprise-grade analytics lifecycle management.

📊

Hands-On Patterns

DAX code examples, SQL queries, KQL time-series, PySpark notebooks — every code block has line-by-line explanations.

Full Curriculum

29 interactive modules across 3 exam domains

1

Maintain a Data Analytics Solution

7 modules

Premium

Workspace and item-level security. Row-level, column-level, and object-level security. Sensitivity labels and endorsement. Git version control, deployment pipelines, impact analysis, and XMLA endpoint management.

  1. 1Workspace Access Controls
  2. 2Row-Level & Object-Level Security
  3. 3Sensitivity Labels & Endorsement
  4. 4Git Version Control
  5. 5Deployment Pipelines
  6. 6Impact Analysis & Dependencies
  7. 7XMLA Endpoint & Reusable Assets
Preview Domain
2

Prepare Data

14 modules

Free

Microsoft Fabric architecture, OneLake, lakehouses, warehouses, and data store selection. Data connections, shortcuts, ingestion with Dataflows Gen2 and pipelines. Star schema design, SQL objects, transformations, data quality. Querying with SQL, KQL, and DAX.

  1. 1Fabric: The Big Picture
  2. 2Lakehouses: Your Data Foundation
  3. 3Warehouses in Fabric
  4. 4Choosing the Right Data Store
  5. 5Data Connections & OneLake Catalog
  6. 6Shortcuts & OneLake Integration
  7. 7Ingesting Data: Dataflows Gen2 & Pipelines
  8. 8Star Schema Design
  9. 9SQL Objects: Views, Functions & SPs
  10. 10Transforming Data: Reshape & Enrich
  11. 11Data Quality & Cleansing
  12. 12Querying with SQL
  13. 13Querying with KQL
  14. 14Querying with DAX
Start Free →
3

Implement and Manage Semantic Models

8 modules

Premium

Storage modes (Import, DirectQuery, Direct Lake). Relationships, bridge tables, many-to-many. DAX variables, iterators, windowing. Calculation groups, field parameters. Large models, composite models. Direct Lake configuration. DAX performance. Incremental refresh.

  1. 1Semantic Models: Storage Modes
  2. 2Relationships & Advanced Modeling
  3. 3DAX Essentials: Variables & Functions
  4. 4Calculation Groups & Field Parameters
  5. 5Large Models & Composite Models
  6. 6Direct Lake Mode
  7. 7DAX Performance Optimization
  8. 8Incremental Refresh
Preview Domain

Practice Exam Lab

200 original questions — two study modes

📖

Study Mode

Learn as you go

  • ✓ See explanation after each question
  • ✓ "Why wrong" for every option
  • ✓ Real-world context & exam tips
  • ✓ Microsoft Learn links
⏱️

Exam Mode

Simulate the real thing

  • ✓ 120 minutes timed session
  • ✓ Randomised question order
  • ✓ Score breakdown by domain
  • ✓ Pass/fail against 700 / 1000
1

Maintain a Data Analytics Solution

55 questions · Exam weight: 25-30%

0 Free

15

Easy

27

Medium

13

Hard

Every question includes a scenario, detailed explanation, and a link to Microsoft Learn.

Preview Questions
2

Prepare Data

90 questions · Exam weight: 45-50%

16 Free

25

Easy

45

Medium

20

Hard

Every question includes a scenario, detailed explanation, and a link to Microsoft Learn.

Try Free Questions →
3

Implement and Manage Semantic Models

55 questions · Exam weight: 25-30%

0 Free

15

Easy

27

Medium

13

Hard

Every question includes a scenario, detailed explanation, and a link to Microsoft Learn.

Preview Questions

🎁 Free tier: 16 questions. No account needed.

Choose your path

Start free. Upgrade when you're ready.

Practice Exam

$14

one-time purchase

  • ✓ 200 exam-style questions
  • ✓ Study mode + Exam mode
  • ✓ Detailed explanations

Study Guide

$19

one-time purchase

  • ✓ 29 interactive modules
  • ✓ Flashcards & ELI5
  • ✓ Progress tracking
Recommended

Complete Bundle

$29

save $4

  • ✓ Everything in both
  • ★ Best value

🎁 Free tier: 5 study modules (Fabric Big Picture, Lakehouses, Warehouses, Choosing Data Store, Star Schema) + 16 practice questions. No account needed. No account needed.

About the DP-600 Exam

Exam code
DP-600
Duration
120 minutes
Passing score
700 / 1000
Question types
MCQ, multi-select, case studies
Cost
$165 USD

Exam Domains & Weights

D1: Maintain a Data Analytics Solution (25-30%)
D2: Prepare Data (45-50%)
D3: Implement and Manage Semantic Models (25-30%)
View on Microsoft Learn →

Frequently Asked Questions

What is DP-600?
DP-600 (Implementing Analytics Solutions Using Microsoft Fabric) is an intermediate-level Microsoft certification for analytics engineers. It covers data preparation, semantic models, DAX, and analytics lifecycle management in Microsoft Fabric.
Do I need PL-300 first?
PL-300 is recommended but not required. DP-600 assumes familiarity with SQL, DAX, or KQL. If you are new to Power BI, start with PL-300 first.
What's in the free tier?
Five study modules covering Fabric architecture, lakehouses, warehouses, data store selection, and star schema design — plus 16 practice questions. No account needed.
How is this different from DP-900?
DP-900 is Fundamentals — broad overview of data concepts. DP-600 is Associate — deep hands-on with Fabric, DAX, semantic models, and deployment. DP-600 is significantly more technical.
Is this a one-time purchase?
Yes. Pay once, access forever. No subscription or recurring fees.
Can I study on my phone?
Yes — every module is optimised for 10-minute mobile study sessions.

Ready to start?

Try the free tier. Upgrade when you're ready to pass.

Start Free → Try Practice Quiz

Guided

I learn, I simplify, I share.

A Guide to Cloud YouTube Feedback

© 2026 Sutheesh. All rights reserved.

Guided is an independent study resource and is not affiliated with, endorsed by, or officially connected to Microsoft. Microsoft, Azure, and related trademarks are property of Microsoft Corporation. Always verify information against Microsoft Learn.