Skip to content
Cheat sheets
Associate · DP-600Prep available

Microsoft Certified: Fabric Analytics Engineer Associate (DP-600) practice exam and study path

A free, timed 60-question DP-600 practice exam in 100 minutes, scored by domain, with every option explained after you submit. Also 104 practice questions you can check one at a time, a page for every task in the exam guide, and a study path. No sign-up.

Start the free practice examGet the exam packPractice question by question →
Fabric Analytics Engineer Associate exam pack:

$6.99for 12 months

For analytics engineers who build on Microsoft Fabric: planning capacity, access and the development lifecycle, preparing and serving data in lakehouses and warehouses, designing and tuning semantic models with Direct Lake and DAX, and exploring and querying the results.

The exam

Exam code
DP-600
Questions
Not yet published
Time
100 minutes
Passing score
700 of 1,000 (scaled)
Exam fee
$165 (USD)
Question types
multiple choice, multiple response

Exam DP-600 is a proctored role-based exam: 100 minutes, offered in seven languages through Pearson VUE, it may include interactive components, and 700 passes. Microsoft doesn't publish the number of questions (most of its exams have 40 to 60). The fee is set by the country or region (USD 165 in the United States, the price of Microsoft's DP role-based exams), and the certification renews every year with a free online assessment. Our questions follow the skills listed in the study guide read on November 1, 2026. Our forms use 60 questions split 8 / 25 / 14 / 13, the midpoints of the guide's ranges.

From Microsoft's certification page and exam guide, checked Nov 1, 2026.

Domains and weights

  • Domain 1: Plan, implement, and manage a solution for data analytics

    13%

  • Domain 2: Prepare and serve data

    42%

  • Domain 3: Implement and manage semantic models

    23%

  • Domain 4: Explore and analyze data

    22%

On our roadmap this comes after Azure Fundamentals. See every certification.

Practice

104 original practice questions, every option explained with the Microsoft documentation page that proves it. Free, no sign-up; progress stays on this device.

Your results on this device →

More practice exams

The lessons, the sample questions on every task page and the first full practice exam are free and stay free. A pack adds the further timed DP-600 practice exams.

Fabric Analytics Engineer Associate exam pack

$6.99for 12 months

  • Every paid DP-600 practice exam, timed, with every option explained
  • The next version of this exam included when it changes within your 12 months
  • 12 months of access. One payment, nothing renews by itself.
  • 14-day refund, no conditions
  • 14-day refund, no conditions: ask within 14 days of buying and you get the whole payment back.
  • No pass guarantee. These are practice exams written by us from the exam guide and the Microsoft documentation; a score here does not predict your result on the real exam.

Study path

One module per exam domain. Lessons that already exist on BytePatterns are linked; the rest are being written.

  1. Module 1: Plan, implement, and manage a solution for data analytics

    1. 1Solution requirements: components, features, performance and capacity SKUsTask 1.1

      Lesson coming

    2. 2Fabric admin portal and delegated tenant settingsTask 1.1

      Lesson coming

    3. 3Choosing an on-premises or virtual network data gatewayTask 1.1

      Lesson coming

    4. 4Custom Power BI report themesTask 1.1

      Lesson coming

    5. 5Workspace roles, item permissions and data sharingTask 1.2

      Lesson coming

    6. 6Sensitivity labels on semantic models and lakehousesTask 1.2

      Lesson coming

    7. 7Workspace settings and capacity management: assign, pause, resume and scaleTask 1.2

      Partly covered by: AWS Cost Levers

    8. 8Git integration and Power BI Desktop projects (.pbip)Task 1.3

      Lesson coming

    9. 9Deployment pipelines and deployment rulesTask 1.3

      Lesson coming

    10. 10Impact analysis of downstream dependenciesTask 1.3

      Lesson coming

    11. 11The XMLA endpoint, .pbit and .pbids files and shared semantic modelsTask 1.3

      Lesson coming

  2. Module 2: Prepare and serve data

    1. 12Ingesting with pipelines, dataflows and notebooksTask 2.1

      Lesson coming

    2. 13Shortcuts and file partitioningTask 2.1

      Lesson coming

    3. 14Views, functions, stored procedures and new columns or tablesTask 2.1

      Lesson coming

    4. 15Choosing how to copy data from a Fabric sourceTask 2.2

      Lesson coming

    5. 16Pipeline activities and schedules for pipelines, dataflows and notebooksTask 2.2

      Lesson coming

    6. 17Cleansing data: duplicates, missing data and nullsTask 2.3

      Partly covered by: Data Readiness for AI

    7. 18Star schemas with type 1 and type 2 slowly changing dimensions, and bridge tablesTask 2.3

      Lesson coming

    8. 19Denormalizing, aggregating, merging and joiningTask 2.3

      Partly covered by: INNER and OUTER JOINs, Aggregations & GROUP BY

    9. 20Converting data types and filtering with SQL or PySparkTask 2.3

      Partly covered by: WHERE and Filtering

    10. 21Data loading bottlenecks in dataflows, notebooks and SQL queriesTask 2.4

      Partly covered by: Reading a Query Plan

    11. 22Delta table file sizes, V-Order and table maintenanceTask 2.4

      Lesson coming

  3. Module 3: Implement and manage semantic models

    1. 23Choosing a storage mode: Import, DirectQuery, Direct Lake or compositeTask 3.1

      Partly covered by: Caching

    2. 24Direct Lake framing, fallback, guardrails and securityTask 3.1

      Lesson coming

    3. 25Star schemas, bridge tables and many-to-many relationshipsTask 3.1

      Lesson coming

    4. 26DAX variables, iterators, table filtering, window and information functionsTask 3.1

      Partly covered by: Window Functions

    5. 27Calculation groups, dynamic format strings and field parametersTask 3.1

      Lesson coming

    6. 28Large semantic models and composite models with aggregationsTask 3.1

      Lesson coming

    7. 29Dynamic row-level and object-level security, and validating itTask 3.1

      Lesson coming

    8. 30DAX Studio and Tabular Editor 2Task 3.1, 3.2

      Lesson coming

    9. 31Faster queries and report visualsTask 3.2

      Lesson coming

    10. 32Incremental refresh, partitions and the enhanced refresh APITask 3.2

      Lesson coming

  4. Module 4: Explore and analyze data

    1. 33Descriptive and diagnostic analyticsTask 4.1

      Lesson coming

    2. 34Predictive and prescriptive analytics in a visual or reportTask 4.1

      Lesson coming

    3. 35Profiling data in notebooks, SQL and Data WranglerTask 4.1

      Partly covered by: Data Readiness for AI

    4. 36Querying lakehouses and warehouses with SQL and the visual query editorTask 4.2

      Partly covered by: SELECT Basics, WHERE and Filtering, Subqueries

    5. 37Querying semantic models through the XMLA endpointTask 4.2

      Lesson coming

Every task in the exam guide

The exam guide splits each domain into task statements. Each one has a page with a short summary, the lessons that teach it and open sample questions.

Domain 1: Plan, implement, and manage a solution for data analytics

Domain 2: Prepare and serve data

Domain 3: Implement and manage semantic models

Domain 4: Explore and analyze data

How these questions are made

  • Written by us from the exam guide's task statements and the Microsoft documentation — never from real exam content.
  • Every option carries its own explanation and a link to the Microsoft page that proves it.
  • A question enters a timed exam only after an independent check; until then it is a practice question.
  • Results are a plain percentage, per domain too — not an imitation of Microsoft's scaled score.

Questions about the DP-600 practice exam

Is the DP-600 practice exam free?
Yes. The full practice exam (60 questions, 100 minutes) is free with no sign-up, and so are the 104 practice questions, the task pages and the study path. Your attempts are saved in this browser, on this device.
How many questions does it have, and is it timed?
60 questions in 100 minutes: the real DP-600 pace, scaled to this form. When the time runs out, the exam is submitted as it stands.
Are the answers explained?
After you submit, not during: like the real exam, the timed exam gives no feedback until the end. Then you get your score overall and per exam domain, and every question with each option explained and a link to the Microsoft documentation page behind it. In practice mode an answer is explained as soon as you check it.
What does the Fabric Analytics Engineer Associate exam pack add?
3 more timed practice exams (Practice exam 1: 60 questions, 100 minutes; Practice exam 2: 60 questions, 100 minutes; Practice exam 3: 60 questions, 100 minutes), each scored and explained the same way, and the next version of this exam if it changes within your 12 months. 12 months of access. One payment, nothing renews by itself. Everything above stays free. See the pack.
Can I get a refund?
Yes, with no conditions: ask within 14 days of buying and you get the whole payment back. The details are in the terms.
Is this an official Microsoft practice exam?
No. BytePatterns is not affiliated with, endorsed or sponsored by Microsoft. Every question is written by us from the public exam guide and the Microsoft documentation, never from real exam content, and a score here does not predict your result on the real exam. Microsoft lists its own preparation resources on its certification page.