- 🎯 Goal: Earn the Microsoft Certified: Fabric Data Engineer Associate badge
- 📅 Notes Version: 2026 — refreshed October 2026 (skills measured as of Oct 19, 2026)
- 🌐 Published site: 📘 DP-700 Study Notes
- 🆕 New version: DP-700 Study Notes v2
- ✍️ Author: Marco Grimaldi
- 🔗 Related repos: 📘 AZ-305 Study Notes
| Detail | Info |
|---|---|
| 🏅 Certification | Microsoft Certified: Fabric Data Engineer Associate |
| 📝 Passing Score | 700 / 1000 |
| 💶 Exam Price | ~€126 EUR (varies by country; VAT may apply) |
| ⏱️ Duration | 100 minutes (120 min seat time incl. check-in) |
| ❓ Question Types | MCQ, multi-select, drag-and-drop, case studies |
| 🔁 Renewal | Annual via free online assessment on Microsoft Learn |
| 🛡️ Prerequisite | None (recommended: hands-on Fabric experience) |
⚠️ Official ranges from the Microsoft study guide (skills measured as of October 19, 2026)
pie title Exam Domain Weights of the DP-700 (official ranges)
"Implement & Manage an Analytics Solution (30–35%)" : 33
"Ingest & Transform Data (30–35%)" : 33
"Monitor & Optimize an Analytics Solution (30–35%)" : 34
| # | Domain | Official Weight | Key Services |
|---|---|---|---|
| 1 | Implement & Manage an Analytics Solution | 30–35% | Workspaces, deployment pipelines, security, governance, orchestration |
| 2 | Ingest & Transform Data | 30–35% | Lakehouses, warehouses, Dataflow Gen2, notebooks, Eventstreams, KQL |
| 3 | Monitor & Optimize an Analytics Solution | 30–35% | Monitoring Hub, Spark optimization, query tuning, error resolution |
🔑 All three domains are equally weighted — balanced study across all areas is critical.
flowchart LR
DP900["☁️ DP-900\nAzure Data\nFundamentals\n(Recommended)"]
DP700["🏗️ DP-700\nImplementing Data\nEngineering Solutions\nUsing Microsoft Fabric\n(This Exam)"]
BADGE["🏅 Fabric Data\nEngineer Associate"]
DP900 -->|Foundation| DP700
DP700 --> BADGE
dp-700-study-notes/
├── README.md ← 📍 You are here
├── 00-fabric-prerequisites.md ← Microsoft Fabric fundamentals
├── 01-implement-manage-analytics-solution.md ← Domain 1 (30–35%)
├── 02-ingest-transform-data.md ← Domain 2 (30–35%)
├── 03-monitor-optimize-analytics-solution.md ← Domain 3 (30–35%)
└── 04-quick-reference-cheatsheet.md ← Last-minute review & exam traps
| Resource | Link |
|---|---|
| 📚 Microsoft's DP-700 Certification Learning Paths | Certification Learning Paths |
| 📄 Official Exam Page | DP-700 Exam |
| 📋 Skills Measured / Study Guide | Official Study Guide |
| 🧪 Free Practice Assessment | Practice Assessment |
| 🎬 Exam Readiness Videos | Exam Readiness Zone |
| 📚 Microsoft Fabric Documentation | Fabric Docs |
| 🎓 Instructor-Led Course | DP-700T00-A (4 days) |
| 💶 EU Exam Pricing | Pearson VUE Microsoft |
- 🎯 The exam tests "which Fabric component?" not just "what does it do?" — think in trade-offs and constraints
- 🔄 Know Dataflow Gen2 vs Notebook vs Pipeline boundaries — the exam tests which tool fits which scenario
- 🔒 Study security layers deeply — workspace, item, row, column, object, and folder-level access controls
- 📊 Streaming vs batch decision trees appear frequently — know Eventstreams, Spark Structured Streaming, and KQL
- 🧊 Know Lakehouse vs Warehouse differences — Delta Lake, T-SQL, and when to use each
- ⚡ Anchor every answer to the data engineering best practices — incremental loads, partitioning, V-Order
- 📖 For case studies: read business requirements and constraints first, then eliminate answers
| File | Topics Covered |
|---|---|
| 📘 00 — Fabric Prerequisites | OneLake, workspaces, lakehouses, warehouses, capacities, Delta Lake |
| ⚙️ 01 — Implement & Manage | Spark / OneLake / Apache Airflow settings, deployment pipelines, variable libraries, OneLake security, orchestration |
| 🔄 02 — Ingest & Transform | Loading patterns, Copy job, mirroring, shortcuts, PySpark, SQL, KQL, materialized lake views, Eventstream |
| 📈 03 — Monitor & Optimize | Monitoring hub & workspace monitoring, error resolution, V-Order / resource profiles, Spark & warehouse tuning |
| ⚡ 04 — Quick Reference Cheatsheet | Key numbers, decision tables, exam traps, final checklist |
October 2026 refresh — aligned with the study guide effective October 19, 2026 and current Microsoft Fabric docs:
- Syllabus: Configure Dataflow Gen2 workspace settings → Configure Apache Airflow workspace settings (starter vs custom pools); Eventstream/Eventhouse wording updated
- Corrected: V-Order is now off by default (
writeHeavyresource profile); Spark vCores per SKU (1 CU = 2 vCores, 3× burst); idle Spark pools aren't billed; SQL analytics endpoint supports views/functions/procs; Eventstream destinations (no Warehouse); Fabric trigger types; audit log retention (180 days); Fabric Warehouse has no materialized views; OneLake workspace vs tenant settings;mssparkutils→notebookutils - Updated lists: shortcut sources, mirroring sources and types, Git providers and items, exam languages, practice assessment link
- Added: resource profiles, custom live pools, variable libraries, OneLake security roles (RLS/CLS/OLS), Copy job, materialized lake views, Dataflow Gen2 performance features, Eventstream SQL operator, workspace monitoring, warehouse data clustering
These notes are hosted on GitHub Pages and published as a searchable website on this URL:
The site includes full-text search, Mermaid diagram rendering, and mobile-friendly navigation for on-the-go review.
These notes are designed to be a structured, exam-focused summary of the most important concepts and services based on the official Microsoft DP-700 Study Guide and its criteria.
Maintained by Marco Grimaldi — Cloud Consultant, Language Trainer & Lifelong Learner.
Find more certification guides, study tips, and tech content at 🏠 marcogrimaldi29.com
The site is continuously updated and based on my personal study notes and experiences. If you have any feedback, suggestions, or corrections, feel free to reach out!
Microsoft Fabric ships changes almost weekly, so if something here is wrong or out of date, please report an issue.
If these notes helped you on your DP-700 journey, there are a couple of ways to show it: ⭐ star this repo on GitHub so other candidates can find it, or 🤝 connect with me on LinkedIn.
This site uses Umami for privacy-friendly analytics.
The Just the Docs theme is used for a clean, documentation-style layout. Licensed under MIT.
Created with the help of AI. Model used: Claude Opus 4.6; October 2026 refresh: Claude Opus 5.5. The content has been reviewed and edited by the author for accuracy and clarity, but may contain errors. Always verify against the latest Microsoft documentation.
Not affiliated with or endorsed by Microsoft.