Multiple choice technology databases

How is the Snowflake schema different from the star schema?

    1. Snowflake queries are faster than the star schema.
    1. Snowflake links each table to each other, while star schema links each table to a central table.
    1. Snowflake has additional tables linked to the outer tables of a star schema.
    1. Snowflake is more optimized for a data warehouse.
    1. Snowflake is less complicated than star schema.
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Snowflake schema is an extension of star schema where dimension tables are normalized into additional related tables. This reduces redundancy (normal form benefit) but increases query complexity due to more joins. Star schema has denormalized dimensions directly connected to the fact table - simpler but with data redundancy.

Keep practicing — related questions