Which of the following related to snowflake schema is true?
2017
Which of the following related to snowflake schema is true?
Answer: C. Dimension tables are normalised — A snowflake schema is a data warehouse modeling technique where dimension tables are normalized. Unlike the star schema which keeps dimensions denormalized,…
- A.
Each dimension is represented by a single dimensional table
- B.
Maintenance efforts are less
- C.
Dimension tables are normalised
- D.
It is not an extension of star schema
Attempted by 15 students.
Show answer & explanation
Correct answer: C
A snowflake schema is a data warehouse modeling technique where dimension tables are normalized. Unlike the star schema which keeps dimensions denormalized, the snowflake schema breaks them down into multiple related tables. Thus, the characteristic of normalized dimension tables is true for a snowflake schema.