← All certifications
DP-700microsoft

Microsoft Fabric Data Engineer Associate

Microsoft Fabric Data Engineer Associate official-source-aligned practice bank.

Official study guide
Free — no charge
3 modules360 practice questions

Implement and manage an analytics solution

Study the official objectives for Implement and manage an analytics solution.

30-35%
Configure Microsoft Fabric workspace settingsImplement lifecycle management in FabricConfigure security and governanceOrchestrate processes

Configure Microsoft Fabric workspace settings

Intermediate20 min

Review the official skills for Configure Microsoft Fabric workspace settings and practice applying them to scenarios.

Configure Spark workspace settings:
https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-700
Configure domain workspace settings:
https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-700
Configure OneLake workspace settings:
https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-700
Configure Apache Airflow workspace settings:
https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-700

Implement lifecycle management in Fabric

Intermediate20 min

Review the official skills for Implement lifecycle management in Fabric and practice applying them to scenarios.

Configure version control:
https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-700
Implement database projects:
https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-700
Create and configure deployment pipelines:
https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-700

Configure security and governance

Intermediate20 min

Review the official skills for Configure security and governance and practice applying them to scenarios.

Implement workspace-level access controls:
https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-700
Implement item-level access controls:
https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-700
Implement row-level, column-level, object-level, and folder/file-level access controls:
https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-700
Implement dynamic data masking:
https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-700
Apply sensitivity labels to items:
https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-700
Endorse items:
https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-700
Implement and use Microsoft Fabric audit logs:
https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-700
Configure and implement OneLake security:
https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-700

Orchestrate processes

Intermediate20 min

Review the official skills for Orchestrate processes and practice applying them to scenarios.

Choose between Dataflow gen 2, a pipeline and a notebook:
https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-700
Design and implement schedules and event-based triggers:
https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-700
Implement orchestration patterns with notebooks and pipelines, including parameters and dynamic expressions:
https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-700

Ingest and transform data

Study the official objectives for Ingest and transform data.

30-35%
Design and implement loading patternsIngest and transform batch dataIngest and transform streaming data

Design and implement loading patterns

Intermediate20 min

Review the official skills for Design and implement loading patterns and practice applying them to scenarios.

Design and implement full and incremental data loads:
https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-700
Prepare data for loading into a dimensional model:
https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-700
Design and implement a loading pattern for streaming data:
https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-700

Ingest and transform batch data

Intermediate20 min

Review the official skills for Ingest and transform batch data and practice applying them to scenarios.

Choose an appropriate data store:
https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-700
Choose between Dataflows Gen2, notebooks, KQL, and T-SQL for data transformation:
https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-700
Create and manage OneLake shortcuts:
https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-700
Implement mirroring:
https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-700
Ingest data by using pipelines:
https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-700
Transform data by using PySpark, SQL, and KQL:
https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-700
Denormalize data:
https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-700
Group and aggregate data:
https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-700
Handle duplicate, missing, and late-arriving data:
https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-700

Ingest and transform streaming data

Intermediate20 min

Review the official skills for Ingest and transform streaming data and practice applying them to scenarios.

Choose an appropriate streaming engine:
https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-700
Choose between native tables and OneLake shortcuts in Real-Time Intelligence:
https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-700
Choose between Query acceleration for OneLake shortcuts and standard OneLake shortcuts in Real-Time Intelligence:
https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-700
Process data by using Eventstream:
https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-700
Process data by using Spark structured streaming:
https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-700
Process data by using KQL:
https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-700
Create windowing functions:
https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-700

Monitor and optimize an analytics solution

Study the official objectives for Monitor and optimize an analytics solution.

30-35%
Monitor Fabric itemsIdentify and resolve errorsOptimize performanceIn this article

Monitor Fabric items

Intermediate20 min

Review the official skills for Monitor Fabric items and practice applying them to scenarios.

Monitor data ingestion:
https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-700
Monitor data transformation:
https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-700
Monitor semantic model refresh:
https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-700
Configure alerts:
https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-700

Identify and resolve errors

Intermediate20 min

Review the official skills for Identify and resolve errors and practice applying them to scenarios.

Identify and resolve pipeline errors:
https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-700
Identify and resolve Dataflow Gen2 errors:
https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-700
Identify and resolve notebook errors:
https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-700
Identify and resolve Eventhouse errors:
https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-700
Identify and resolve Eventstream errors:
https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-700
Identify and resolve T-SQL errors:
https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-700
Identify and resolve OneLake shortcut errors:
https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-700

Optimize performance

Intermediate20 min

Review the official skills for Optimize performance and practice applying them to scenarios.

Optimize a Lakehouse table:
https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-700
Optimize a pipeline:
https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-700
Optimize a data warehouse:
https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-700
Optimize Eventstream and Eventhouse:
https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-700
Optimize Spark performance:
https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-700
Optimize query performance:
https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-700
Last updated on 2026-08-16:
https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-700

In this article

Intermediate20 min

Review the official skills for In this article and practice applying them to scenarios.

Light:
https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-700
Dark:
https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-700
High contrast:
https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-700
AI Disclaimer:
https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-700
Previous Versions:
https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-700
Blog:
https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-700
Contribute:
https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-700
Privacy:
https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-700
Consumer Health Privacy:
https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-700
Terms of Use:
https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-700
Trademarks:
https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-700
© Microsoft 2026:
https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-700