What is an aggregate table used for?
- A Pre-summarising fact data at a coarser grain to speed common queries
- B Storing raw transactions
- C Holding dimension attributes
- D Logging pipeline runs
Answer
Pre-summarising fact data at a coarser grain to speed common queries
The trade-off is maintenance: every aggregate must be kept consistent with the underlying facts as they change.





