In a business-intelligence data warehouse, you need a schema that stores sales facts in one table and links them to several denormalized dimension tables-such as Product, Time, and Store-that do not join to one another. Which schema design best matches this requirement?
The star design (often called a star schema) uses a single fact table surrounded by denormalized dimension tables that connect only to the fact table, not to each other. This simple layout speeds up analytical queries, while a snowflake schema normalizes dimension tables, increasing joins and complexity. The other listed options are not standard dimensional models that provide this structure.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is a star schema?
Open an interactive chat with Bash
What is the difference between a star schema and a snowflake schema?