Google Professional Data Engineer
Get started today
Ultimate access to all questions.
Deep dive into the quiz with AI chat providers.
We prepare a focused prompt with your quiz and certificate details so each AI can offer a more tailored, in-depth explanation.
NO.19 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?
Real Exam
Community
LLeetQuiz
A
Use BigQuery BI Engine with materialized views
B
Use BigQuery BI Engine with streaming data.
C
Use BigQuery BI Engine with authorized views
D
Use BigQuery BI Engine with logical reviews
Explanation:
Explanation:
BigQuery BI Engine is an in-memory analysis service that accelerates SQL queries in BigQuery and provides sub-second query response time and high concurrency. When dealing with streaming data and high volume concurrent users, BigQuery BI Engine with streaming data is the optimal choice because:
- Streaming data allows real-time data ingestion and processing
- BI Engine provides fast, in-memory query acceleration
- The combination enables quick visualizations with minimal latency for concurrent users
- Materialized views (option A) are better for pre-computed aggregations but not specifically for streaming scenarios
- Authorized views (option C) are for access control, not performance optimization
- Logical reviews (option D) is not a valid BigQuery feature
Comments
Loading comments...