ASSOCIATE-DATA-PRACTITIONER practice question 19 of 25

You work for a financial organization that stores transaction data in BigQuery. Your organization has a regulatory requirement to retain data for a minimum of seven years for auditing purposes. You need to ensure that the data is retained for seven years using an efficient and cost-optimized approach. What should you do?

Full set: 106 questions
Answer options
A: Create a partition by transaction date, and set the partition expiration policy to seven years.
B: Set the table-level retention policy in BigQuery to seven years. Correct answer
C: Set the dataset-level retention policy in BigQuery to seven years.
D: Export the BigQuery tables to Cloud Storage daily, and enforce a lifecycle management policy that has a seven-year retention rule.
Correct Answer:
B. Set the table-level retention policy in BigQuery to seven years.
Explanation

Setting a table-level retention policy in BigQuery to seven years is the most efficient and cost- optimized solution to meet the regulatory requirement. A table-level retention policy ensures that the data cannot be deleted or overwritten before the specified retention period expires, providing compliance with auditing requirements while keeping the data within BigQuery for easy access and analysis. This approach avoids the complexity and additional costs of exporting data to Cloud Storage.

Scroll to Top