DP-700 Microsoft · Data Engineer
Implementing Data Engineering Solutions Using Microsoft Fabric. Practice exam aligned to the DP-700 skills measured (October 2026): implementing and managing a Fabric analytics solution, ingesting and transforming batch and streaming data, and monitoring and optimizing Fabric items.
Take the free DP-700 diagnostic10 questions, no card needed
3 questions from the free diagnostic, with answers and explanations.
Which Fabric item runs a sequence of activities, such as a Copy data activity followed by a notebook, on a schedule and with dependencies between them?
Answer: A (A data pipeline)
Data pipelines orchestrate activities with dependencies, parameters and schedules.
Each run loads only the rows whose ModifiedDate is later than the highest value loaded by the previous run. What is this loading pattern called?
Answer: A (Incremental load using a watermark)
A high-watermark column lets each run pick up only new and changed rows, instead of reloading everything.
Refer to the code. What happens to an incoming row whose CustomerID already exists in silver.customers?
MERGE INTO silver.customers AS t
USING staging.customer_updates AS s
ON t.CustomerID = s.CustomerID
WHEN MATCHED THEN UPDATE SET *
WHEN NOT MATCHED THEN INSERT *Answer: A (The existing row is updated with the incoming values)
MERGE matches rows on the ON condition: matched rows are updated, and rows without a match are inserted (an upsert).
Share of practice questions per skill area.
Ingest, transform and orchestrate data at scale with Microsoft Fabric or Azure Databricks.
Yes. Create a free account and take the DP-700 free diagnostic: 10 questions across every skill area of the exam, with a study plan for the topics to work on. You can retake it as often as you like.
Each full practice test has 40 questions with a 90-minute timer, and you pass at 70%. There are 6 practice tests plus a harder challenge test, with 350 questions in total.
Single choice, multiple select, hotspot (drop-down and yes/no), drag-and-drop matching, drag-and-drop select and place, case studies and exhibits (screenshots, diagrams and code), the same formats you meet on the real exam.
No. They are original questions written for ExamKite and mapped to the Microsoft skills outline, never copied from the real exam. Using leaked exam questions breaks the certification provider's exam rules and can get your certification revoked.
More answers in the full FAQ.
Start with the free diagnostic and get a study plan for the topics you miss.