Skip to content
Cheat sheets
Associate · DP-700Prep available

Microsoft Certified: Fabric Data Engineer Associate (DP-700) practice exam and study path

A free, timed 60-question DP-700 practice exam in 100 minutes, scored by domain, with every option explained after you submit. Also 100 practice questions you can check one at a time, a page for every task in the exam guide, and a study path. No sign-up.

Start the free practice examGet the exam packPractice question by question →
Fabric Data Engineer Associate exam pack:

$6.99for 12 months

For data engineers who build on Microsoft Fabric: workspace settings, Git and deployment pipelines, security and orchestration, batch and streaming ingestion with lakehouses, warehouses, eventhouses and eventstreams, and monitoring, troubleshooting and tuning them.

The exam

Exam code
DP-700
Questions
Not yet published
Time
100 minutes
Passing score
700 of 1,000 (scaled)
Exam fee
$165 (USD)
Question types
multiple choice, multiple response

Exam DP-700 is a proctored role-based exam: 100 minutes, offered in ten languages through Pearson VUE, it may include interactive components, and 700 passes. Microsoft doesn't publish the number of questions (most of its exams have 40 to 60). The fee is set by the country or region (USD 165 in the United States, the price of Microsoft's DP role-based exams), and the certification renews every year with a free online assessment. Our questions follow the skills measured as of October 19, 2026. Our forms use 60 questions split 20 / 20 / 20, the midpoints of the guide's ranges.

From Microsoft's certification page and exam guide, checked Oct 28, 2026.

Domains and weights

  • Domain 1: Implement and manage an analytics solution

    33%

  • Domain 2: Ingest and transform data

    33%

  • Domain 3: Monitor and optimize an analytics solution

    34%

On our roadmap this comes after Azure Fundamentals. See every certification.

Practice

100 original practice questions, every option explained with the Microsoft documentation page that proves it. Free, no sign-up; progress stays on this device.

Your results on this device →

More practice exams

The lessons, the sample questions on every task page and the first full practice exam are free and stay free. A pack adds the further timed DP-700 practice exams.

Fabric Data Engineer Associate exam pack

$6.99for 12 months

  • Every paid DP-700 practice exam, timed, with every option explained
  • The next version of this exam included when it changes within your 12 months
  • 12 months of access. One payment, nothing renews by itself.
  • 14-day refund, no conditions
  • 14-day refund, no conditions: ask within 14 days of buying and you get the whole payment back.
  • No pass guarantee. These are practice exams written by us from the exam guide and the Microsoft documentation; a score here does not predict your result on the real exam.

Study path

One module per exam domain. Lessons that already exist on BytePatterns are linked; the rest are being written.

  1. Module 1: Implement and manage an analytics solution

    1. 1Spark settings: starter, custom and live pools, environments and job admissionTask 1.1

      Lesson coming

    2. 2High concurrency sessions for notebooks and pipelinesTask 1.1

      Lesson coming

    3. 3Domains, OneLake workspace settings and Apache Airflow runtime settingsTask 1.1

      Lesson coming

    4. 4Git integration, branch workspaces and conflictsTask 1.2

      Lesson coming

    5. 5SQL database projects and source controlTask 1.2

      Lesson coming

    6. 6Deployment pipelines, deployment rules and variable librariesTask 1.2

      Lesson coming

    7. 7Workspace roles, item permissions and sharingTask 1.3

      Lesson coming

    8. 8Row-, column- and object-level security and dynamic data maskingTask 1.3

      Lesson coming

    9. 9OneLake security roles and shortcut securityTask 1.3

      Lesson coming

    10. 10Sensitivity labels, endorsement and Fabric audit logsTask 1.3

      Lesson coming

    11. 11Dataflow Gen2, pipeline or notebookTask 1.4

      Lesson coming

    12. 12Schedules and event-based triggersTask 1.4

      Partly covered by: SQS vs SNS vs EventBridge

    13. 13Parameters, dynamic expressions and NotebookUtils orchestrationTask 1.4

      Lesson coming

  2. Module 2: Ingest and transform data

    1. 14Full and incremental loads with watermarks and change dataTask 2.1

      Lesson coming

    2. 15Preparing dimensions and facts: keys and slowly changing dimensionsTask 2.1

      Lesson coming

    3. 16Loading patterns for streaming data: duplicates, late events and watermarksTask 2.1, 2.3

      Partly covered by: Design Ad Click Aggregation

    4. 17Choosing a lakehouse, warehouse, eventhouse or SQL databaseTask 2.2

      Lesson coming

    5. 18Shortcuts, mirroring, pipelines and Copy jobTask 2.2

      Partly covered by: Moving Data Into AWS

    6. 19Group, aggregate and denormalize with T-SQL, Spark SQL and KQLTask 2.2

      Partly covered by: Aggregations & GROUP BY, INNER and OUTER JOINs

    7. 20Deduplicate and rank rows with window functionsTask 2.2

      Partly covered by: Window Functions

    8. 21Choosing a streaming engine, native tables or shortcuts, and query accelerationTask 2.3

      Lesson coming

    9. 22Eventstream sources, operators and destinationsTask 2.3

      Lesson coming

    10. 23Spark structured streaming and KQL update policies and materialized viewsTask 2.3

      Lesson coming

    11. 24Windowing functions in Eventstream and KQLTask 2.3

      Partly covered by: Design Ad Click Aggregation

  3. Module 3: Monitor and optimize an analytics solution

    1. 25Monitoring ingestion, transformation and semantic model refreshTask 3.1

      Partly covered by: Observability Basics

    2. 26Alerts with Activator and Real-Time hubTask 3.1

      Partly covered by: CloudWatch, Alarms & X-Ray

    3. 27Pipeline errors, retries and failure pathsTask 3.2

      Partly covered by: Design a Job Scheduler

    4. 28Dataflow Gen2, notebook and T-SQL errorsTask 3.2

      Lesson coming

    5. 29Eventhouse, Eventstream and OneLake shortcut errorsTask 3.2

      Lesson coming

    6. 30Lakehouse tables: V-Order, OPTIMIZE, VACUUM and partitioningTask 3.3

      Lesson coming

    7. 31Pipeline and warehouse performanceTask 3.3

      Lesson coming

    8. 32Eventstream and Eventhouse performanceTask 3.3

      Partly covered by: S3: Consistency, Classes, Lifecycle

    9. 33Spark and query performanceTask 3.3

      Lesson coming

Every task in the exam guide

The exam guide splits each domain into task statements. Each one has a page with a short summary, the lessons that teach it and open sample questions.

Domain 1: Implement and manage an analytics solution

Domain 2: Ingest and transform data

Domain 3: Monitor and optimize an analytics solution

How these questions are made

  • Written by us from the exam guide's task statements and the Microsoft documentation — never from real exam content.
  • Every option carries its own explanation and a link to the Microsoft page that proves it.
  • A question enters a timed exam only after an independent check; until then it is a practice question.
  • Results are a plain percentage, per domain too — not an imitation of Microsoft's scaled score.

Questions about the DP-700 practice exam

Is the DP-700 practice exam free?
Yes. The full practice exam (60 questions, 100 minutes) is free with no sign-up, and so are the 100 practice questions, the task pages and the study path. Your attempts are saved in this browser, on this device.
How many questions does it have, and is it timed?
60 questions in 100 minutes: the real DP-700 pace, scaled to this form. When the time runs out, the exam is submitted as it stands.
Are the answers explained?
After you submit, not during: like the real exam, the timed exam gives no feedback until the end. Then you get your score overall and per exam domain, and every question with each option explained and a link to the Microsoft documentation page behind it. In practice mode an answer is explained as soon as you check it.
What does the Fabric Data Engineer Associate exam pack add?
3 more timed practice exams (Practice exam 1: 60 questions, 100 minutes; Practice exam 2: 60 questions, 100 minutes; Practice exam 3: 60 questions, 100 minutes), each scored and explained the same way, and the next version of this exam if it changes within your 12 months. 12 months of access. One payment, nothing renews by itself. Everything above stays free. See the pack.
Can I get a refund?
Yes, with no conditions: ask within 14 days of buying and you get the whole payment back. The details are in the terms.
Is this an official Microsoft practice exam?
No. BytePatterns is not affiliated with, endorsed or sponsored by Microsoft. Every question is written by us from the public exam guide and the Microsoft documentation, never from real exam content, and a score here does not predict your result on the real exam. Microsoft lists its own preparation resources on its certification page.