Google
PROFESSIONAL-DATA-ENGINEER · Question #265
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 tie…
The correct answer is A. Use BigQuery BI Engine with materialized views. Explanation/Reference: https://cloud.google.com/bigquery/docs/materialized-views-intro In BigQuery, materialized views are precomputed views that periodically cache the results of a query for increased performance and efficiency
Submitted by chen.hong· Mar 30, 2026Building and operationalizing data processing systems
Question
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 tie dashboard to provide quick visualizations with minimal latency. What should you do?
Options
- AUse BigQuery BI Engine with materialized views
- BUse BigQuery BI Engine with streaming data.
- CUse BigQuery Bl Engine with authorized views
- DUse BigQuery Bl Engine with logical reviews
How the community answered
(52 responses)- A73% (38)
- B8% (4)
- C4% (2)
- D15% (8)
Explanation
Explanation/Reference: https://cloud.google.com/bigquery/docs/materialized-views-intro In BigQuery, materialized views are precomputed views that periodically cache the results of a query for increased performance and efficiency
Topics
#BigQuery BI Engine#materialized views#Data Studio#concurrent users
Community Discussion
No community discussion yet for this question.