Topic 1 Question 316

Professional Data Engineer

Topic 1 Question 316
You are administering a BigQuery on-demand environment. Your business intelligence tool is submitting hundreds of queries each day that aggregate a large (50 TB) sales history fact table at the day and month levels. These queries have a slow response time and are exceeding cost expectations. You need to decrease response time, lower query costs, and minimize maintenance. What should you do?
- Build authorized views on top of the sales table to aggregate data at the day and month level.
- Enable BI Engine and add your sales table as a preferred table.
- Build materialized views on top of the sales table to aggregate data at the day and month level.
- Create a scheduled query to build sales day and sales month aggregate tables on an hourly basis.
ユーザの投票
コメント(2)
- 正解だと思う選択肢: C
  C is the answer. Materialized Views:
  
  Materialized views in BigQuery are precomputed views that store the results of a query, allowing for much faster query execution because BigQuery doesn’t need to recompute the results each time the query is run. The results are stored in a persistent table, which significantly improves performance for repeated queries that aggregate the same data. In this case, you can create materialized views that aggregate the sales data at the day and month levels. This will reduce the amount of data that needs to be processed for each query and speed up the response time. Materialized views also lower costs because BigQuery only scans the precomputed data in the materialized view, rather than the full 50 TB sales history table.
  
  👍 2
  hussain.sain2024/12/27
- 正解だと思う選択肢: C
  C. Build materialized views on top of the sales table to aggregate data at the day and month level.
  
  Materialized views are precomputed views that cache the results of a query, which can significantly improve query performance and reduce costs by avoiding repeated computation. They automatically update with changes to the base table, ensuring data freshness without additional maintenance.
  
  https://cloud.google.com/bigquery/docs/materialized-views-intro
  
  👍 2
  Pime132025/01/06
シャッフルモード

ユーザの投票

コメント(2)