Câu 30: Associate Data Practitioner: Google Cloud Certified - Associate Data Practitioner

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?

1. 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.
2. B. Create a view that filters out rows that are older than one year.
3. C. Require users to specify a partition filter using the alter table statement in SQL.
4. D. Set the table partition expiration period to one year using the ALTER TABLE statement in SQL. — đáp án hiện tại