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

DP-700 practice exam settings
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

DP-700 exam domains, weights and question counts
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.)

  1. A A storage event trigger on the second pipeline that reacts to Blob created events (correct answer)
  2. B A schedule configured on the nightly pipeline with a daily recurrence (correct answer)
  3. C A Spark Job Definition that runs continuously and lists the container contents
  4. D An Until activity that loops every minute and checks the container with Get Metadata
  5. E A Copy job scheduled every minute that copies any new files found in the container
Why: Fabric pipelines support schedules for time-based runs and event-based triggers (built on Real-Time hub and Activator) that fire on Azure Blob Storage events such as BlobCreated. An Until loop with Get Metadata and a continuously running Spark job are both custom polling that the team wants to avoid. A Copy job on a one-minute schedule is still time-based polling rather than reacting to the storage event.

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?

  1. A Row-level security roles defined in the Power BI semantic model that the reports build on top of the warehouse
  2. B A dynamic data masking rule on the Region column with the default() function
  3. C A view per region and a GRANT SELECT on each view to the matching regional security group
  4. D An inline table-valued predicate function bound to the table through CREATE SECURITY POLICY (correct answer)
Why: Row-level security in a Fabric warehouse uses an inline table-valued function as a filter predicate that is applied by a security policy, so every T-SQL query against the table is filtered. Masking only obscures values and does not remove rows. Per-region views leave the base table exposed and do not scale. Semantic model RLS applies only to queries through the semantic model, not to direct T-SQL access.

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

  1. A The masking rules are also applied when Spark notebooks read the table's Delta files
  2. B Masked values are stored encrypted with a separate key in OneLake
  3. C A user without UNMASK can still infer masked values by filtering on the column in a WHERE clause (correct answer)
  4. D Users with the Admin, Member or Contributor workspace role see the unmasked data (correct answer)
  5. E A user without UNMASK cannot reference a masked column in a WHERE clause
Why: Dynamic data masking only changes query results for users without elevated permissions; workspace Admins, Members and Contributors see real values, and filtering on a masked column still works, so values can be inferred. The stored data is not changed or separately encrypted, masking is enforced by the SQL engine rather than in Delta files read by Spark, and masked columns can be used in WHERE clauses.

What your score report looks like

Example attempt, DP-700 practice test 3

82%

Passed
Pass mark 70%

Score by exam domain
DomainWeightYour 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.

Domains and pass mark from our DP-700 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 Ingest and transform data and Implement and manage an analytics solution, 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-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.

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

DevOpsCode Lab is not affiliated with Microsoft. DP-700 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