CAF-3 · Chapter 6 · Question 14 of 15
What is the primary trade-off between choosing a Star Schema versus a Snowflake Schema for a data warehouse?
Test yourself: pick an answer
Reveal answer & explanation
Correct answer: B) A Star schema prioritizes fast query speed at the cost of storage efficiency, while a Snowflake schema saves space but slows down queries due to multiple joins.
Explanation
Star schemas prioritize query speed over storage efficiency because they are denormalized. Snowflake schemas save storage space through normalization, but the complex joins slow down query performance
More Data Warehouse Schemas & Data Marts MCQs
- 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…
- Q4In an employee database, the EmployeeID is the primary key. The table includes a DepartmentID column and a DepartmentLocation column. The…
- Q5When designing a database, an IT team debates whether to fully normalize the data or leave it partially denormalized. What is the primary…