Exam Associate Data Practitioner topic 1 question 35 discussion

Actual exam question from Google's Associate Data Practitioner

Question #: 35
Topic #: 1

[All Associate Data Practitioner Questions]

Your organization uses a BigQuery table that is partitioned by ingestion time. You need to remove data that is older than one year to reduce your organization’s storage costs. You want to use the most efficient approach while minimizing cost. What should you do?

A. Create a scheduled query that periodically runs an update statement in SQL that sets the “deleted" column to “yes” for data that is more than one year old. Create a view that filters out rows that have been marked deleted.
B. Create a view that filters out rows that are older than one year.
C. Require users to specify a partition filter using the alter table statement in SQL.
D. Set the table partition expiration period to one year using the ALTER TABLE statement in SQL.

Show Suggested Answer

Suggested Answer: D 🗳️

by n2183712847 at Feb. 27, 2025, 5:22 p.m.

Comments

Submit Cancel

n2183712847

3 months, 1 week ago

Selected Answer: D

D. is the only one that has a partition expiration, meaning deletion. the other answer choices just filter views.

upvoted 2 times

...

n2183712847

3 months, 3 weeks ago

Selected Answer: D

The most efficient and cost-effective solution is D. Set the table partition expiration period to one year using the ALTER TABLE statement in SQL. Partition expiration is a built-in BigQuery feature specifically designed to automatically delete old partitions, directly reducing storage costs and requiring minimal effort. Options A and B (soft delete and views) do not reduce storage costs; they only filter or mark data without removing it. Option C (requiring partition filters) is about query optimization, not data removal or storage cost reduction. Therefore, Option D is the only option that directly and effectively addresses the requirement of removing old data to minimize storage costs in a BigQuery partitioned table.

upvoted 2 times

...