Google Professional Data Engineer
Get started today
Ultimate access to all questions.
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?
Explanation:
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.