Question 20 of 72
Single answerYou 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?
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.
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.
<p>B.Set the table-level retention policy in BigQuery to seven years.</p>
The correct answer is highlighted above. Review the wording carefully, then use the next question to continue building your understanding of Google certification topics.