SNOWFLAKE SCHEMA
From the book I Am Datapedia!, published here free by the author.
Part of I Am Datapedia!
Questions 1–10 of 10
1. What distinguishes a snowflake schema from a star schema?
2. What is the primary goal of the snowflake schema?
3. In the snowflake example, into which components might Dim_Customer be split?
4. How does a snowflake schema typically come into being?
5. Why is normalising shared dimensions valuable when multiple fact tables such as Loans, Collections and Marketing Campaigns exist?
6. Why are snowflake schemas often paired with a semantic layer or BI modelling tool?
7. Which of the following is NOT listed as an advantage of the snowflake schema?
8. In which situation is the snowflake schema particularly useful?
9. Toward which normal-form principles does the snowflake schema move by partially normalising dimensions?
10. Which query is given as an example that analysts can still run in the snowflake loan approval environment?