How does a snowflake schema differ from a star schema?
- A Its dimension tables are normalised into further sub-dimensions
- B It has no fact table
- C It uses only one table
- D It stores data in columns
Answer
Its dimension tables are normalised into further sub-dimensions
Snowflaking saves some storage but adds joins, which usually costs more in query performance than it saves in space.





