Black Friday50% off your first month on any monthly plan with EARLY50 See plans
All 35 lessons
  1. Start here: cloud, data, Fabric and Power BI basics

    1. 1. Start here: the exam, the plan and what you already know
    2. 2. Cloud in plain words: SaaS, PaaS, IaaS and where Fabric fits
    3. 3. Data basics: files, tables, formats and the lakehouse idea
    4. 4. A tour of Microsoft Fabric: OneLake, workspaces and items
    5. 5. Power BI in plain words: semantic models, reports and DAX
  2. Prepare data: get data in (exam area 2, 45-50%)

    1. 6. Connect to data and find it: connections, gateways, OneLake catalog and Real-Time hub
    2. 7. Choosing a data store: lakehouse, warehouse or eventhouse
    3. 8. Use data without copying: shortcuts, mirroring and OneLake integration
    4. 9. Ingest data: Dataflow Gen2, pipelines, Copy job and notebooks
    5. 10. Power Query in Dataflow Gen2: filter, data types, merge and new columns
    6. 11. Messy data: duplicates, missing values and nulls
  3. Prepare data: transform and query (exam area 2)

    1. 12. Views, functions and stored procedures in T-SQL
    2. 13. Build a star schema in a lakehouse or warehouse
    3. 14. Aggregate, join and enrich: SQL and PySpark side by side
    4. 15. Query with the Visual query editor and SQL
    5. 16. Query with KQL
    6. 17. Query with DAX: DAX query view and EVALUATE
  4. Design and build semantic models (exam area 3, 25-30%)

    1. 18. Choose a storage mode: Import, DirectQuery, Direct Lake and Dual
    2. 19. Relationships: star schemas, bridge tables and many-to-many
    3. 20. DAX foundations: measures, filter context, CALCULATE and variables
    4. 21. DAX functions the exam tests: iterators, table filters, windows and information functions
    5. 22. Calculation groups, dynamic format strings and field parameters
    6. 23. Composite models and large semantic model storage format
  5. Optimize models, then secure them (exam areas 3 and 1)

    1. 24. Direct Lake in depth: fallback, refresh and the two flavors
    2. 25. Incremental refresh for semantic models
    3. 26. Faster reports and DAX: finding and fixing slow queries
    4. 27. Who can see what: workspace roles and item permissions
    5. 28. Fine-grained security: rows, columns, objects and files
    6. 29. Governance: sensitivity labels and endorsement
  6. Lifecycle, then exam practice (exam area 1)

    1. 30. Version control: Git integration and Power BI projects (.pbip)
    2. 31. Deployment pipelines and impact analysis
    3. 32. XMLA endpoint and reusable assets: .pbit, .pbids and shared semantic models
    4. 33. Mock exam 1
    5. 34. Final review and exam day: every decision on one page
    6. 35. Mock exam 2
See the leaderboard

15 min

Start here: the exam, the plan and what you already know

See what DP-600 tests, how this course gets you to a pass, and where you should start.

By the end of this lesson you can

  • State the DP-600 exam facts: time, questions, pass mark and renewal
  • Name the three skill areas, their weights and where this course covers them
  • Take Microsoft's free practice assessment and book your exam
  • Pick your starting lesson from a six-question self-check

It's Monday at Juniper Coffee, a chain of 120 cafés in four regions. You've just joined as its analytics engineer. Finance wants one sales report it can trust. Each store manager must see only their own region. The till data, the loyalty app and the budgets all sit in different places.

DP-600 in one minute

DP-600 is Microsoft's exam for the Microsoft Certified: Fabric Analytics Engineer Associate certification. Its full title is Implementing Analytics Solutions Using Microsoft Fabric.

Microsoft Fabric is Microsoft's online analytics platform: storage, data prep and Power BI reports in one service. An analytics engineer prepares the data and builds the semantic model, the layer of tables, relationships and calculations that reports read.

The facts you need:

  • Time: 100 minutes, as the DP-600 exam page states. Plan about 120 minutes in the seat, with instructions.
  • Questions: Microsoft says most exams have 40 to 60 and gives no DP-600 count. Candidates report a case study among them: a long company scenario with several questions.
  • Pass mark: 700 or more, on a scale of 1 to 1,000.
  • No penalty for guessing: a wrong answer scores zero, so answer everything.
  • Renewal: the certification lasts one year. You renew it free with a short, open-book online assessment in the six months before it expires.
  • Languages: English, Japanese, Chinese (Simplified), German, French, Spanish and Portuguese (Brazil). If yours isn't listed, you can request 30 extra minutes.
  • Retakes: if you fail, you can retake it 24 hours later.

[1][2][3][4][5][6]

[4]

The three skill areas, and where this course covers them

Microsoft publishes the skills measured: the official list of what the exam tests. This course follows the version dated October 19, 2026. It has three skill areas.

Skill areaWeightWhere you learn it here
Prepare data45-50%Module 2, lessons 6-11. Module 3, lessons 12-17.
Implement and manage semantic models25-30%Module 4, lessons 18-23. Module 5, lessons 24-26.
Maintain a data analytics solution25-30%Module 5, lessons 27-29. Module 6, lessons 30-32.

Module 1 (lessons 1-5) gives you the basics all three areas need. Lessons 33-35 are two timed mock exams and a final review.

Prepare data is nearly half your score, so it gets twelve lessons. But the other two areas together are worth more than half. Power BI experts tend to lose marks on data prep. Data people tend to lose them on semantic models and DAX.

[6]

Match

Match each skill from the official list to its skill area

Pick an item on the left, then its match on the right.

[6]

A colleague has built Power BI reports for years. He's booked for DP-600 and plans to study only DAX and semantic models, skipping SQL and data prep. What's the problem with his plan?

Pick one answer.

[6]

The languages you'll read

The skills measured say you query data with three languages:

  • SQL (Structured Query Language): queries tables in a Warehouse or a Lakehouse. Fabric uses T-SQL, Microsoft's version of SQL.
  • KQL (Kusto Query Language): queries streams of events stored in an Eventhouse.
  • DAX (Data Analysis Expressions): the formula language of semantic models.

You also meet Power Query, the point-and-click editor in Dataflow Gen2, and a little PySpark, which is Python for big data.

You'll read code more than write it. Candidates report questions like: complete this snippet, pick the query that returns this result, or find the bug. This course teaches each language from zero.

[2][6]

Match

Match each Juniper Coffee task to the language you'd read or write for it

Pick an item on the left, then its match on the right.

[6]

Practice and booking

Book the exam when you have a date in mind. The exam fee depends on the country where you take it. Microsoft shows your price when you book.

  1. Open the DP-600 page on Microsoft Learn and select Schedule exam.
  2. Sign in to your Learn profile. Microsoft recommends a personal Microsoft account. Your legal name must match your ID.
  3. Fill in your details. You then move to Pearson VUE, the company that runs the exam.
  4. Choose an online exam from home or a test center, then a date.
  5. Pay and confirm. You get an email with the details.

[1][7]

[1][6]

How this course works

Depth tags. Microsoft's docs link deeper at every step, so it's easy to study the wrong things. Each topic here opens with one of these tags:

  • Exam depth: know it cold. You must choose it or do it in a scenario. You get the settings and traps.
  • Exam depth: recognize it. You must pick it out of four options. You get one line on what it is and how it differs from its look-alike.
  • Not on the exam. You get a short note on what to ignore and why.

Exam-style questions. Most questions are scenarios at Juniper Coffee. Each has one constraint that decides the answer.

Daily review. A short review brings back questions from each lesson about 1, 3, 7 and 30 days after you finish it. Flashcards come back on their own schedule: sooner when you miss one, later when you know it. Five minutes a day beats a weekend cram.

Listen and review. Above the lesson list, Listen & review lets you play the course as a podcast and review its flashcards. Audio in this course is open to every reader, Free plan included, once a lesson is recorded.

Two timed mock exams. Lessons 33 and 35 run like the real exam, with a score for each skill area.

XP and the leaderboard. You earn 50 XP for each lesson you finish and 10 XP for each right answer. The leaderboard ranks learners by XP. Your name shows only if you turn on Show me on leaderboards in your profile settings; otherwise you appear as an anonymous learner.

[3]

Meet Juniper Coffee

Juniper Coffee is fictional, but its data is typical. You'll build its analytics solution in Fabric across this course.

  • Till sales land in an Azure SQL Database, a database Microsoft runs in its cloud. Every coffee sold is a row.
  • Loyalty-app events stream in all day: sign-ups, points earned, offers opened.
  • Supplier price lists arrive as CSV files, plain text with commas between values.
  • Finance budgets live in Excel.
  • Power BI reports serve store managers, who each see only their region, and the finance team.

Your job is to prepare that data, model it so reports are fast and correct, and keep it secure as it moves to production. That's what a Fabric analytics engineer does, and it's what DP-600 tests.

Rendering diagram…
Juniper Coffee: four sources come together in Fabric, a semantic model sits on top, and Power BI reports read it.
Week one plan: study everything. Week two plan: study what's tested. Picture: Sticky-note sketch style: two yellow sticky notes on a corkboard, drawn in black felt pen.

Self-check: where should you start?

Six quick questions. Questions 1-2 test cloud basics, 3-4 data basics, 5 Power BI and 6 Fabric. Answer without looking anything up. Lessons 2-5 teach all of this from zero, and the table after question 6 tells you where to start.

Question 1 (cloud). Juniper Coffee wants an analytics platform where it never installs, patches or sizes servers. Staff just sign in and build. Which cloud service model fits that need?

Pick one answer.

[8]

Question 2 (cloud). In Microsoft Fabric, what gives a workspace the compute power to run its queries and refreshes?

Pick one answer.

[9]

Question 3 (data). A sales file has 60 columns and 500 million rows. An analyst needs only the total of one column, SalesAmount. Why does this run faster on Parquet than on CSV?

Pick one answer.

[10]

Question 4 (data). Juniper's sales model has one table with a row per item sold (quantity, amount) and another table describing each café (name, region). What are these two tables called in a star schema?

Pick one answer.

[11]

Question 5 (Power BI). Finance wants "Sales vs Budget %" to be calculated the same way in every Juniper report. Where should that calculation live?

Pick one answer.

[2]

Question 6 (Fabric). Till sales sit as Delta tables in a Fabric Lakehouse. An analyst wants to query them with T-SQL, without copying the data anywhere. What lets her do that?

Pick one answer.

[12]

Where to start:

Your resultStart here
Missed question 1 or 2, or never used the cloud.Lesson 2.
Got 1-2 right, missed 3 or 4.Lesson 3.
Got 1-4 right, missed both 5 and 6.Lesson 4, then 5.
Got 1-4 and 6 right, missed 5: you know data but not Power BI.Lesson 5.
Got 1-5 right, missed 6: you know Power BI but not Fabric.Lesson 4, then jump to 6.
All six right.Lesson 6. Skim the flashcards in lessons 2-5.

Take lesson 5 even if you use Power BI daily but have never written DAX. Semantic models are 25-30% of the exam.

FlashcardsIndex cardsFlashcards ⚡

Card 1 of 13

[1][2][3][4][5][6]

Worth keeping

  1. DP-600: 100 minutes, a pass at 700 of 1,000 (scaled), free yearly renewal.
  2. Prepare data is 45-50%; semantic models and maintenance are 25-30% each.
  3. You read SQL, KQL and DAX, plus Power Query and a little PySpark.
  4. Try Microsoft's free practice assessment at aka.ms/DP600-PA before you book.
  5. Microsoft Learn is open during the exam, but the clock keeps running.

The first self-check question said Fabric is SaaS, so you never touch a server. Then who runs the machines, and what exactly does Juniper pay for? Lesson 2 answers that in plain words.

Leaderboard

Loading…

50 XP for each lesson you finish, 10 for each right answer. Names show only for learners who turn on Show me on leaderboards.

Sources for this lesson (12)

Each fact in the lesson is marked with the number of the page it comes from.

  1. [1]Microsoft Learn: Microsoft Certified: Fabric Analytics Engineer Associate
  2. [2]Microsoft Learn: Fabric terminology
  3. [3]Microsoft Learn: Exam duration and exam experience
  4. [4]Microsoft Learn: Exam scoring and score reports
  5. [5]Microsoft Learn: Renew your Microsoft Certification
  6. [6]Microsoft Learn: Study guide for Exam DP-600: Implementing Analytics Solutions Using Microsoft Fabric
  7. [7]Microsoft Learn: Register and schedule an exam
  8. [8]Microsoft Learn: What is Microsoft Fabric?
  9. [9]Microsoft Learn: Understand Microsoft Fabric licenses and capacity
  10. [10]Microsoft Learn: Explore file storage
  11. [11]Microsoft Learn: Dimensional modeling in Fabric Data Warehouse
  12. [12]Microsoft Learn: What is a lakehouse in Microsoft Fabric?