DP-700 study guide · 2026

The 3 DP-700 domains, explained

3 domains and 10 official functional groups. Implement and manage an analytics solution carries the most weight at 30–35%. Each guide explains what the domain covers, how its questions are framed and where candidates lose marks.

Start with Domain 1 See all domains
Questions
Not published
Time
100 minutes
Passing score
700 / 1000
Outline
DP-700 study guide on Microsoft Learn, page last updated 2026-10-30 (current)

Exam blueprint

Bar widths follow the official weights, scaled to fit the bar. Weight ranges are drawn at their midpoint.

  1. 1 30–35%
  2. 2 30–35%
  3. 3 30–35%
  1. 1 Implement and manage an analytics solution
  2. 2 Ingest and transform data
  3. 3 Monitor and optimize an analytics solution

All 3 domains

10 official functional groups 50–64 hrs suggested study

  1. Domain 01 30–35%

    Implement and manage an analytics solution

    Setting up and running a Microsoft Fabric analytics solution: Spark, domain, OneLake and data workflow settings, Git-based lifecycle management, layered security and governance, and orchestration with pipelines, notebooks, schedules and triggers.

    Inside this domain

    • Configure Microsoft Fabric workspace settings
    • Implement lifecycle management in Fabric
    • Configure security and governance
    • Orchestrate processes

    Watch for Viewer is always safe

    Functional groups
    4
    Questions est.
    ~17
    Study time est.
    16–20 hrs
  2. Domain 02 30–35%

    Ingest and transform data

    Moving and shaping data in Microsoft Fabric: full and incremental loading patterns, dimensional model preparation, choosing stores and transformation tools, shortcuts and mirroring, batch transforms in PySpark, SQL and KQL, and streaming with eventstreams, Spark and KQL.

    Inside this domain

    • Design and implement loading patterns
    • Ingest and transform batch data
    • Ingest and transform streaming data

    Watch for Shortcut for a SQL database

    Functional groups
    3
    Questions est.
    ~17
    Study time est.
    20–26 hrs
  3. Domain 03 30–35%

    Monitor and optimize an analytics solution

    Keeping Fabric workloads healthy: monitoring ingestion, transformation and semantic model refresh, configuring alerts, diagnosing errors across six item types, and optimizing lakehouse tables, pipelines, warehouses, real-time items, Spark and queries.

    Inside this domain

    • Monitor Fabric items
    • Identify and resolve errors
    • Optimize performance

    Watch for VACUUM for speed

    Functional groups
    3
    Questions est.
    ~16
    Study time est.
    14–18 hrs

Study the heaviest domains first

Marks follow weight. This order puts the most marks behind you first, across about 50–64 hrs of study.

  1. 1 Implement and manage an analytics solution 30–35% · 16–20 hrs
  2. 2 Ingest and transform data 30–35% · 20–26 hrs
  3. 3 Monitor and optimize an analytics solution 30–35% · 14–18 hrs

Try one

Practice questionDomain 1: Implement and manage an analytics solution

A Fabric warehouse holds HR data. Members of a regional managers group must see only rows for their own region when they run T-SQL queries. They must not edit any other items in the workspace. What should you configure?

One trap from every domain

The answer that looks right, and the clue that gives it away.

  • Domain 1

    Viewer is always safe

    Clue Only one item or one table is mentioned.

  • Domain 2

    Shortcut for a SQL database

    Clue The source is a relational database rather than files.

  • Domain 3

    VACUUM for speed

    Clue Many small files and slow reads.

Other Data & Analytics certifications

Study guides for exams that overlap with DP-700.

Practise what you read

DP-700 domains: common questions

How many domains are in the DP-700 exam?

DP-700 has 3 domains with 10 official functional groups between them: Implement and manage an analytics solution, Ingest and transform data and Monitor and optimize an analytics solution.

Which DP-700 domain carries the most weight?

Implement and manage an analytics solution is the heaviest at 30–35%, followed by Ingest and transform data (30–35%). The lightest is Monitor and optimize an analytics solution (30–35%). Weights come from Microsoft's official outline.

What is the DP-700 exam format?

Questions: Not published. Time allowed: 100 minutes. Passing score: 700 / 1000.

How long should I study for DP-700?

Our planning estimate is 50–64 hrs across all domains, split by weight. It is an editorial estimate, not an official figure, so adjust it to your experience and to how you score on practice questions.

Where should I start?

Start with Implement and manage an analytics solution, because it carries the most marks, then work down by weight. Use the checklist on each domain page to confirm you can do what the domain asks before moving on.

Which outline is this guide based on?

This guide follows DP-700 study guide on Microsoft Learn, page last updated 2026-10-30 (current), published by Microsoft. It was last reviewed in October 2026.

Domain names, weights and functional groups come from Microsoft's official outline (DP-700 study guide on Microsoft Learn, page last updated 2026-10-30 (current)). Question counts and study hours are editorial planning estimates, not official figures. Last reviewed October 2026.