The approach that groups dimension information into multiple smaller tables is referred to as a snowflake schema. It structures related attributes in sub-tables, which reduces the chance of duplicated fields and preserves data integrity. The alternative choices combine dimension fields into larger tables or remove them, which conflicts with the snowflake design.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is a snowflake schema?
Open an interactive chat with Bash
What are the benefits of using a snowflake schema over other schemas?
Open an interactive chat with Bash
How does normalization relate to the snowflake schema?