Skip to content

Microsoft Learn DP-700 Hands-On Lab Index

Microsoft Learn DP-700 Hands-On Lab Index

Source

Provider: Microsoft Learn
Content type: Practical Lab Index
Target Exam: Exam DP-700
Date captured: 2026-08-15
Last reviewed: 2026-08-15

🧪 Comprehensive Lab Exercises

Lab 01: Lakehouse Architecture & OneLake

Goal: Provision a Fabric Lakehouse, upload CSV data to Files/, load into managed Delta tables in Tables/, create an external ADLS Gen2 shortcut, and query using SQL Analytics Endpoint.
Estimated Duration: 30 mins
Related Module: Get Started with Lakehouses in Microsoft Fabric

Lab 02: Spark Lakehouse Engineering & Optimization

Goal: Author a PySpark notebook to transform raw sales data, apply Medallion architecture transformations, configure Liquid Clustering, run OPTIMIZE ... VORDER, and execute Delta time-travel queries.
Estimated Duration: 45 mins
Related Module: Use Apache Spark in Microsoft Fabric

Lab 03: Real-Time Eventstreams & KQL

Goal: Create an Eventstream connected to a simulated IoT streaming source, apply in-stream filtering/windowing, land events in a KQL Database, author a KQL Update Policy, and render time-series anomaly charts.
Estimated Duration: 40 mins
Related Module: Ingest Real-Time Data with Eventstreams in Microsoft Fabric

Lab 04: Data Factory Pipelines & CDC

Goal: Build an orchestration pipeline with Copy Activity, Lookup, ForEach loop, and parameterized Notebook execution with email failure alerts.
Estimated Duration: 35 mins
Related Module: Use Data Factory Pipelines in Microsoft Fabric

Lab 05: Dataflows Gen2 & Fast Copy

Goal: Ingest messy multi-table CSV sources using Power Query Online, verify query folding, configure Fast Copy, and write to a Lakehouse destination.
Estimated Duration: 30 mins
Related Module: Ingest Data with Dataflows Gen2 in Microsoft Fabric

Lab 06: Apache Airflow Orchestration

Goal: Deploy an Apache Airflow workspace in Fabric, author a Python DAG utilizing FabricRunItemOperator, and trigger a multi-item pipeline.
Estimated Duration: 40 mins
Related Module: Implement Data Pipelines with Apache Airflow in Fabric

Lab 07: CI/CD & Deployment Pipelines

Goal: Connect a Fabric workspace to Azure DevOps / GitHub Git integration, create Development, Test, and Production deployment stages, and perform rule-based deployment.
Estimated Duration: 35 mins
Related Module: Manage Capacity and Performance in Microsoft Fabric

Lab 08: Security, RLS & Governance

Goal: Configure workspace roles, implement Row-Level Security and Dynamic Data Masking in the SQL analytics endpoint, and apply Microsoft Purview sensitivity labels.
Estimated Duration: 30 mins
Related Module: Implement Security and Governance for Fabric Data Engineering

Lab 09: Capacity Metrics Monitoring

Goal: Install and explore the Microsoft Fabric Capacity Metrics app, drill down into high-CU timepoints, and analyze interactive vs background compute smoothing.
Estimated Duration: 25 mins
Related Module: Manage Capacity and Performance in Microsoft Fabric

Lab 10: Spark Performance Tuning & Skew Mitigation

Goal: Use the Spark Application UI to identify stage bottlenecks, data skew, and disk spills, and fix using broadcast joins and AQE skew join settings.
Estimated Duration: 40 mins
Related Module: Monitor and Optimize Data Engineering Workloads in Fabric