Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Google Associate Data Practitioner Exam - Topic 1 Question 24 Discussion

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?
A) Create a materialized view in BigQuery that uses the SUM( ) function and the DATE_SUB( ) function.
B) Create 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.
C) Create a BigQuery table that uses the SUM( ) function and the _PARTITIONDATE filter.
D) Create a BigQuery table that uses the SUM( ) function and the DATE_DIFF( ) function.

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?

Show Suggested Answer Hide 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:

0/2000 characters
Submit Cancel
Heidy
1 month ago
I feel like using _PARTITIONDATE in option C could be beneficial for performance, but I can't recall if it fits the requirement for the most recent month.
upvoted 0 times
...
Alayna
1 month ago
I remember practicing with saved queries, so option B might be the right choice since it allows for re-running the query monthly.
upvoted 0 times
...
Hobert
1 month ago
I think option A sounds familiar, but I'm not entirely sure how materialized views work in this context.
upvoted 0 times
...

Save Cancel