Azure DP-900 case studies
Azure DP-900 · Put your knowledge to work in context.
The Microsoft Certified: Azure Data Fundamentals credential is an entry-level certification - Microsoft lists its level as Beginner - that demonstrates foundational knowledge of core data concepts and the Microsoft Azure data services built around them. It sits in the Databases subject area and is associated with the Data Engineer role, but the intended audience is broader: candidates just beginning to work with data in the cloud who want a recognized starting point. The Azure DP-900 case studies are 5 cases and about 4,736 words.
1One Utility, Four Data Shapes, Three Latency Requirements
Northwind Utilities operates 40,000 smart electricity meters. Each meter posts a JSON message every 15 seconds containing a meter ID, a timestamp, a voltage reading, and a nested array of variable-length interval readings.
814 words, about 4 min2Lifting a Multi-Database SQL Server Estate Without a Rewrite
Fabrikam Insurance runs SQL Server 2016 on-premises: 4 TB across 60 databases. The claims application joins three databases in a single query.
826 words, about 4 min3Product Catalog and a Recommendation Graph in Cosmos DB
Tailspin Toys sells 25 million product SKUs. Each catalog document is JSON, and the fields differ by category: toys carry age ranges and safety flags, electronics carry voltage and nested warranty objects.
900 words, about 5 min4Forty Terabytes of Telemetry and a Monthly Bill Nobody Wants to Repeat
Contoso Logistics lands 40 TB of raw JSON and CSV telemetry from 8,000 trucks into Azure Data Lake Storage Gen2, growing at 3 TB per month. Two data engineers must clean the data and convert it to partitioned Parquet.
970 words, about 5 min5Real-Time Alerts and Exact Daily Money From the Same Event Stream
Adventure Works Bike Share runs 12,000 bikes in 40 cities. Each bike emits a status event (bike ID, city, location, battery, error code) every 10 seconds - about 1,200 events per second, spiking to 4,000 during commute hours.
1,226 words, about 6 min