Skip to content

Exam DP-700: Objective Domain Mapping Matrix

Exam DP-700: Objective Domain Mapping Matrix

Source

Objective Coverage & Vault Traceability

Functional DomainWeightSpecific Sub-ObjectiveVault Canonical ModuleLab ExerciseCoverage Status
Domain 1: Plan, implement, and manage data engineering solutions30–35%Configure Spark settings, pools, and environment librariesUse Apache Spark in Microsoft FabricLab 02🟢 Complete
Design Lakehouse vs Warehouse architecturesGet Started with Lakehouses in Microsoft FabricLab 01🟢 Complete
Manage OneLake shortcuts (ADLS, S3, GCS, Dataverse)Configure OneLake Shortcuts and Data SharingLab 01🟢 Complete
Implement lifecycle management (Git integration, deployment pipelines)Plan, Implement, and Manage Data Engineering SolutionsLab 07🟢 Complete
Configure Apache Airflow workspaces and DAGsImplement Data Pipelines with Apache Airflow in FabricLab 06🟢 Complete
Implement workspace roles and item-level permissionsImplement Security and Governance for Fabric Data EngineeringLab 08🟢 Complete
Implement RLS, CLS, OLS, and Dynamic Data MaskingImplement Security and Governance for Fabric Data EngineeringLab 08🟢 Complete
Manage Purview sensitivity labels & private endpointsImplement Security and Governance for Fabric Data EngineeringLab 08🟢 Complete
Domain 2: Ingest and transform data30–35%Ingest data via Data Factory pipelines & CDCUse Data Factory Pipelines in Microsoft FabricLab 04🟢 Complete
Transform data with Dataflows Gen2 & Fast CopyIngest Data with Dataflows Gen2 in Microsoft FabricLab 05🟢 Complete
Ingest streaming data via Eventstreams & EventhousesIngest Real-Time Data with Eventstreams in Microsoft FabricLab 03🟢 Complete
Implement Database Mirroring (Azure SQL, Cosmos, Snowflake)Mirror Databases in Microsoft FabricLab 04🟢 Complete
Implement Medallion architecture (Bronze, Silver, Gold)Organize a Fabric Lakehouse using Medallion Architecture DesignLab 01🟢 Complete
Transform data with PySpark DataFrames & Spark SQLUse Apache Spark in Microsoft FabricLab 02🟢 Complete
Implement PySpark Structured Streaming & WindowingUse Apache Spark in Microsoft FabricLab 02🟢 Complete
Optimize Delta tables (OPTIMIZE, V-ORDER, VACUUM, Liquid Clustering)Work with Delta Lake Tables in Microsoft FabricLab 02🟢 Complete
Author KQL queries, update policies, and materialized viewsQuery and Transform Data in KQL DatabasesLab 03🟢 Complete
Domain 3: Monitor and optimize data engineering solutions30–35%Monitor Fabric Capacity Metrics app (CU, bursting, smoothing)Manage Capacity and Performance in Microsoft FabricLab 09🟢 Complete
Monitor Spark applications, stages, and executor logsMonitor and Optimize Data Engineering Workloads in FabricLab 10🟢 Complete
Detect and resolve Spark data skew and spill-to-diskMonitor and Optimize Data Engineering Workloads in FabricLab 10🟢 Complete
Troubleshoot pipeline failures and capacity throttlingManage Capacity and Performance in Microsoft FabricLab 09🟢 Complete