Free study guide

Microsoft DP-700 Study Guide

Microsoft Fabric Data Engineer DP-700

Microsoft DP-700, Implementing Data Engineering Solutions Using Microsoft Fabric, is the associate exam for the Fabric Data Engineer certification. It covers workspace settings, lifecycle management, security and orchestration, batch and streaming ingestion with pipelines, Dataflow Gen2, PySpark, SQL and KQL, and monitoring, troubleshooting and optimizing Fabric items. It suits data engineers who build and run data solutions in Microsoft Fabric.

  • Exam code DP-700
  • Associate level
  • 3 exam domains

This guide is free, with no sign-up. It explains every Microsoft DP-700 exam topic in plain English, one chapter at a time. Read them in order or jump straight to the topic you need.

  • 3chapters
  • 16topics
  • 5diagrams and exhibits
  • 1 h 22 minfast track
Start with Implement and Manage an Analytics Solution
  • Every topic follows the same simple pattern: what it is, how it works, common mistakes
  • Diagrams and real command output where a picture explains it best
  • Exam tips and worked subnetting and IPv6 practice, with answers

How the exam is weighted

Each domain is worth roughly this share of the exam. The exam provider publishes a range for each domain, so the bar marks the middle of it. Spend your study time in proportion, and select a domain to open its chapter.

Chapters

Open a chapter to see its topics and how long each takes.

1Implement and Manage an Analytics Solution5 topics · 25 min fast trackFabric workspace settings, Git and deployment pipelines, security and governance, and orchestrating pipelines and notebooks.
  1. 1Configuring Fabric Workspace Settings5 min
  2. 2Lifecycle Management with Git, Database Projects and Deployment Pipelines5 min
  3. 3Workspace and Item Access, Labels, Endorsement and Audit Logs5 min
  4. 4Row, Column, Object and Folder Security, Masking and OneLake Security5 min
  5. 5Orchestrating Processes with Pipelines, Notebooks and Dataflow Gen25 min
Read the chapter overview →
2Ingest and Transform Data6 topics · 30 min fast trackFull and incremental loads, dimensional models, shortcuts, mirroring, batch transforms and streaming with Eventstream and KQL.
  1. 1Loading Patterns: Full, Incremental, Dimensional and Streaming5 min
  2. 2Choosing a Data Store and a Transformation Tool5 min
  3. 3Ingesting Batch Data with Shortcuts, Mirroring and Pipelines5 min
  4. 4Transforming Batch Data with PySpark, SQL and KQL5 min
  5. 5Streaming Engines, Shortcuts in Real-Time Intelligence and Eventstream5 min
  6. 6Spark Structured Streaming, KQL Processing and Windowing Functions5 min
Read the chapter overview →
3Monitor and Optimize an Analytics Solution5 topics · 27 min fast trackMonitoring ingestion, transformation and refresh, alerts, fixing errors across Fabric items, and optimizing performance.
  1. 1Monitoring Fabric Items and Configuring Alerts5 min
  2. 2Resolving Pipeline, Dataflow Gen2 and Notebook Errors6 min
  3. 3Resolving Eventhouse, Eventstream, T-SQL and OneLake Shortcut Errors5 min
  4. 4Optimizing Lakehouse Tables and Spark Performance5 min
  5. 5Optimizing Pipelines, Warehouses, Real-Time Items and Queries6 min
Read the chapter overview →

Ready for more practice?

The full Microsoft DP-700 question bank has 645 questions, with timed practice exams and an explanation for every answer.

SubscribeTry Sample Exam

This study guide is independent and is not affiliated with, endorsed by, or sponsored by Microsoft. Vendor names, certification names and exam codes are trademarks of their respective owners and are used for identification only.