Question 267 of 307
Single answerYou 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?
ABuild authorized views on top of the sales table to aggregate data at the day and month level.
BEnable BI Engine and add your sales table as a preferred table.
✓CBuild materialized views on top of the sales table to aggregate data at the day and month level.
DCreate a scheduled query to build sales day and sales month aggregate tables on an hourly basis.
✓
Correct Answer: C
Build materialized views on top of the sales table to aggregate data at the day and month level.
▥
Explanation
The correct answer is highlighted above. Review the wording carefully, then use the next question to continue building your understanding of Google certification topics.