Fabric DP-700 case studies
Fabric DP-700 · Put your knowledge to work in context.
Microsoft Certified: Fabric Data Engineer Associate is an intermediate-level Microsoft certification earned by passing exam DP-700: Implementing Data Engineering Solutions Using Microsoft Fabric. It targets data engineers who already have subject matter expertise with data loading patterns, data architectures, and orchestration processes, and who are skilled at manipulating and transforming data by using SQL, PySpark, and Kusto Query Language (KQL). The Fabric DP-700 case studies are 5 cases and about 3,891 words.
1Direct Lake, deployment pipelines, and per-BU shortcuts on one capacity
Adventure Works runs a single F64 Fabric capacity in West Europe. Lakehouse DEV and Lakehouse PROD hold the same Delta tables: gold sales, gold inventory and gold hr.
861 words, about 4 min2Three sources, three latencies, one F64 capacity
Fabrikam Instruments runs 1,200 line sensors across four plants. Each sensor posts a 2 KB JSON message about once per second, and the plant operations dashboard must show per-line throughput within five seconds.
778 words, about 4 min3Eighty-two percent average and still slow
Northwind runs its analytics platform on an F32 capacity. Overnight, 60 notebooks execute between 00:00 and 04:00, each taking about 20 minutes, with up to three concurrent; each recomputes aggregates by reading a 2 TB unpartitioned Delta table in full.
688 words, about 3 min4Forty-five T-SQL developers, three hundred report users, one gold layer
Litware has 45 T-SQL developers who insist on stored procedures, multi-table transactions and MERGE for the gold layer. Three hundred report authors across 20 dashboards query gold tables through a Direct Lake semantic model.
747 words, about 4 min5A replay, a duplicate batch, and a status that never lands
Tailspin receives retail orders through a REST API. A pipeline runs every 15 minutes, calls the API with a changed-since parameter, and appends the results to bronze orders.
817 words, about 4 min