DP-600 case studies
DP-600 · Put your knowledge to work in context.
The Microsoft Certified: Fabric Analytics Engineer Associate credential is an intermediate-level certification for professionals who design, create, and deploy enterprise-scale data analytics solutions on Microsoft Fabric. It sits at the intersection of data engineering and data analysis: candidates prepare and enrich data for analysis, secure and maintain analytics assets, and implement and manage semantic models. Day to day, that means working with lakehouses, warehouses, notebooks, dataflows, pipelines, semantic models, and reports, while applying analytics best practices such as version control and deployment. The role also requires partnership with solution architects, data engineers, data scientists, AI engineers, database administrators, and Power BI analysts, plus hands-on skill in SQL, DAX, and PySpark. The DP-600 case studies are 5 cases and about 2,736 words.
1Consolidating a Shared Fabric Capacity Across Six Domains
Northwind Health runs Microsoft Fabric on a single F64 capacity. All six analytics domains share one workspace named CorpAnalytics with 38 Contributors and 12 Viewers.
588 words, about 3 min2Batch, Streaming, and On-Premises Ingestion for Logistics
Tailspin Logistics ingests 3 TB per day from 1,200 CSV files dropped every 10 minutes by 14 warehouse systems, plus 4 TB of on-premises SQL Server order history that changes continuously. Operations dashboards need 15-minute latency; finance accepts four hours.
589 words, about 3 min3Choosing a Semantic Model Storage Mode for a Large Retail Schema
Contoso Retail has a 60 GB star schema in OneLake Delta with 500 million sales rows. About 250 analysts query 30 reports, with peak concurrency of 80.
529 words, about 3 min4Rescuing an Overgrown Semantic Model with Slow DAX
Fabrikam has one semantic model with a fact table of 800 million rows and 12 dimension tables. It contains 45 measures, 180 calculated columns, 22 bi-directional relationships, and several DISTINCTCOUNT measures over customer and product keys.
511 words, about 3 min5Self-Service Discovery Across a 60-Domain Data Estate
Adventure Works has 2 PB in OneLake across 60 domains. About 400 analysts use notebooks, SQL, and Power BI.
519 words, about 3 min