Answer-first summary for fast verification
Answer: Adopt BigQuery BI Engine with materialized views.
**Correct Answer: D. Adopt BigQuery BI Engine with materialized views.** - Materialized views in BigQuery BI Engine store precomputed query results, facilitating quicker data retrieval and lower latency for visualizations. - This approach is ideal for dashboards requiring fast visualizations with minimal latency, especially when processing large volumes of aggregated data. - It is particularly effective for scenarios involving a high number of concurrent users and the need for real-time insights in customer-facing dashboards. **Why the other options are incorrect:** - **A. Utilize BigQuery BI Engine with logical views.** Logical views do not store precomputed results, executing queries at runtime, which may not suffice for achieving minimal latency in visualizations. - **B. Implement BigQuery BI Engine with streaming data.** Streaming data is tailored for real-time data ingestion and processing, not for optimizing dashboard performance with precomputed results for aggregated data. - **C. Apply BigQuery BI Engine with authorized views.** Authorized views manage data access but do not directly enhance dashboard performance for quick visualizations with minimal latency.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
When designing a customer-facing dashboard in BigQuery and Data Studio to display aggregated data for a high volume of concurrent users, what is the best method to ensure fast visualizations with minimal latency?
A
Utilize BigQuery BI Engine with logical views.
B
Implement BigQuery BI Engine with streaming data.
C
Apply BigQuery BI Engine with authorized views.
D
Adopt BigQuery BI Engine with materialized views.