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
| 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
| 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?
- A An on-premises data gateway in standard mode installed on a server that can reach the SQL Server instance (correct answer)
- 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
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 (correct answer)
- D Upgrade the capacity to F64 permanently so that the extra capacity units absorb both the overnight jobs and the morning interactive load
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 (correct answer)
See all 10 free DP-600 questions with answers Read them or quiz yourself.
What your score report looks like
Example attempt, DP-600 practice test 3
76%
Passed
Pass mark 70%
| Domain | Weight | Your 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.
Study plans
Two weeks
- Day 1: take practice test 1 in exam mode to get a baseline.
- Days 2 to 5: domain mode on Prepare and serve data and Implement and manage semantic models, the two most heavily weighted domains.
- Day 6: practice test 2 in exam mode, then the mistakes quiz.
- Days 7 to 12: practice tests 3 to 5, one every other day, each followed by its mistakes quiz.
- Days 13 and 14: final mode. Book the exam when your readiness stays above the pass mark.
Four weeks
- Week 1: one practice test in practice mode, reading every explanation. Note your two lowest domains.
- Week 2: domain mode on those two domains, then a second practice test in exam mode.
- Week 3: practice tests 3 and 4 in exam mode, with the mistakes and flagged quizzes after each.
- 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.
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 |