Microsoft Fabric Data Engineer Associate (DP-700) — Study Notes

Study notes for Exam DP-700. Skills outline reflects the exam version effective July 21, 2026.

Files

File	Description
1_implement_manage.md	Workspace config, lifecycle management, security & governance, orchestration
2_ingest_transform.md	Loading patterns, batch ingestion/transformation, streaming ingestion/transformation
3_monitor_optimize.md	Monitoring, error resolution per item type, performance optimization
exam_sections.md	Full exam domain breakdown with weightings
study_cheat_sheet.md	Decision trees, security layers, Delta/streaming syntax
study_flashcards.md	Flashcards for key concepts
study_practice_questions.md	30 practice questions with explanations
study_topic_summaries.md	Topic summaries for final review

Exam domains

Domain	Weight
Implement and manage an analytics solution	30–35%
Ingest and transform data	30–35%
Monitor and optimize an analytics solution	30–35%

Sourcing

• Skills outline: official DP-700 study guide — domains/weights/bullets.
• Teaching depth: unit pages (not module index pages) of the five learning paths behind the DP-700 course (dp-700t00) — concepts, T-SQL/KQL/PySpark syntax, numeric specifics.
• API cross-check: Context7 MCP — delta-io/delta (OPTIMIZE/VACUUM/ZORDER), pyspark (structured streaming).
• Drift/gap check: Exa search against community writeups and current MS docs. Microsoft docs are authoritative on conflict; Exa is verification-only. Caught: V-Order default flipped on→off in current Fabric workspaces; deployment pipeline item-pairing/gateway-remapping behavior undocumented in training modules.

Regenerating

1. Skills outline

WebSearch for the current study guide URL, WebFetch:

https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-700

Check the page's "Change log" table for a version bump.

2. Training module content

1. WebFetch https://learn.microsoft.com/en-us/training/courses/dp-700t00 → YAML frontmatter learn_item lists the 5 learning-path IDs.
2. WebFetch each path's index: https://learn.microsoft.com/en-us/training/paths/<path-id>/ → module list.
3. Module index pages (.../modules/<module-id>/) are TOC only. Fetch individual unit pages: .../modules/<module-id>/<unit-slug> (e.g. .../modules/work-delta-lake-tables-fabric/3b-optimize-delta-tables). Skip Introduction/Exercise/Assessment/Summary units.
4. Prioritize units mapping to graded exam bullets.

3. Context7 API check

Pull current docs for delta-io/delta and pyspark via Context7 MCP to verify code snippets.

4. Exa verification (optional)

Key in Keychain, not .env:

security add-generic-password -a "$USER" -s "EXA_API_KEY" -w "your-key"
python3 -m venv venv && source venv/bin/activate && pip install exa-py

import os, subprocess
from exa_py import Exa

key = subprocess.check_output(
    ["security", "find-generic-password", "-a", os.environ["USER"], "-s", "EXA_API_KEY", "-w"]
).decode().strip()
exa = Exa(api_key=key)

r = exa.search("DP-700 Microsoft Fabric exam gotchas tricky questions", type="auto", num_results=6)
for res in r.results:
    print(res.title, res.url)

c = exa.get_contents(
    ["https://learn.microsoft.com/en-us/fabric/data-engineering/delta-optimization-and-v-order"],
    text={"max_characters": 5000},
    livecrawl="always",
)
print(c.results[0].text)

Query patterns: "<topic> exam experience/gotchas" for test-taker writeups; "<claim> Microsoft Fabric" + live-crawled get_contents on the top official hit to check a training-module fact for staleness.

5. Update files

Update 1_implement_manage.md / 2_ingest_transform.md / 3_monitor_optimize.md first (map 1:1 to the three exam domains), then regenerate study_cheat_sheet.md, study_flashcards.md, study_practice_questions.md, study_topic_summaries.md from those.