Google Cloud Professional Data Engineer — Question 315

You are using BigQuery and Data Studio to design a customer-facing dashboard that displays large quantities of aggregated data. You expect a high volume of concurrent users. You need to optimize the dashboard to provide quick visualizations with minimal latency. What should you do?

Answer options

• 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.

Correct answer: A

Explanation

The correct choice is A because using materialized views allows for pre-computed results that can be quickly accessed, reducing latency significantly. Options B and D involve views that do not optimize performance to the same extent, while option C, which uses streaming data, may lead to increased latency due to real-time processing demands.