DP-600

Fabric Analytics Engineer DP-600 practice exams

240 questions in 5 timed practice tests. Each test has about 50 questions and a 100-minute limit. The pass mark is 70%. Results are split across the 4 exam domains.

Exam at a glance

DP-600 practice exam settings
Practice tests 5
Questions in total 240
Questions per test About 50
Time limit per test 100 minutes
Pass mark 70%
Question types Single answer and multiple answer (25 multiple-answer questions)
Level Associate
Category Data & Analytics

These are the settings of our practice tests. Check the official Microsoft exam page for the current exam format before you book.

Domains and weights

DP-600 exam domains, weights and question counts
Domain Weight Weight bar Questions in our bank
Plan, implement, and manage a solution for data analytics 13% 31
Prepare and serve data 42% 101
Implement and manage semantic models 23% 55
Explore and analyze data 22% 53

Sample questions

Question 1 of 3

Your organization stores sales data in a SQL Server instance running in its own data center. A Dataflow Gen2 in Fabric must refresh from this database every night. Several data engineers will reuse the same connection for other dataflows and semantic models. Which gateway should you deploy?

  1. A An on-premises data gateway in standard mode installed on a server that can reach the SQL Server instance (correct answer)
  2. B An on-premises data gateway in personal mode installed on the workstation of the engineer who owns the dataflow
  3. C No gateway, because Fabric reaches on-premises SQL Server directly through the OneLake shortcut connectors
  4. D A virtual network (VNet) data gateway attached to a delegated subnet in the company's Azure virtual network
Why: A standard-mode on-premises data gateway is the shared, centrally managed option for on-premises sources and supports Dataflow Gen2, pipelines and semantic models. Personal mode serves one user and only Power BI semantic models, so it cannot be shared or used by dataflows. A VNet data gateway reaches Azure resources inside a virtual network, not a server in a private data center without network integration. OneLake shortcuts do not connect to on-premises SQL Server, so a gateway is still required.

Question 2 of 3

A Fabric F32 capacity runs Spark jobs, warehouse queries, and Power BI reports. Every morning between 8:00 and 9:00, users see delays in interactive reports, and the Capacity Metrics app shows that background usage from overnight jobs is carried forward and throttling occurs. The company wants to keep the capacity size for the rest of the day and avoid long-term cost increases. What should you do?

  1. A Move the Spark jobs to a separate F32 capacity that runs only at night, keeping the morning capacity dedicated to interactive Power BI reports
  2. B Pause the capacity at 7:00 every morning and resume it at 8:00 so that the accumulated overage is cleared just before the business day begins
  3. C Reschedule the heavy background jobs so that they finish earlier and spread across the night, reducing the carry-forward of smoothed usage (correct answer)
  4. D Upgrade the capacity to F64 permanently so that the extra capacity units absorb both the overnight jobs and the morning interactive load
Why: Background operations are smoothed over 24 hours, so heavy late-night jobs carry usage into the morning; spreading them out and finishing earlier reduces the overlap with interactive peaks without adding cost. A second F32 capacity doubles cost. Pausing a capacity settles the accumulated overage as a charge immediately and makes it unavailable while paused, which is a workaround rather than a fix. A permanent upgrade increases cost all day, which the company wants to avoid.

Question 3 of 3

You load customer data into a lakehouse and must implement a Type 2 slowly changing dimension in a PySpark notebook. Changed customers must have their current row closed and a new current row inserted. Which approach should you use in a single Delta merge?

  1. A Overwrite the dimension with the latest source extract and add an IsCurrent column that is set to true for every row
  2. B Merge on the business key with whenMatchedUpdateAll so that every changed attribute overwrites the current row in place
  3. C Merge on the surrogate key with whenNotMatchedInsertAll so that each changed customer receives an additional row
  4. D Stage each changed row twice, once keyed to expire the current row and once with a null key so it is inserted (correct answer)
Why: In a single merge, matched rows can only be updated, so the changed records are staged twice: once with the business key to expire the current row, and once with a null key so they fall into the not-matched branch and are inserted as the new current row. whenMatchedUpdateAll overwrites history, which is Type 1. Merging on the surrogate key never matches source rows because new surrogate keys are generated, so current rows are never closed. Overwriting with the latest extract discards history.

What your score report looks like

Example attempt, DP-600 practice test 3

76%

Passed
Pass mark 70%

Score by exam domain
DomainWeightYour score%
Plan, implement, and manage a solution for data analytics 13%
88
Prepare and serve data 42%
81
Implement and manage semantic models 23%
76
Explore and analyze data 22%
58

Study next: Explore and analyze data. It is below the pass mark and carries 22% of the exam.

Domains and pass mark from our DP-600 practice tests. Scores are an example attempt.

Study plans

Two weeks

  1. Day 1: take practice test 1 in exam mode to get a baseline.
  2. Days 2 to 5: domain mode on Prepare and serve data and Implement and manage semantic models, the two most heavily weighted domains.
  3. Day 6: practice test 2 in exam mode, then the mistakes quiz.
  4. Days 7 to 12: practice tests 3 to 5, one every other day, each followed by its mistakes quiz.
  5. Days 13 and 14: final mode. Book the exam when your readiness stays above the pass mark.

Four weeks

  1. Week 1: one practice test in practice mode, reading every explanation. Note your two lowest domains.
  2. Week 2: domain mode on those two domains, then a second practice test in exam mode.
  3. Week 3: practice tests 3 and 4 in exam mode, with the mistakes and flagged quizzes after each.
  4. Week 4: practice test 5 and final mode until your readiness holds above the pass mark.

Questions about the DP-600 practice exams

Are these real DP-600 exam questions?
No. We write every question ourselves and map it to the published DP-600 exam objectives. We do not use leaked or recalled questions.
Do the time limit and pass mark match the official exam?
They match the settings of our practice tests. Exam providers change their format from time to time, so check the official exam page before you book.
Can I try it before I pay?
Yes. The free mini exam has 15 questions with full explanations and needs no account.
How long do I keep access?
A single-exam purchase gives you 12 months of access. All-Access includes this exam for as long as your subscription runs.
What happens after I finish a test?
You get a score, a pass or fail against the pass mark, a score per domain and every answer with its explanation.

Last updated November 2026. Written and reviewed by the DevOpsCode Lab team.

DevOpsCode Lab is not affiliated with Microsoft. DP-600 and related names are trademarks of their owners.

Related exams
Exam Vendor Level Questions Minutes Price
AB-100AB-100 Agentic AI Business Solutions Architect Microsoft Professional 250 100 $14.99
AB-730AI Business Professional AB-730 Microsoft Professional 250 100 $14.99
AZ-305Azure Solutions Architect AZ-305 Microsoft Professional 250 100 $14.99
SC-100Cybersecurity Architect SC-100 Microsoft Professional 250 120 $14.99
AZ-140Azure Virtual Desktop AZ-140 Microsoft Specialty 251 100 $14.99
DP-420Microsoft DP-420 Microsoft Specialty 250 100 $14.99