Exam Associate Data Practitioner topic 1 question 14 discussion

Actual exam question from Google's Associate Data Practitioner

Question #: 14
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?

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.

Show Suggested Answer

Suggested Answer: A 🗳️

by n2183712847 at Feb. 27, 2025, 6:44 p.m.

Comments

Submit Cancel

n2183712847

2 months ago

Selected Answer: A

The best option is A. Create a materialized view in BigQuery that uses the SUM( ) function and the DATE_SUB( ) function. Materialized views provide the efficiency of pre-computation, automatic updates, and are directly usable in Looker Studio, making them the ideal choice for creating an automated and performant monthly inventory report. Options B, C, and D are either manual, technically inaccurate in their description, or less efficient than leveraging the power of materialized views for this reporting task.

upvoted 2 times

...

Exam Associate Data Practitioner All Questions

View all questions & answers for the Associate Data Practitioner exam

Exam Associate Data Practitioner topic 1 question 14 discussion

Comments

n2183712847

SY0-701