Download free
iPhone & iPad · Free to startOn your Mac? Scan to install
DP-700Microsoft Fabric Data Engineer
DP-700 · 30 days left ›
PREDICTED786 ±37✓ Exam Ready · 87% confidence
Inside the app
Nine interactive practice formats, on iPhone
Azure Mastery has nine interactive formats for exam practice. The examples below show original DP-700 practice questions in Azure Mastery on iPhone and iPad. The exam simulator uses timed sessions with the published domain weights. Microsoft's live interface and question mix may differ.
A new analyst must be able to open every notebook, pipeline, and lakehouse in a workspace and read the data, but must not be allowed to edit any item or write data. Which single workspace role grants exactly this access?
AdminThis role can manage permissions, add other admins, and delete the workspace, making it the most privileged option and inappropriate for a read-only analyst.
ContributorThis role adds write and modify rights, letting the user edit notebooks, run pipelines, and change lakehouse data, which exceeds read-only access.
MemberThis role includes everything a contributor can do plus sharing items and adding people at lower roles, far more than read-only access requires.
ViewerCorrect — this role grants view and read access to all items and data in the workspace while blocking any create, modify, write, or delete operation.
Multiple choice
An original DP-700 practice question with one correct answer. Choose an option to read its written rationale.
Exam-specific sampleExplore more question formats
Which two Copy activity settings directly control the compute and parallelism available to a single Fabric pipeline copy run? (Select two.)
Intelligent throughput optimizationCorrect — this setting controls the serverless throughput resources available to the Copy activity, from automatic selection through higher resource levels.
Degree of copy parallelismCorrect — this setting caps the number of parallel threads reading from the source or writing to the destination during one copy run.
Activity retry countRetries repeat a failed activity for resilience and do not increase the throughput of a successful copy attempt.
Data consistency verificationConsistency verification checks file or row-count integrity and can reduce performance; it is not a throughput-allocation control.
Secure output loggingSecure output logging limits exposure of activity details and has no role in allocating copy compute or parallel threads.
Multi-select
An original DP-700 multi-select question. Select all the correct options to earn the mark.
All-or-nothing
Match each Fabric error symptom to the most likely root cause.
⋮⋮1Each symptom maps to a distinct, well-documented cause.
⋮⋮2CREATE USER is on the explicit list of unsupported T-SQL statements in…
⋮⋮3A newly created Delta table that is missing from the SQL analytics…
⋮⋮4A Tables-section shortcut whose Delta folder name contains a space is…
Drag to match
An original DP-700 ordering question you can answer by touch on iPhone and iPad.
Interactive item
Match each Microsoft Fabric organizational or capacity concept to the description that best defines it.
Drag to match
An original DP-700 question with a visual prompt, designed for touch on iPhone and iPad.
Match concepts
Northwind Retail incremental lakehouse ingestion Northwind Retail runs a Microsoft Fabric analytics platform on a single F64 capacity. The data engineering team is building a medallion lakehouse named RetailLH that…
1For the POS sales table, which pipeline design ingests only new and changed rows…
2The customer master source has inserts, updates, and physical deletes, and…
3In a Silver notebook, which processing pattern correctly prepares DimCustomer as…
4The loyalty Parquet dataset already lives in an ADLS Gen2 account, rarely…
Case studies
An original DP-700 case study with several questions about the same requirements and environment.
Multi-question
✕Your answer: Admin
✨ Answer Coach:This role can manage permissions, add other admins, and delete the workspace, making it the most privileged option and inappropriate for a read-only analyst.
— grounded in authored certification guidance
Answer Coach
Answer Coach explains why the answer is correct and, where available, why each option is right or wrong. It helps you understand a mistake and remember the distinction. Read explanations after each question or at the end of a practice test. On supported devices, optional AI can reword a note on your device after checking it against the written guidance.
App exclusive
DP-700 Practice Questions & Exam Prep — Microsoft Fabric Data Engineer
Get exam-ready for DP-700 (Implementing Data Engineering Solutions Using Microsoft Fabric) on iPhone or iPad. Azure Mastery uses on-device AI to predict your readiness score, build a personalised study plan, and surface topics you're forgetting. Core study stays on-device and works offline; optional sync uses your private iCloud account.
The exam
What is the DP-700 exam?
DP-700 — Implementing Data Engineering Solutions Using Microsoft Fabric — earns the Microsoft Certified: Fabric Data Engineer Associate credential. It's a role-based, hands-on exam for working data engineers who ingest and transform data and build analytics solutions on Microsoft Fabric.
The audience profile assumes you're already fluent in at least one of SQL, PySpark, or KQL and comfortable with data loading patterns, data architectures, and orchestration. You'll work alongside analytics engineers, architects, analysts, and administrators to design and deploy data engineering solutions.
This is not a vocabulary exam. DP-700 expects you to reason about real engineering decisions, covering:
Full vs incremental load patterns
Choosing between Dataflow Gen2, pipelines, and notebooks
Transforming data with PySpark, T-SQL, and KQL
Wiring up OneLake shortcuts and database mirroring
Processing streams with Eventstream and Spark Structured Streaming
Securing data with row-, column-, and object-level security and OneLake security
Optimising Lakehouse, Warehouse, pipeline, and Spark performance
Microsoft refreshed the DP-700 skills outline on 21 July 2026. Every question in Azure Mastery's DP-700 bank is mapped to the current outline — no leftover questions on retired features. Read the official outline at learn.microsoft.com.
Questions40–60 (mixed formats)
Duration~100 minutes
Pass score700 / 1000
CostUSD $165 (≈ £113 UK)
ValidityRenew yearly (Associate)
FormatOnline or test centre
Skills measured · 21 July 2026
DP-700 exam objectives
Three domains, each weighted 30–35% as of 21 July 2026 on the official skills outline — there's no "easy" domain to coast on. Every domain below lists Microsoft's own skill groups verbatim, so you always know which domain you're being tested on and where your weak spots cluster.
Data skill mapSourcesTransformStoreAnalyse
Implement and manage an analytics solutionPublished weight 30–35%
108 exam-scoped practice questions in the app
Explore Implement & Manage topics
Configure Microsoft Fabric workspace settings
Implement lifecycle management in Fabric
Configure security and governance
Orchestrate processes
Tests configuring the right Fabric workspace, security, and Git-lifecycle settings for a stated governance need.
Candidates apply row- or column-level security when the scenario actually wants dynamic data masking instead.
Match the orchestration tool, Dataflow Gen2, a pipeline, or a notebook, to the trigger type the scenario names.
Ingest and transform dataPublished weight 30–35%
114 exam-scoped practice questions in the app
Explore Ingest & Transform topics
Design and implement loading patterns
Ingest and transform batch data
Ingest and transform streaming data
Picking a load pattern and a transform tool that fit the stated data volume and refresh window is the core skill here.
A full load often gets reached for by habit when the scenario's volume and refresh window call for incremental.
Match Dataflow Gen2, a notebook, T-SQL, or KQL to the skillset and store the scenario names, not the flashiest option.
Monitor and optimize an analytics solutionPublished weight 30–35%
118 exam-scoped practice questions in the app
Explore Monitor & Optimize topics
Monitor Fabric items
Identify and resolve errors
Optimize performance
Tracing a failure to the specific Fabric item, pipeline, notebook, or shortcut named in the scenario is what's actually graded.
This domain gets under-revised relative to its weight, since its breadth outpaces how often it feels tested.
Learn the Lakehouse tuning levers by name: V-Order, OPTIMIZE, VACUUM, and partitioning each fix a different symptom.
Common traps
Where DP-700 candidates slip
Five recurring misconceptions that trip up otherwise well-prepared DP-700 candidates, grounded in the current skills outline.
Lakehouse, Warehouse, and Eventhouse are built for different workloads, not ranked by preference.
Files-and-Spark, relational T-SQL, and streaming telemetry each point to one specific store, never a matter of preference.
Read the scenario for its workload shape first, then pick the Fabric item built to hold that shape.
A shortcut, mirroring, and a Copy activity move data in three different ways.
A requirement for "no duplicated storage" points at a shortcut or mirroring, never at a Copy activity.
Check whether the requirement forbids a physical copy before you reach for a pipeline Copy activity.
Dataflow Gen2, a notebook, a pipeline, T-SQL, and KQL each own a different kind of job.
The tool that matches the stated skillset and store wins here, whatever else looks more powerful.
Name the store and the skill level in the scenario before choosing between low-code and code-first tools.
A full load and an incremental load answer different volume and refresh constraints.
Large volume or a tight refresh window in the scenario is what should point you at incremental loading.
Look for a stated watermark or change-tracking need before assuming a full reload is good enough.
RLS, CLS, OLS, and dynamic data masking each protect a different slice of the data.
A requirement to hide values while leaving the row visible names masking specifically, not CLS or OLS.
Match the protection to what must disappear: rows, columns, the whole object, or just the displayed value.
Designed for DP-700
How Azure Mastery helps you pass DP-700
Exam-specific practice
340 DP-700 practice questions, each written against the current 21 July 2026 skills outline.
Every question is tagged to one of DP-700's three official domains.
Practise reading PySpark, T-SQL, and KQL snippets, the exam's actual scenario style.
Predicted score
Exam IQ forecasts your DP-700 score on-device after roughly 30 questions, with a confidence range attached.
It names the specific Fabric tool choice or KQL pattern dragging your score down.
It flags which of the three domains needs the most attention before you book.
Adaptive study plan
All three DP-700 domains weigh almost equally at 30–35%, so the plan won't let you over-invest in the one you know.
Miss a Dataflow Gen2 vs pipeline vs notebook question and the next session surfaces that choice again.
Nail incremental-load patterns three sessions running and the plan backs off it automatically.
Knowledge decay
The KQL windowing syntax or deployment-pipeline workflow you mastered weeks ago fades fastest if you stop revising.
Watch for the padlock icon; it marks a topic that's about to slip.
Run Focus Weak Spots and decayed topics surface before anything else.
Exam rehearsal
Run a full 100-minute session with the same one-way flag-and-review rule as the real thing.
The session draws only original questions, weighted to match the published domain split.
The live DP-700 interface and question mix are Microsoft's to control, not ours.
Answer Coach
Untangles DP-700's storage-and-tool calls: Lakehouse vs Warehouse, a Copy activity vs a OneLake shortcut.
Every explanation names the exact reason the wrong option looked plausible.
Capable devices can reword a note on-device, but the written guidance is checked first every time.
Aura guidance
Aura adjusts what it suggests as your first week of DP-700 sessions goes on.
A short recap closes every session: what changed, what to revisit, what's next.
Private by design
Your DP-700 answer history, readiness gauge, and Answer Coach notes stay private by default.
No account, no external server, nothing leaves the device unless you turn sync on.
Optional sync uses your private iCloud account.
4–8 week revision plan
Suggested DP-700 study plan
Allow four to eight weeks, with extra time for SQL, PySpark or KQL if needed. Work through these flexible phases and pair each with hands-on Microsoft Fabric practice.
Refresh your languages
Review the SQL, PySpark or KQL you will use.
Practise reading short code examples.
Revisit unfamiliar syntax before starting the main phases.
Build and manage Fabric
Configure workspaces, Spark, domains, OneLake and Airflow.
Review Git, database projects and deployment pipelines.
Create a workspace and deployment pipeline for practice.
Security and orchestration
Review workspace, item and granular data access controls.
Explore labels, masking, audit logs and OneLake security.
Compare Dataflow Gen2, pipelines and notebooks; plan scheduled or event triggers.
Ingest and transform
Compare full and incremental loads, shortcuts and mirroring.
Transform batch data with Dataflows, notebooks, PySpark, T-SQL or KQL.
Explore Eventstream, Spark Structured Streaming and KQL windowing.
Monitor and optimise
Monitor items and configure alerts.
Troubleshoot pipelines, Dataflows, notebooks and T-SQL.
Optimise Lakehouse, Warehouse, Spark and query performance.
Rehearse and consolidate
Use Focus Weak Spots to revisit weaker topics.
Complete a timed simulator session of about 100 minutes.
Review mistakes and decide whether you need more practice.
Frequently asked
DP-700 FAQs
DP-700 vs DP-600 — which should I take?
Both are Fabric associate certifications, and your role decides. DP-600 (Analytics Engineer) leans toward semantic models, Power BI, and DAX. DP-700 (Data Engineer) leans toward ingestion and transformation — pipelines, Dataflows Gen2, notebooks, PySpark, Eventstream, and KQL. Build the pipelines, take DP-700; model and serve the data, take DP-600.
OneLake shortcut or mirroring — how does DP-700 test the choice?
A shortcut references data in place — no copy, no ongoing compute cost — for reading data another workspace already owns. Mirroring actually replicates the source into Fabric's Delta format, near-real time, for when engines need to query it directly. DP-700 names the access pattern, not the mechanism, so inferring it is the real skill.
What question formats appear on DP-700?
Microsoft's own guidance states 40–60 questions with formats that vary by sitting. Azure Mastery's bank runs a similar mix: mostly single-answer multiple choice, a meaningful mix of scenario-based and multi-select questions, and a smaller set of yes/no, dropdown, hotspot, drag-to-match, and ordering items, plus a handful of case studies.
What's the DP-700 voucher price?
The DP-700 voucher is USD $165 in the United States — associate-level pricing. Cost varies by region; in the UK it's typically around £113. Microsoft sometimes runs free-voucher promotions for events such as Microsoft Build or Microsoft Ignite, so check your Learn profile before booking.
Once earned, does DP-700 need renewing?
Yes. DP-700 earns the Fabric Data Engineer Associate credential, and like all Microsoft associate certifications it needs renewing every year. Renewal is free: a short online assessment on Microsoft Learn, available in the six months before expiry. Fundamentals certs such as DP-900 never expire.
Dataflow Gen2 or a Data pipeline — which does DP-700 expect for a given ingestion task?
Dataflow Gen2 is the low-code, Power Query choice for transformation-heavy loads. A Data pipeline is the orchestration choice for scheduling and chaining activities across sources. DP-700 scenarios describe the requirement, transform-in-place or orchestrate-and-schedule, rather than naming the tool, so spotting which one it implies is the real skill.
Is DP-700 a technical, hands-on exam?
Yes. DP-700 expects real data-engineering work in Fabric: writing T-SQL, PySpark, and KQL; designing load patterns; working with Delta tables, shortcuts, mirroring, and pipelines; and optimising Lakehouse and Spark performance. It's a working engineer's exam, not a conceptual overview. Try DP-900 first for a vocabulary-level on-ramp.
I failed DP-700 — how long until I can retake it?
Each retake needs a fresh voucher, and the wait grows with every attempt.
First retake: after 24 hours.
Second and third retakes: a 14-day wait each.
Cap: five attempts per rolling 12 months.
Can I try Azure Mastery's DP-700 bank before paying?
Yes — the app is free to download, with 50+ free DP-700 questions and written explanations. The full bank of 340 DP-700 practice questions unlocks with a one-time exam-pack purchase, or unlock every exam with a subscription or lifetime upgrade. Advanced study tools require Pro.
Does DP-700 practice hold up without a connection?
Yes. The app doesn't need a connection for question practice, scoring, or the readiness prediction — all of that runs on-device. No account is required, and your data stays on your device unless you switch on optional iCloud sync.
Free study guides
Free guides that pair with DP-700
Where DP-700 fits
Certification paths that lead to DP-700
DP-700 is the associate-level destination of Microsoft's Fabric data-engineering track. There's no formal prerequisite, but DP-900 (Azure Data Fundamentals) is a natural on-ramp if the data vocabulary is new, and many engineers pair DP-700 with DP-600 to cover both data engineering and analytics on Fabric.
Fabric Data Engineer path
Associate tier
DP-900Fundamentals on-ramp
DP-700Fabric Data Engineer Associate
Full Fabric path
Associate tier
DP-700Fabric Data Engineer
DP-600Fabric Analytics Engineer
From classic data engineering
Associate tier
DP-203Azure Data Engineer (retired)
DP-700Fabric Data Engineer Associate
Around DP-700
Related certifications
DP-700 is the data-engineering associate on Microsoft Fabric. Its closest neighbour is DP-600 (Fabric Analytics Engineer); below are the related exams already covered in Azure Mastery — a fundamentals on-ramp and the Power BI analyst path that sits alongside Fabric.
Ready to pass DP-700?
Download Azure Mastery free. 340 DP-700 practice questions, AI score prediction, and a personalised study plan that adapts to your weak spots. iPhone & iPad.
Azure Mastery
Exam DP-700
Download
