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