Databricks Certified Data Engineer - Professional
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
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.