Data Engineering on Microsoft Azure: Designing the Serving Layer

The serving layer is where data is stored for consumption by processing services. In this course you;ll explore dimensional data modeling and hierarchies. You;ll learn how to define slowly changing dimensions and temporal design within databases. Then you;ll learn about the differences between the star and snowflake schemas as well as how to design a star schema. Next you;ll examine incremental data loading for stream processing and the options for analytical data stores. Finally you;ll learn about options for creating metastores for use by Azure Databricks and Azure Synapse Analytics.

This course is one in a collection that prepares learners for the Microsoft Data Engineering on Microsoft Azure (DP-203) exam.