MicrosoftDP-700Associate

Microsoft Certified: Fabric Data Engineer Associate

Independent, adaptive preparation aligned to the published DP-700 exam blueprint. Learn to explain and apply the technology, not just memorize enough to pass.

See plans from $29

How to pass DP-700 Free practice questions

Take the official exam through Microsoft or its authorized delivery partner. SkillsTech Certified does not administer the exam or issue the Microsoft credential.

Track at a glance

Exam code: DP-700
Version: 2026-07-21
Level: Associate
Blueprint domains: 3
Lessons: 10
Original practice questions: 118
Flashcards: 40
Last reviewed: 2026-07-14
Next scheduled review: 2026-10-14

Blueprint facts are re-verified against the official exam guide on the review schedule above.

Exam blueprint

Domains & weights

Every lesson and question is mapped to a domain and objective below, and every attempt records the exam version it was answered under.

Domain 1: Implement and manage an analytics solution

34% of exam

Published weight 30-35%. Configuring Microsoft Fabric workspace settings (Spark, domain, OneLake, Airflow), implementing lifecycle management (version control, database projects, deployment pipelines), configuring security and governance, and orchestrating processes.

Configure Microsoft Fabric workspace settings (Spark, domain, OneLake, Apache Airflow)
Implement lifecycle management (version control, database projects, deployment pipelines)
Configure security and governance (workspace/item/row/column access, masking, sensitivity labels, audit, OneLake security)
Orchestrate processes (Dataflow Gen2 vs pipeline vs notebook, schedules/triggers, orchestration patterns)

Domain 2: Ingest and transform data

33% of exam

Published weight 30-35%. Designing and implementing loading patterns (full/incremental, dimensional, streaming), ingesting and transforming batch data (Dataflows Gen2, notebooks, KQL, T-SQL, shortcuts, mirroring, PySpark), and ingesting and transforming streaming data (Eventstreams, Spark structured streaming, KQL, windowing).

Design and implement loading patterns (full/incremental loads, dimensional model, streaming)
Ingest and transform batch data (Dataflows Gen2, notebooks, KQL, T-SQL, OneLake shortcuts, mirroring, PySpark)
Ingest and transform streaming data (Eventstreams, Spark structured streaming, KQL, windowing functions)

Domain 3: Monitor and optimize an analytics solution

33% of exam

Published weight 30-35%. Monitoring Fabric items (ingestion, transformation, semantic model refresh, alerts), identifying and resolving errors across items, and optimizing performance (Lakehouse tables, pipelines, warehouse, Eventstreams/Eventhouses, Spark, queries).

Monitor Fabric items (data ingestion, transformation, semantic model refresh, alerts)
Identify and resolve errors (pipeline, Dataflow Gen2, notebook, Eventhouse, Eventstream, T-SQL, OneLake shortcut)
Optimize performance (Lakehouse table, pipeline, data warehouse, Eventstreams/Eventhouses, Spark, query)

Source & provenance

Study Guide for Exam DP-700: Implementing Data Engineering Solutions Using Microsoft Fabric: official source (retrieved 2026-07-14)
Microsoft Certified: Fabric Data Engineer Associate: official source (retrieved 2026-07-14)

SkillsTech Certified is an independent certification-training and exam-preparation platform. Certification exams and official credentials are administered and issued by their respective providers. SkillsTech Certified is not affiliated with, endorsed by, or sponsored by AWS, Microsoft, Google, or any certification provider. Product names, certification names, and trademarks belong to their respective owners.