Multiple choice technology platforms and products

Snowflaking means

  1. Normalizing the data

  2. Denormalizing the data

  3. Both 1 & 2

  4. None of the above
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Snowflaking is the process of normalizing dimension tables in a star schema, splitting large dimensions into hierarchical structures. This reduces redundancy but increases join complexity compared to denormalized star schemas.

AI explanation

Snowflaking refers to normalizing the dimension tables of a star schema into multiple related tables, forming the snowflake shape in an entity diagram, which reduces redundancy compared to the flat, denormalized dimensions of a plain star schema. Denormalizing would actually collapse tables together rather than split them, which is the opposite of what snowflaking does.

Keep practicing — related questions