CAF-3 · Chapter 6 · Question 12 of 15
To save storage space and ensure stricter data integrity, a database engineer modifies a Star Schema by breaking down the 'Product' dimension table into further sub-tables (e.g., separating 'Product Category' into its own table). This normalized branching structure is a:
Test yourself: pick an answer
Reveal answer & explanation
Correct answer: D) Snowflake Schema
Explanation
The Snowflake Schema is an extension of the Star Schema where the dimension tables are highly normalized into multiple related sub-tables, resembling a snowflake's branching pattern
More Data Warehouse Schemas & Data Marts MCQs
- Q14What is the primary trade-off between choosing a Star Schema versus a Snowflake Schema for a data warehouse?
- Q15The Marketing Department of a large corporation finds the main enterprise data warehouse too massive and slow for their specific daily…
- Q1An organization’s customer database frequently suffers from update anomalies because the same customer’s address is stored in multiple…
- Q2A bank's database table stores a customer's 'Phone Number' attribute. However, several customers have submitted two or three phone…
- Q3A retail company’s 'Order Details' table uses a composite primary key consisting of both OrderID and ProductID. However, the attribute…