Google Associate Data Practitioner Exam - Topic 1 Question 24 Discussion

Actual exam question for Google's Associate Data Practitioner exam

Question #: 24
Topic #: 1

[All Associate Data Practitioner Questions]

Your team wants to create a monthly report to analyze inventory data that is updated daily. You need to aggregate the inventory counts by using only the most recent month of data, and save the results to be used in a Looker Studio dashboard. What should you do?

ACreate a materialized view in BigQuery that uses the SUM( ) function and the DATE_SUB( ) function.

BCreate a saved query in the BigQuery console that uses the SUM( ) function and the DATE_SUB( ) function. Re-run the saved query every month, and save the results to a BigQuery table.

CCreate a BigQuery table that uses the SUM( ) function and the _PARTITIONDATE filter.

DCreate a BigQuery table that uses the SUM( ) function and the DATE_DIFF( ) function.

Show Suggested Answer

Suggested Answer: A

Creating a materialized view in BigQuery with the SUM() function and the DATE_SUB() function is the best approach. Materialized views allow you to pre-aggregate and cache query results, making them efficient for repeated access, such as monthly reporting. By using the DATE_SUB() function, you can filter the inventory data to include only the most recent month. This approach ensures that the aggregation is up-to-date with minimal latency and provides efficient integration with Looker Studio for dashboarding.

by Bethanie at May 07, 2026, 12:44 PM

Limited Time Offer

25%

Off

Get Premium Associate Data Practitioner Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!