🎴 Flashcard Mode
IBM Cognos BI Fundamentals
Card1 / 20
Mastered0
Review0
QuestionClick to flip
In a Snow flake schema
AnswerClick to flip back
A
Contains additional information about dimensions in normalized form
💡 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.