DA0-001 · Question #379
Which of the following is the most appropriate to consider when creating a schema of a central group broken into detailed subcategories?
The correct answer is C. Snowflake. A snowflake schema is the correct choice when a central group (fact table) is broken into detailed subcategories. It extends the star schema by normalizing dimension tables into multiple related sub-dimension tables, creating a hierarchy of detailed categories branching outward…
Question
Which of the following is the most appropriate to consider when creating a schema of a central group broken into detailed subcategories?
Options
- ARelational
- BHierarchical
- CSnowflake
- DStar
How the community answered
(34 responses)- A9% (3)
- B3% (1)
- C74% (25)
- D15% (5)
Explanation
A snowflake schema is the correct choice when a central group (fact table) is broken into detailed subcategories. It extends the star schema by normalizing dimension tables into multiple related sub-dimension tables, creating a hierarchy of detailed categories branching outward like a snowflake. A star schema (D) has a central fact table with flat, denormalized dimensions - no subcategory breakdown. A hierarchical schema (B) describes a tree-structure database model. A relational schema (A) is a general term, not specific to this pattern.
Topics
Community Discussion
No community discussion yet for this question.