What is a star schema?
- A A central fact table surrounded by denormalised dimension tables
- B A fully normalised set of tables
- C A single flat table
- D A hierarchy of nested tables
Answer
A central fact table surrounded by denormalised dimension tables
Its simplicity means fewer joins and better query performance, which is why it remains the dominant dimensional modelling pattern.





