Topic 1 Question 35
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?
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.
Create a view that filters out rows that are older than one year.
Require users to specify a partition filter using the alter table statement in SQL.
Set the table partition expiration period to one year using the ALTER TABLE statement in SQL.
ユーザの投票
コメント(2)
- 正解だと思う選択肢: 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.
👍 1n21837128472025/02/27 - 正解だと思う選択肢: D
D. is the only one that has a partition expiration, meaning deletion. the other answer choices just filter views.
👍 1n21837128472025/03/08
シャッフルモード