Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
To optimize performance for aggregate queries in a data lakehouse, which strategy offers the optimal balance between storage cost and query speed?
A
Only store raw data, relying on the compute layer to perform real-time aggregations.
B
Pre-compute and store all possible aggregations in separate tables.
C
Implement cube and rollup structures to pre-aggregate data along multiple dimensions.
D
Utilize materialized views to dynamically compute common aggregations.
