# Fabric Analytics Engineer DP-600 practice exams

> 5 timed DP-600 practice tests with 240 questions and a 70% pass mark. See your score in Prepare and serve data and Implement and every other domain.

Page: https://devopscodelab.com/exams/microsoft-dp-600/

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

| Setting | Value |
| --- | --- |
| 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 format before you book.

## Domains and weights

| Domain | Weight | 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 |

## Price and access

- DP-600 practice exams: $12.99 for 12 months of access.
- Free mini exam: 15 questions with explanations (free account): https://devopscodelab.com/app/exams/microsoft-dp-600/mini/
- All-Access subscription includes every exam: https://devopscodelab.com/pricing/
- 10 free questions with answers: https://devopscodelab.com/exams/microsoft-dp-600/free-practice-questions/

## 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?

- A. An on-premises data gateway in standard mode installed on a server that can reach the SQL Server instance
- B. An on-premises data gateway in personal mode installed on the workstation of the engineer who owns the dataflow
- C. No gateway, because Fabric reaches on-premises SQL Server directly through the OneLake shortcut connectors
- D. A virtual network (VNet) data gateway attached to a delegated subnet in the company's Azure virtual network

**Answer:** A

**Explanation:** 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?

- 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
- 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
- C. Reschedule the heavy background jobs so that they finish earlier and spread across the night, reducing the carry-forward of smoothed usage
- D. Upgrade the capacity to F64 permanently so that the extra capacity units absorb both the overnight jobs and the morning interactive load

**Answer:** C

**Explanation:** 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?

- A. Overwrite the dimension with the latest source extract and add an IsCurrent column that is set to true for every row
- B. Merge on the business key with whenMatchedUpdateAll so that every changed attribute overwrites the current row in place
- C. Merge on the surrogate key with whenNotMatchedInsertAll so that each changed customer receives an additional row
- D. Stage each changed row twice, once keyed to expire the current row and once with a null key so it is inserted

**Answer:** D

**Explanation:** 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.


## 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.

DevOpsCode Lab is not affiliated with Microsoft. DP-600 and related names are trademarks of their owners. We write every question ourselves; these are not real exam questions.
