Answer-first summary for fast verification
Answer: Use BigQuery BI Engine with streaming data.
**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
Author: LeetQuiz .
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?
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
No comments yet.