What is the primary reason to compute aggregates in advance?
- A Repeated expensive scans are replaced by cheap lookups for common queries
- B It reduces raw storage
- C It improves data quality
- D It simplifies the schema
Answer
Repeated expensive scans are replaced by cheap lookups for common queries
The trade-off is keeping aggregates consistent with the underlying data as it changes, including for late-arriving records.





