All 35 lessons
Start here: cloud, data, Fabric and Power BI basics
- 1. Start here: the exam, the plan and what you already know
- 2. Cloud in plain words: SaaS, PaaS, IaaS and where Fabric fits
- 3. Data basics: files, tables, formats and the lakehouse idea
- 4. A tour of Microsoft Fabric: OneLake, workspaces and items
- 5. Power BI in plain words: semantic models, reports and DAX
Prepare data: get data in (exam area 2, 45-50%)
- 6. Connect to data and find it: connections, gateways, OneLake catalog and Real-Time hub
- 7. Choosing a data store: lakehouse, warehouse or eventhouse
- 8. Use data without copying: shortcuts, mirroring and OneLake integration
- 9. Ingest data: Dataflow Gen2, pipelines, Copy job and notebooks
- 10. Power Query in Dataflow Gen2: filter, data types, merge and new columns
- 11. Messy data: duplicates, missing values and nulls
Prepare data: transform and query (exam area 2)
Design and build semantic models (exam area 3, 25-30%)
- 18. Choose a storage mode: Import, DirectQuery, Direct Lake and Dual
- 19. Relationships: star schemas, bridge tables and many-to-many
- 20. DAX foundations: measures, filter context, CALCULATE and variables
- 21. DAX functions the exam tests: iterators, table filters, windows and information functions
- 22. Calculation groups, dynamic format strings and field parameters
- 23. Composite models and large semantic model storage format
Optimize models, then secure them (exam areas 3 and 1)
- 24. Direct Lake in depth: fallback, refresh and the two flavors
- 25. Incremental refresh for semantic models
- 26. Faster reports and DAX: finding and fixing slow queries
- 27. Who can see what: workspace roles and item permissions
- 28. Fine-grained security: rows, columns, objects and files
- 29. Governance: sensitivity labels and endorsement
Lifecycle, then exam practice (exam area 1)
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.
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 area | Weight | Where you learn it here |
|---|---|---|
| Prepare data | 45-50% | Module 2, lessons 6-11. Module 3, lessons 12-17. |
| Implement and manage semantic models | 25-30% | Module 4, lessons 18-23. Module 5, lessons 24-26. |
| Maintain a data analytics solution | 25-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.
Match
Match each skill from the official list to its skill area
Pick an item on the left, then its match on the right.
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.
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.
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.
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.
- Open the DP-600 page on Microsoft Learn and select Schedule exam.
- Sign in to your Learn profile. Microsoft recommends a personal Microsoft account. Your legal name must match your ID.
- Fill in your details. You then move to Pearson VUE, the company that runs the exam.
- Choose an online exam from home or a test center, then a date.
- Pay and confirm. You get an email with the details.
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.
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.
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.
Question 2 (cloud). In Microsoft Fabric, what gives a workspace the compute power to run its queries and refreshes?
Pick one answer.
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.
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.
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.
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.
Where to start:
| Your result | Start 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.
Worth keeping
- DP-600: 100 minutes, a pass at 700 of 1,000 (scaled), free yearly renewal.
- Prepare data is 45-50%; semantic models and maintenance are 25-30% each.
- You read SQL, KQL and DAX, plus Power Query and a little PySpark.
- Try Microsoft's free practice assessment at aka.ms/DP600-PA before you book.
- 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]Microsoft Learn: Microsoft Certified: Fabric Analytics Engineer Associate
- [2]Microsoft Learn: Fabric terminology
- [3]Microsoft Learn: Exam duration and exam experience
- [4]Microsoft Learn: Exam scoring and score reports
- [5]Microsoft Learn: Renew your Microsoft Certification
- [6]Microsoft Learn: Study guide for Exam DP-600: Implementing Analytics Solutions Using Microsoft Fabric
- [7]Microsoft Learn: Register and schedule an exam
- [8]Microsoft Learn: What is Microsoft Fabric?
- [9]Microsoft Learn: Understand Microsoft Fabric licenses and capacity
- [10]Microsoft Learn: Explore file storage
- [11]Microsoft Learn: Dimensional modeling in Fabric Data Warehouse
- [12]Microsoft Learn: What is a lakehouse in Microsoft Fabric?