Google Cloud Professional Data Engineer PDE — Topic 1 Question 316

Question

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?

Accepted Answer

Correct answer: C. The correct answer is C. Option C: Build materialized views on top of the sales table to aggregate data at the day and month level.

Google Cloud Professional Data Engineer PDE — Question 316