Trang chủ Professional Data Engineer 310 / 343
Quay lại bộ đề
Question #310 Topic 1
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?
A
Build authorized views on top of the sales table to aggregate data at the day and month level.
B
Enable BI Engine and add your sales table as a preferred table.
C
Build materialized views on top of the sales table to aggregate data at the day and month level.
D
Create a scheduled query to build sales day and sales month aggregate tables on an hourly basis.