Brolly Academy | Azure Data Engineering
DP-700 Syllabus
2026: Exam Topics, Weightage and 6-Week Study Plan
The DP-700 syllabus has three equal domains: implement and manage an analytics solution, ingest and transform data, and monitor and optimize an analytics solution, each worth 30–35% of the exam.
Every skill measured on the DP-700 exam as of 19 October 2026, what each one means at work, a hands-on task to practise it, and a 6-week plan to cover the full syllabus.
By Dinesh, Azure Data Engineering Trainer (9+ years) · Brolly Academy · Updated 19 October 2026 · Skills measured as of 19 October 2026

Table of Contents
1. DP-700 syllabus at a glance
2. Domain 1: Implement and manage an analytics solution (30–35%)
3. Domain 2: Ingest and transform data (30–35%)
4. Domain 3: Monitor and optimize an analytics solution (30–35%)
5. What changed in the DP-700 syllabus on 19 October 2026
6. Skills to learn before you start the DP-700 syllabus
8. Free official resources mapped to the syllabus
Quick answer
The DP-700 syllabus (Exam DP-700: Implementing Data Engineering Solutions Using Microsoft Fabric) has three domains, each worth 30–35% of the exam:
- Implement and manage an analytics solution: workspace settings, lifecycle management, security and governance, and orchestration.
- Ingest and transform data: loading patterns, batch ingestion and transformation, and streaming data.
- Monitor and optimize an analytics solution: monitoring Fabric items, fixing errors, and optimizing performance.
You are expected to work with SQL, PySpark and KQL in Microsoft Fabric. This guide lists every skill measured as of 19 October 2026, shows what each one means in practice, and gives you a 6-week study plan.
Key takeaways
- Three domains, 30–35% each. You can't skip any of them.
- You use three query languages: T-SQL, PySpark and KQL (Kusto Query Language).
- Many questions test choosing the right tool: pipeline, Dataflow Gen2, notebook, T-SQL or KQL.
- Security, Git and deployment pipelines are a large part of Domain 1, not optional extras.
- Plan 6–8 weeks if you know SQL and Python basics, with at least half your time hands-on in a Fabric workspace.
Want the full certification process: booking, exam day, retakes, cost and renewal? Read our Azure data engineer certification guide.
1. DP-700 syllabus at a glance
Short answer: The official study guide splits DP-700 into 3 domains and 10 skill groups. Every domain carries the same weight, so a balanced plan beats deep study of one area.
Verdict: Treat each domain as one-third of your score. Most people who fail over-study Spark and under-study security, lifecycle and monitoring.
Microsoft Fabric items you must know
Before the domains make sense, know what each Fabric item does:
2. Domain 1: Implement and manage an analytics solution (30–35%)
Short answer: Domain 1 tests whether you can set up and run a Fabric environment safely: workspace settings, version control and deployment, access control and governance, and orchestrating jobs.
Configure Microsoft Fabric workspace settings
Implement lifecycle management in Fabric
Configure security and governance
Orchestrate processes
3. Domain 2: Ingest and transform data (30–35%)
Short answer: Domain 2 tests the core data engineering work: designing full and incremental loads, getting batch and streaming data into Fabric, and transforming it with PySpark, T-SQL and KQL.
Design and implement loading patterns
Ingest and transform batch data
Ingest and transform streaming data
Mini examples: the three languages you need
KQL (time-window aggregation)
Events
| where Timestamp > ago(1h)
| summarize EventCount = count() by bin(Timestamp, 5m), DeviceId
PySpark (incremental load with a watermark)
last_load = spark.sql("SELECT MAX(order_date) AS d FROM sales").collect()[0]["d"]
new_rows = spark.read.table("staging_orders").filter(f"order_date > '{last_load}'")
new_rows.write.mode("append").saveAsTable("sales")
T-SQL (upsert with MERGE)
MERGE dbo.DimCustomer AS t
USING stg.Customer AS s ON t.CustomerId = s.CustomerId
WHEN MATCHED THEN UPDATE SET t.City = s.City
WHEN NOT MATCHED THEN INSERT (CustomerId, City) VALUES (s.CustomerId, s.City);
4. Domain 3: Monitor and optimize an analytics solution (30–35%)
Short answer: Domain 3 tests whether you can keep a Fabric solution healthy: watching runs and refreshes, fixing errors across every item type, and making tables, Spark jobs and queries faster.
Monitor Fabric items
Identify and resolve errors
Optimize performance
5. What changed in the DP-700 syllabus on 19 October 2026
Short answer: It was a minor update. Microsoft adjusted Configure Microsoft Fabric workspace settings (Apache Airflow workspace settings now listed) and Optimize performance. The three domains and their 30–35% weights didn't change.
- English exam: updated on 19 October 2026.
- Other languages: updated about eight weeks after English, so check the official study guide if you take the exam in another language.
- Practice material: anything written before October 2026 may not mention Airflow settings. Older DP-203 material doesn't cover Fabric at all.
6. Skills to learn before you start the DP-700 syllabus
Short answer: You need working SQL, basic Python with PySpark, beginner KQL, data modelling basics and Git. Without SQL and Python, start there first.
7. 6-week DP-700 study plan
Short answer:
- Study 10–12 hours a week for six weeks.
- Spend at least half of that time hands-on in a Fabric workspace.
- Cover one part of the syllabus each week, and finish with practice assessments.
A daily routine that works
- 30 minutes: read one Microsoft Learn module for today's topic.
- 60–90 minutes: build it in your Fabric workspace.
- 15 minutes: write three notes: what you built, what broke, and how you fixed it.
- Weekends: one mini project that combines the week's skills.
Fast track for DP-203 holders (about 4 weeks)
8. Free official resources mapped to the syllabus
Short answer: Microsoft gives the study guide, learning paths, a practice assessment, an exam sandbox and a 60-day Fabric trial for free. That covers the whole DP-700 syllabus except the exam fee.
Test yourself with our 20 free DP-700 practice questions. For exam fees, booking, retakes and renewal, see the Azure data engineer certification guide. Deciding between Fabric exams? Read DP-600 vs DP-700; for Azure Databricks, see the DP-750 guide.
9. Common mistakes when studying the DP-700 syllabus
- Studying DP-203 material. It doesn't cover OneLake, shortcuts, mirroring, Eventstream or KQL.
- Skipping KQL. Streaming and Real-Time Intelligence appear in two of the three domains.
- Reading without building. "Which tool should you use?" questions need hands-on experience.
- Ignoring Domain 1. Security, Git and deployment pipelines are worth as much as Spark.
- Never breaking anything. Domain 3 is about fixing errors, so practise on purpose.
Learn the DP-700 skills hands-on
Our Azure Data Engineer Training in Hyderabad is a 2–2.5 month hands-on program in Azure Data Factory, Synapse Analytics, Databricks, PySpark, SQL and Python, with real-time projects and guidance for Microsoft certification exams. Book a free demo to review the syllabus and batch timings.
10. How Brolly Academy helps
Our Azure Data Engineer Training in Hyderabad builds the hands-on skills behind the DP-700 syllabus:
- Trainer: Dinesh, lead Azure Data Engineering trainer with 9+ years in cloud and data engineering
- Duration: 2–2.5 months, with daily 3–4 hours of lab practice and mentor support
- Tools: Azure Data Factory, Synapse Analytics, Databricks, PySpark, SQL and Python
- Projects: real-time projects in retail analytics, IoT streaming and healthcare data
- Modes: classroom, online and hybrid batches in English and Telugu, with a free demo class
- Fees: from ₹9,999, with EMI options
Working on Databricks instead? See our Databricks course. Browse every course at Brolly Academy.
Frequently asked questions
What is the DP-700 syllabus?
The DP-700 syllabus has three domains: implement and manage an analytics solution, ingest and transform data, and monitor and optimize an analytics solution. Each is worth 30–35% of the exam.
What is the weightage of each DP-700 domain?
All three domains are weighted 30–35%, so each is roughly one-third of your score.
When was the DP-700 syllabus last updated?
The English skills measured were updated on 19 October 2026. It was a minor update to workspace settings (Apache Airflow) and performance optimization.
Which languages do I need for the DP-700 syllabus?
T-SQL, PySpark and KQL. You use T-SQL for warehouses, PySpark for notebooks and Lakehouse tables, and KQL for real-time data in Eventhouse.
Is KQL a big part of DP-700?
Yes. KQL is needed for Real-Time Intelligence, Eventhouse queries and windowing, which appear in the ingestion and monitoring domains.
Does the DP-700 syllabus include Power BI?
Only lightly. You may need to monitor semantic model refreshes, but building reports belongs to the DP-600 exam.
Does the DP-700 syllabus cover Azure Data Factory or Synapse?
No. DP-700 tests Data Factory pipelines and Dataflow Gen2 inside Microsoft Fabric, not standalone Azure Data Factory or Synapse Analytics.
How long does it take to cover the DP-700 syllabus?
About 6–8 weeks at 10–12 hours a week if you know SQL and Python basics. DP-203 holders can often finish in about 4 weeks.
Can I study the DP-700 syllabus for free?
Yes. The study guide, Microsoft Learn learning paths, practice assessment, exam sandbox and a 60-day Fabric trial are all free. Only the exam itself is paid.
Where can I download the official DP-700 study guide?
On Microsoft Learn at aka.ms/DP700-StudyGuide. It lists every skill measured and a change log.
Is the DP-700 syllabus the same as DP-203?
No. DP-203 covered Azure Synapse, Data Factory, Databricks and Stream Analytics. DP-700 covers Microsoft Fabric, including OneLake, shortcuts, mirroring, Eventstream, Eventhouse and KQL.
What is the difference between the DP-700 and DP-750 syllabus?
DP-700 covers Microsoft Fabric. DP-750 covers Azure Databricks, including Unity Catalog, Lakeflow Jobs and Lakeflow Spark Declarative Pipelines.
What are the DP-700 skills measured?
The DP-700 skills measured are grouped into 3 domains and 10 skill groups in the official study guide. Domain 1 covers workspace settings, lifecycle management, security and governance, and orchestration. Domain 2 covers loading patterns, batch data and streaming data. Domain 3 covers monitoring Fabric items, resolving errors and optimizing performance. This guide follows the skills measured as of 19 October 2026.
What are the DP-700 exam topics in Domain 1?
Domain 1 exam topics cover setting up and running a Fabric environment. You configure Spark, domain, OneLake and Apache Airflow workspace settings. You use Git version control, database projects and deployment pipelines. You apply workspace, item, row, column and object-level access, dynamic data masking, sensitivity labels, endorsement, audit logs and OneLake security. You also orchestrate work with pipelines, notebooks, schedules and event-based triggers.
What DP-700 exam topics are covered in Domain 2?
Domain 2 covers the core data engineering work in Fabric. You design full and incremental loads and prepare data for a dimensional model. You ingest batch data with pipelines, shortcuts and mirroring, and transform it with PySpark, T-SQL and KQL. You also handle duplicate, missing and late-arriving data. For streaming, you choose between Eventstream, Spark Structured Streaming and KQL, and use windowing functions.
What does Domain 3 of the DP-700 syllabus cover?
Domain 3 covers keeping a Fabric solution healthy. You monitor data ingestion, data transformation and semantic model refresh, and configure alerts for failed runs. You find and fix errors in pipelines, Dataflow Gen2, notebooks, Eventhouse, Eventstream, T-SQL and OneLake shortcuts. You also optimize performance for Lakehouse tables, pipelines, the warehouse, Spark and queries, using options like V-Order, OPTIMIZE and VACUUM.
Which Microsoft Fabric items should I know for DP-700?
You should know OneLake, Lakehouse, Warehouse, pipeline, Dataflow Gen2, notebook, Eventstream, Eventhouse and semantic model. OneLake appears in all three domains. Eventstream and Eventhouse matter for streaming in Domains 2 and 3. The semantic model mainly appears in Domain 3 for refresh monitoring. Learn what each item does before you start the domains, because many questions ask you to choose between them.
Is the Microsoft Fabric data engineer syllabus the same as the DP-700 syllabus?
Yes. DP-700 is the exam for the Microsoft Certified: Fabric Data Engineer Associate certification, so the Microsoft Fabric data engineer syllabus is the DP-700 skills list. It covers implementing and managing an analytics solution, ingesting and transforming data, and monitoring and optimizing an analytics solution. All of it is done inside Microsoft Fabric using SQL, PySpark and KQL.
How should I structure a DP-700 study plan?
A simple DP-700 study plan runs for six weeks at 10–12 hours a week. Start with Fabric basics and data stores, then batch ingestion, transformations, streaming, security and lifecycle, and finally monitoring, optimization and revision. Spend at least half your time hands-on in a Fabric workspace. Each day, read one Microsoft Learn module, build it, and write short notes on what broke and how you fixed it.
Is the DP-700 syllabus hard for freshers?
The DP-700 syllabus can be hard for freshers who have not used SQL or Python before. The exam expects working T-SQL, basic PySpark and beginner KQL, plus data modelling and Git. Many questions ask you to choose the right tool for a scenario, which needs hands-on practice. If you are a fresher, learn SQL and Python first, then follow the study plan with plenty of time in a Fabric workspace.
What skills do I need before starting the DP-700 syllabus?
You need working SQL, basic Python with PySpark, beginner KQL, data modelling basics and Git. For SQL, know joins, window functions, CTEs and MERGE. For PySpark, know DataFrames, reading and writing Delta, filters, groupBy and joins. For KQL, know where, summarize, bin() and ago(). Delta Lake basics like OPTIMIZE and VACUUM also help. Without SQL and Python, start there first.
What are common mistakes when preparing for the DP-700 exam topics?
The most common mistake is studying old DP-203 material, which does not cover OneLake, shortcuts, mirroring, Eventstream or KQL. Others are skipping KQL, reading without building, and ignoring Domain 1 security, Git and deployment pipelines. Many people also never break anything on purpose, even though Domain 3 tests fixing errors. A balanced plan across all three domains avoids these gaps.
Is DP-700 study material from before October 2026 still useful?
Mostly yes, because the 19 October 2026 update was minor and the three domains and their weights did not change. However, material written before October 2026 may not mention Apache Airflow workspace settings or the changes to Optimize performance. Use older notes for the core topics, then check the official DP-700 study guide for the latest skills measured. Avoid DP-203 material, since it does not cover Fabric at all.
How much hands-on practice do I need for DP-700?
Plan to spend at least half of your study time hands-on in a Fabric workspace. Many DP-700 questions ask which tool you should use, and that is hard to answer from reading alone. Build each skill as you study it, such as an incremental load, a KQL window query or a deployment pipeline. The free 60-day Fabric trial gives you a workspace to practise in.
Can I prepare for the DP-700 syllabus with training in Hyderabad?
Yes. Brolly Academy's Azure Data Engineer Training in Hyderabad builds the hands-on skills behind the DP-700 syllabus, including PySpark, SQL and Python, with real-time projects. It runs for 2–2.5 months in classroom, online and hybrid batches in English and Telugu. Pair the training with the official study guide and hands-on Fabric practice so you cover every skill measured.
Learn with Brolly Academy
Review the syllabus, practical projects and batch timings, and book a free demo before you enrol.
Related Articles
Azure Data Engineer Certification 2026: DP-700 and DP-750 Guide
Which Microsoft data engineer certification to take, exam fee in India, booking, exam day, retakes and free renewal.
Read ArticleGCP vs AWS vs Azure: The Best Cloud Platform in 2026
Compare Google Cloud, AWS and Azure on services, jobs and learning paths before you pick a cloud certification.
Read Article20 Snowflake Projects for Beginners: SQL, Data and Validation
Build data engineering portfolio projects with SQL, sample datasets, ELT workflows and validation checks.
Read ArticleContinue Your Learning
Azure Data Engineer Training in Hyderabad
Azure Data Factory, Synapse, Databricks, PySpark, SQL and Python with real-time projects. Taught by Dinesh (9+ years). Fees from ₹9,999.
View CourseDatabricks Course
8 practical modules on SQL, Spark, Delta Lake, Unity Catalog and data pipelines, with data engineering projects.
View CourseAzure Data Factory Training in Hyderabad
Build and orchestrate data pipelines with Azure Data Factory through hands-on, real-time scenarios.
View Course