Intermediate
Database Management Systems
Q63 / 100
What is the difference between star schema and snowflake schema?
Correct! Well done.
Incorrect.
The correct answer is B) Star schema has denormalized dimensions (fewer JOINs); snowflake normalizes dimensions into sub-dimensions (more JOINs, less storage)
B
Correct Answer
Star schema has denormalized dimensions (fewer JOINs); snowflake normalizes dimensions into sub-dimensions (more JOINs, less storage)
Explanation
Star schema: fact table + denormalized dimension tables. Simple JOINs, faster queries, more storage. Snowflake: normalized dimensions into hierarchies. More JOINs but better data integrity and less storage.
Progress
63/100