CAF-3 · Chapter 6 · Question 11 of 15
A data architect designs a schema for a new data warehouse. The design features a single central 'Fact Table' containing total sales figures, which is directly linked to denormalized 'Dimension Tables' (like Time, Product, and Customer) radiating outward. This describes a:
Test yourself: pick an answer
Reveal answer & explanation
Correct answer: B) Star Schema
Explanation
The Star Schema is the most basic and widely used structure, featuring a central fact table surrounded by denormalized dimension tables, visually resembling a star
More Data Warehouse Schemas & Data Marts MCQs
- Q13An enterprise wants to integrate its 'Sales' process and its 'Inventory' process into one analytical model. The database designer creates…
- 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…