Question 242 of 307
Single answerYou have a table that contains millions of rows of sales data, partitioned by date. Various applications and users query this data many times a minute. The query requires aggregating values by using AVG, MAX, and SUM, and does not require joining to other tables. The required aggregations are only computed over the past year of data, though you need to retain full historical data in the base tables. You want to ensure that the query results always include the latest data from the tables, while also reducing computation cost, maintenance overhead, and duration. What should you do?
✓ACreate a materialized view to aggregate the base table data. Include a filter clause to specify the last one year of partitions.
BCreate a materialized view to aggregate the base table data. Configure a partition expiration on the base table to retain only the last one year of partitions.
CCreate a view to aggregate the base table data. Include a filter clause to specify the last year of partitions.
DCreate a new table that aggregates the base table data. Include a filter clause to specify the last year of partitions. Set up a scheduled query to recreate the new table every hour.
✓
Correct Answer: A
Create a materialized view to aggregate the base table data. Include a filter clause to specify the last one year of partitions.
▥
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.