Topic 1 Question 199
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?
Use BigQuery BI Engine with materialized views.
Use BigQuery BI Engine with logical views.
Use BigQuery BI Engine with streaming data.
Use BigQuery BI Engine with authorized views.
ユーザの投票
コメント(6)
- 正解だと思う選択肢: A
A. Use BigQuery BI Engine with materialized views.
👍 8AWSandeep2022/09/02 - 正解だと思う選択肢: A
A is the answer.
https://cloud.google.com/bigquery/docs/materialized-views-intro In BigQuery, materialized views are precomputed views that periodically cache the results of a query for increased performance and efficiency. BigQuery leverages precomputed results from materialized views and whenever possible reads only delta changes from the base tables to compute up-to-date results. Materialized views can be queried directly or can be used by the BigQuery optimizer to process queries to the base tables.
Queries that use materialized views are generally faster and consume fewer resources than queries that retrieve the same data only from the base tables. Materialized views can significantly improve the performance of workloads that have the characteristic of common and repeated queries.
👍 4zellck2022/11/28 - 正解だと思う選択肢: A
use materialized views is better option here
👍 3MounicaN2022/09/10
シャッフルモード