Exam DP-700: Implementing Data Engineering Solutions Using Microsoft Fabric
Proctored Microsoft certification exam focused on building, securing, and operating data engineering workloads in Microsoft Fabric.
- Type
- Written
- Duration
- 100 min
Exam sections
Implement and manage an analytics solution
Focuses on setting up and managing the Fabric environment. Key tasks include configuring workspace settings (Spark, OneLake), implementing lifecycle management with version control and deployment pipelines, and ensuring security and governance through access controls, data masking, and sensitivity labels.
Preparation tips
Review workspace-level and item-level security, including row-level and object-level permissions, and practice setting up deployment pipelines for lifecycle management.
Ingest and transform data
Covers the ingestion and transformation of both batch and streaming data. Includes designing loading patterns, dimensional modeling, and using tools like Dataflows Gen2, notebooks, KQL, and T-SQL. It also addresses handling streaming data with Eventstreams and Spark structured streaming.
Preparation tips
Practice creating Dataflow Gen2 and pipelines for batch ingestion, and experiment with Eventstreams and KQL for processing real-time streaming data.
Monitor and optimize an analytics solution
Centers on maintaining the health and performance of analytics solutions. Tasks involve monitoring Fabric items like data pipelines and semantic models, troubleshooting errors across various components (Lakehouse, Data Warehouse), and optimizing Spark workloads and query performance.
Preparation tips
Focus on troubleshooting techniques for Spark notebooks and pipelines, and understand how to use the Fabric capacity metrics app for performance monitoring.
