ISRO-DEC2017-79

Question

Which of the following related to snowflake schema is true?

• A. Each dimension is represented by a single dimensional table
• B. Maintenance efforts are less
• C. Dimension tables are normalized
• D. It is not an extension of star schema

Answer 1

Snowflake schema consists of a fact table surrounded by multiple dimension tables 

• Each dimension is represented by multiple dimension tables . 1 is false
• Maintenance efforts are more. 2 is false
• Dimension tables are normalized (usually in 3 NF) . 3 is True (NB: But in star scheme it may not be true always)
• It is an extension of star schema. 4 is false

 answer is 3

Comments

IS It in GATE 2021 sylaabus too?, I mean a hidden topic kinda.

Answer 2

(C) should be answer

 snowflaking is normalization of the dimension tables by removing low cardinality attributes and forming separate tables.