Question
How does a snowflake schema differ from a star schema?
Select an option. Your answer will be checked instantly.
Correct Answer: D. Dimension attributes are normalized into additional related tables
Explanation:
Snowflaking decomposes dimensions into normalized subdimensions.
It reduces some redundancy but adds joins and complexity for users.
Leave a Reply