Which schema design uses a central fact table with denormalized dimensions?

Enhance your skills with the CompTIA Data+ Certification Test. Engage with flashcards, tackle challenging multiple choice questions, complete with hints and explanations. Get yourself exam-ready now!

Multiple Choice

Which schema design uses a central fact table with denormalized dimensions?

A star schema uses a central fact table connected to denormalized dimension tables. The fact table holds the measurable metrics (like sales, quantity) and each dimension table (such as product, date, store) is wide and non-normalized, containing all relevant attributes. This denormalization makes queries simpler and faster by reducing the number of joins, which is ideal for typical BI reporting. Snowflake schema normalizes dimensions into multiple related tables, increasing joins. Galaxy schema has multiple fact tables sharing dimensions, which is a different pattern. Columnar schema refers to storage format rather than the schema shape.

A star schema uses a central fact table connected to denormalized dimension tables. The fact table holds the measurable metrics (like sales, quantity) and each dimension table (such as product, date, store) is wide and non-normalized, containing all relevant attributes. This denormalization makes queries simpler and faster by reducing the number of joins, which is ideal for typical BI reporting.

Snowflake schema normalizes dimensions into multiple related tables, increasing joins. Galaxy schema has multiple fact tables sharing dimensions, which is a different pattern. Columnar schema refers to storage format rather than the schema shape.

More practice questions