DP-700
Fabric Data Engineer DP-700 practice exams
241 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 3 exam domains.
Exam at a glance
| Practice tests | 5 |
|---|---|
| Questions in total | 241 |
| Questions per test | About 50 |
| Time limit per test | 100 minutes |
| Pass mark | 70% |
| Question types | Single answer and multiple answer (22 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 |
|---|---|---|---|
| Implement and manage an analytics solution | 33% | 80 | |
| Ingest and transform data | 34% | 81 | |
| Monitor and optimize an analytics solution | 33% | 80 |
Sample questions
Question 1 of 3, choose 2
A Fabric workspace must run a nightly pipeline at 01:00 UTC, and a second pipeline must start whenever a new file lands in a specific Azure Blob Storage container. The team wants to avoid custom polling code. Which combination should the data engineer use? (Choose two.)
- A A storage event trigger on the second pipeline that reacts to Blob created events (correct answer)
- B A schedule configured on the nightly pipeline with a daily recurrence (correct answer)
- C A Spark Job Definition that runs continuously and lists the container contents
- D An Until activity that loops every minute and checks the container with Get Metadata
- E A Copy job scheduled every minute that copies any new files found in the container
Question 2 of 3
A company has a Fabric warehouse with a SalesOrders table. Regional managers must see only the rows for their own region when they query the table with T-SQL. The solution must be enforced inside the warehouse for every query tool. What should the data engineer implement?
- A Row-level security roles defined in the Power BI semantic model that the reports build on top of the warehouse
- B A dynamic data masking rule on the Region column with the default() function
- C A view per region and a GRANT SELECT on each view to the matching regional security group
- D An inline table-valued predicate function bound to the table through CREATE SECURITY POLICY (correct answer)
Question 3 of 3, choose 2
A data engineer configures dynamic data masking on several columns of a Fabric warehouse table. Which statements about the behaviour are correct? (Choose two.)
- A The masking rules are also applied when Spark notebooks read the table's Delta files
- B Masked values are stored encrypted with a separate key in OneLake
- C A user without UNMASK can still infer masked values by filtering on the column in a WHERE clause (correct answer)
- D Users with the Admin, Member or Contributor workspace role see the unmasked data (correct answer)
- E A user without UNMASK cannot reference a masked column in a WHERE clause
See all 10 free DP-700 questions with answers Read them or quiz yourself.
What your score report looks like
Example attempt, DP-700 practice test 3
82%
Passed
Pass mark 70%
| Domain | Weight | Your score | % |
|---|---|---|---|
| Implement and manage an analytics solution | 33% | 88 | |
| Ingest and transform data | 34% | 81 | |
| Monitor and optimize an analytics solution | 33% | 76 |
Study next: Monitor and optimize an analytics solution. It is below the pass mark and carries 33% 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 Ingest and transform data and Implement and manage an analytics solution, 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-700 practice exams
- Are these real DP-700 exam questions?
- No. We write every question ourselves and map it to the published DP-700 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 |