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 in data warehousing?
Open an interactive chat with Bash
How does a snowflake schema differ from a star schema?
Open an interactive chat with Bash
What are the advantages of using a snowflake schema?