Databases · Senior · Question 46 of 75
What is a star schema used for?
- ✓Correct answer: Analytics: a central fact table (e.g. sales) linked to dimension tables (date, product, customer)
- 2Storing graph data
- 3Replicating tables between regions
Explanation
It's denormalized on purpose for fast aggregations in data warehouses. Operational databases stay normalized.