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 does a snowflake schema have in common with a star schema?
2. What distinguishes a snowflake schema from a star schema?
3. How does normalising dimensions into sub-dimensions affect a report query in a snowflake schema?
4. In the snowflake schema example, into which sub-dimensions is the Location dimension normalised?
5. Whose data warehousing approach does the snowflake schema belong to?
6. In the snowflake schema example, what is the name of the fact table?
7. According to Ralph Kimball, what modelling must be used for data warehouses and data marts?
8. Which statement about joins in a snowflake schema versus a star schema is correct?
9. What is a sub-dimension in a snowflake schema?
10. In which kinds of data store is the snowflake schema applied?