In a Snow flake schema
-
Dimensions and Facts should be normalized and should be in snow flake form
-
Should have fact and dimension joined together in 3rd normal form
-
Contains additional information about dimensions in normalized form
-
None of the above
Reveal answer
Fill a bubble to check yourself
C
Correct answer
Explanation
A snowflake schema normalizes dimension tables into multiple related tables to reduce redundancy and save storage space. Unlike star schemas where dimensions are denormalized, snowflake schemas break down dimensions into hierarchical levels (e.g., product → product category → product type). Option A incorrectly suggests facts are normalized (they're not - facts remain denormalized). Option B is wrong because fact and dimension tables are not joined together in 3NF - only dimensions are normalized.