Google Professional Data Engineer

Get started today

Ultimate access to all questions.

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

Explanation:

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 (0)

No comments yet.

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

Use BigQuery BI Engine with materialized views

69.2%

Use BigQuery BI Engine with streaming data.

23.1%

Use BigQuery BI Engine with authorized views

7.7%

Use BigQuery BI Engine with logical reviews