Multiple choice technology databases

A snowflake schema is which of the following types of tables?

  1. Fact

  2. Dimension

  3. Helper

  4. All of the above
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

A snowflake schema extends the star schema by normalizing dimension tables into multiple levels. This introduces all three table types: fact tables (central), dimension tables (primary and secondary), and helper/bridge tables (additional normalization levels). The 'helper' tables are the normalized-out dimension attributes.

AI explanation

A snowflake schema is a variation of the star schema where the dimension tables are further normalized into sub-dimension ('helper') tables, alongside the central fact table. Because the schema is defined by the combination of fact tables, dimension tables, and their normalized sub-tables, 'all of the above' captures the full structure rather than any single table type in isolation.

Keep practicing — related questions