Answer-first summary for fast verification
Answer: 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.
A materialized view-like strategy, such as creating pre-aggregated Delta tables, is ideal for the dashboard because it provides quick access to data that does not change frequently, reducing the load on the cluster and improving response times for end-users. Temporary views are better suited for real-time, ad-hoc analysis tasks where the data does not need to be stored persistently, allowing for flexibility and immediate insights without affecting storage costs or requiring data refresh mechanisms. This approach leverages the strengths of both strategies to meet different needs within the Databricks environment.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
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.