Dimensional Modeling and Star Schema Concepts Questions

Understand fact and dimension tables, surrogate keys, and slowly changing dimensions. Be able to write queries that efficiently query dimensional data structures. Understand grain of fact tables and how to aggregate appropriately.