Associate Data Practitioner

By Google · Question Mode

QuestionQ62

Data Management

You work for a financial organization that keeps transaction data in BigQuery. The organization has a regulatory requirement to retain data for at least seven years for audit purposes. You must ensure the data is kept for seven years in an efficient, cost-optimized way. What should you do?

Explanation

For a date-partitioned BigQuery table, partition expiration is calculated from each partition’s date. Setting it to seven years retains every transaction-date partition for that period and automatically removes it afterward. Partitioning also enables partition pruning, reducing the data scanned by queries, while older retained data can receive BigQuery long-term storage pricing. A whole-table expiration does not provide record-by-record seven-year retention when a table contains transactions from different dates.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!