Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
When deciding between a temporary view and a materialized view-like strategy for aggregating large volumes of data for a daily updated dashboard with minimal latency, which approach is most suitable?
A
Use a temporary view for both the dashboard and historical data analysis to maximize data freshness and minimize storage costs.
B
Implement a materialized view-like strategy for the dashboard to ensure quick access to pre-aggregated data, and use a temporary view for ad-hoc, real-time analysis tasks that do not require data persistence.
C
Implement a materialized view-like strategy for both the dashboard and historical data analysis to reduce the computational load on the Databricks cluster.
D
Use a temporary view for the dashboard to ensure data is always up-to-date with real-time transformations, and implement a materialized view-like strategy for historical data analysis where data latency is acceptable.
