Answer-first summary for fast verification
Answer: Use BigQuery BI Engine with materialized views.
The correct answer is A. Using BigQuery BI Engine with materialized views optimizes the dashboard by precomputing query results, which are stored in memory. This reduces query time and enhances performance, particularly for common and repeated queries. Materialized views periodically cache the results, enabling faster retrieval of aggregated data and providing quick visualizations.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
As a data engineer tasked with developing a customer-facing dashboard using BigQuery and Data Studio, you are responsible for visualizing extensive sets of aggregated data. Considering the anticipated high volume of concurrent users, it is crucial to optimize the dashboard to ensure fast visual loading times and minimal latency. What measures should you implement to achieve this goal?
A
Use BigQuery BI Engine with materialized views.
B
Use BigQuery BI Engine with logical views.
C
Use BigQuery BI Engine with streaming data.
D
Use BigQuery BI Engine with authorized views.
No comments yet.