🔒 Guided

Pre-launch preview. Authorised access only.

Incorrect code

Guided by A Guide to Cloud
Explore AB-900 AI-901
DP-700

Fabric Data Engineer
Associate

The Microsoft Fabric data engineering certification. Delta Lake, PySpark, Eventstreams, KQL, pipeline orchestration, and performance optimization — explained with real-world scenarios and code examples.

📖

Study Guide

26 interactive modules

4 modules (Delta Lake, Loading Patterns, Dimensional Modeling, Data Stores) + 16 practice questions. No account needed.

Start Free →
✍️

Practice Exam

200 exam-style questions

Study mode with explanations + timed exam simulation. 16 free questions.

Try Free Questions →

26

Modules

200

Questions

3

Domains

Free

Domain 2 included

📝 Sample Question

A PySpark notebook crashes halfway through writing 10 million rows to a Delta table. What happens to the table?

A. The table contains the first 5 million rows written before the crash
B. The table remains at its previous version — the partial write is not committed ✓
C. The table is corrupted and must be rebuilt

📊 What you'll cover

Implement and Manage an Analytics Solution 8 modules
Ingest and Transform Data (Free) 10 modules
Monitor and Optimize an Analytics Solution 8 modules

What you'll learn

🔺

Delta Lake Mastery

ACID transactions, time travel, MERGE, schema evolution — the storage layer that powers every Fabric lakehouse.

⚡

PySpark & KQL

Transform data at scale with PySpark notebooks. Query streaming data in seconds with KQL. Line-by-line code explanations.

🔄

Real-Time Intelligence

Eventstreams, Spark Structured Streaming, Eventhouses, and windowing functions — real-time analytics explained clearly.

🚀

Performance Tuning

OPTIMIZE, VACUUM, Z-ordering, broadcast joins, predicate pushdown — make your data platform fast.

Full Curriculum

26 interactive modules across 3 exam domains

1

Implement and Manage an Analytics Solution

8 modules

Premium

Configure Fabric workspaces, Spark environments, and OneLake settings. Implement Git integration, deployment pipelines, and CI/CD. Configure security at workspace, item, row, column, and file levels. Design orchestration with pipelines, triggers, and dynamic expressions.

  1. 1Workspace Settings
  2. 2Git & Version Control
  3. 3Deployment Pipelines
  4. 4Access Controls
  5. 5Data-Level Security
  6. 6Governance & Audit
  7. 7Orchestration Tools
  8. 8Pipeline Patterns
Preview Domain
2

Ingest and Transform Data

10 modules

Free

Master Delta Lake foundations, loading patterns, and dimensional modeling. Access external data with shortcuts and mirroring. Transform at scale with PySpark, SQL, and KQL. Ingest streaming data with Eventstreams and build real-time intelligence with KQL windowing.

  1. 1Delta Lake Foundations
  2. 2Loading Patterns
  3. 3Dimensional Modeling
  4. 4Data Stores & Tools
  5. 5OneLake Shortcuts
  6. 6Mirroring
  7. 7PySpark Transforms
  8. 8SQL & KQL Transforms
  9. 9Eventstreams & Streaming
  10. 10Real-Time Intelligence
Start Free →
3

Monitor and Optimize an Analytics Solution

8 modules

Premium

Monitor ingestion, transformation, and refresh with the Monitoring Hub. Troubleshoot pipeline, notebook, and streaming errors. Optimize Delta tables with OPTIMIZE, VACUUM, and Z-ordering. Tune Spark performance, warehouse queries, and real-time workloads.

  1. 1Monitoring & Alerts
  2. 2Troubleshoot Pipelines
  3. 3Troubleshoot Notebooks
  4. 4Troubleshoot Streaming
  5. 5Optimize Lakehouse
  6. 6Optimize Spark
  7. 7Optimize Pipelines & Warehouses
  8. 8Optimize Streaming
Preview Domain

Practice Exam Lab

200 original questions — two study modes

📖

Study Mode

Learn as you go

  • ✓ See explanation after each question
  • ✓ "Why wrong" for every option
  • ✓ Real-world context & exam tips
  • ✓ Microsoft Learn links
⏱️

Exam Mode

Simulate the real thing

  • ✓ 120 minutes timed session
  • ✓ Randomised question order
  • ✓ Score breakdown by domain
  • ✓ Pass/fail against 700 / 1000
1

Implement and Manage

65 questions · Exam weight: 30-35%

0 Free

20

Easy

29

Medium

16

Hard

Every question includes a scenario, detailed explanation, and a link to Microsoft Learn.

Preview Questions
2

Ingest and Transform

65 questions · Exam weight: 30-35%

16 Free

18

Easy

29

Medium

18

Hard

Every question includes a scenario, detailed explanation, and a link to Microsoft Learn.

Try Free Questions →
3

Monitor and Optimize

70 questions · Exam weight: 30-35%

0 Free

21

Easy

32

Medium

17

Hard

Every question includes a scenario, detailed explanation, and a link to Microsoft Learn.

Preview Questions

🎁 Free tier: 16 questions. No account needed.

Choose your path

Start free. Upgrade when you're ready.

Practice Exam

$14

one-time purchase

  • ✓ 200 exam-style questions
  • ✓ Study mode + Exam mode
  • ✓ Detailed explanations

Study Guide

$19

one-time purchase

  • ✓ 26 interactive modules
  • ✓ Flashcards & ELI5
  • ✓ Progress tracking
Recommended

Complete Bundle

$29

save $4

  • ✓ Everything in both
  • ★ Best value

🎁 Free tier: 4 modules (Delta Lake, Loading Patterns, Dimensional Modeling, Data Stores) + 16 practice questions. No account needed. No account needed.

About the DP-700 Exam

Exam code
DP-700
Duration
120 minutes
Passing score
700 / 1000
Question types
MCQ, multi-select, case studies
Cost
$165 USD

Exam Domains & Weights

D1: Implement and Manage (30-35%)
D2: Ingest and Transform (30-35%)
D3: Monitor and Optimize (30-35%)
View on Microsoft Learn →

Frequently Asked Questions

What is DP-700?
DP-700 is the Microsoft Certified: Fabric Data Engineer Associate exam — an intermediate certification for data engineers building solutions with Microsoft Fabric. It covers lakehouses, Delta Lake, PySpark, pipelines, Eventstreams, and performance optimization.
Do I need coding experience?
Yes — DP-700 is code-heavy. You should be comfortable with SQL and have basic Python knowledge. PySpark, Spark SQL, and KQL are all tested. Every code example in our modules includes line-by-line explanations.
What's in the free tier?
Four study modules covering Delta Lake foundations, loading patterns, dimensional modeling, and choosing the right Fabric engine — plus 16 practice questions. No account needed.
How is DP-700 different from DP-900?
DP-900 (Azure Data Fundamentals) is a beginner exam with no coding. DP-700 is intermediate-level and very hands-on — you need to know PySpark, SQL, KQL, and Fabric-specific tools like Eventstreams, shortcuts, and mirroring.
Is this a one-time purchase?
Yes. Pay once, access forever. No subscription or recurring fees.
Can I study on my phone?
Yes — every module is optimised for 10-minute mobile study sessions with interactive flashcards and quizzes.

Ready to start?

Try the free tier. Upgrade when you're ready to pass.

Start Free → Try Practice Quiz

Guided

I learn, I simplify, I share.

A Guide to Cloud YouTube Feedback

© 2026 Sutheesh. All rights reserved.

Guided is an independent study resource and is not affiliated with, endorsed by, or officially connected to Microsoft. Microsoft, Azure, and related trademarks are property of Microsoft Corporation. Always verify information against Microsoft Learn.