DP-700 practice test
Microsoft Fabric Data Engineer Associate
100 practice questions, spread across the exam's topics the same way Microsoft weights them, each with a full explanation and a link to the official documentation that proves the answer. Written by a Microsoft Certified Trainer who does this work for a living.
No card needed to start, and none to keep going: buying is not open yet.
What is inside
Every area the exam tests
Our questions are spread the same way Microsoft weights the exam, so your practice matches the real thing.
Implementing and managing
30 to 35%Spark, domain, OneLake and Airflow workspace settings, version control and database projects, deployment pipelines, access control at every level, masking, sensitivity labels, endorsement, audit logs and OneLake security.
34 questionsIngesting and transforming
30 to 35%Choosing between dataflows, pipelines and notebooks, schedules and event triggers, orchestration patterns, full and incremental loads, dimensional preparation, streaming loads, shortcuts and mirroring, and transformation in PySpark, SQL and KQL.
33 questionsMonitoring and optimising
30 to 35%Monitoring ingestion, transformation and refresh, alerts, resolving errors across pipelines, dataflows, notebooks, eventhouses, eventstreams, T-SQL and shortcuts, and optimising tables, pipelines, warehouses, streaming, Spark and queries.
33 questionsHow you will use it
Practise the way that suits you
- Learn as you go. Answer, read why straight away, then move on. No clock, no pressure.
- Or sit it timed. A clock, no answers until the end, and two minutes a question, so you learn to pace yourself.
- Score by topic. See which area let you down instead of one number out of a hundred.
- Go back over it. Read every question again afterwards, right and wrong, with the full explanation.
Is it for you
Who takes DP-700
Data engineers moving onto Fabric
It assumes you can already build pipelines and asks which Fabric tool fits which job.
People who own a lakehouse or warehouse in production
A third of the exam is monitoring, troubleshooting and optimising what already runs.
Analytics engineers broadening into engineering
It goes well past modelling into ingestion, streaming, security and operations.
Also worth doing
Other exams in the same area
See the questions before you pay
10 DP-700 questions with full explanations, so you can judge the quality yourself.
Start 10 free questions