Google Professional Data Engineer
Get started today
Ultimate access to all questions.
Ultimate access to all questions.
You are managing data stored in BigQuery and it is crucial that this dataset remains highly available. To meet business continuity requirements, you need to define an effective strategy for storage, backup, and recovery that also minimizes costs. Specifically, you need to configure the BigQuery table in such a way that it ensures a recovery point objective (RPO) of 30 days. How should you set up this configuration?
Explanation:
The correct answer is B. Although option A is cheaper, BigQuery's time travel feature only allows for point-in-time recovery up to 7 days ago. To meet a recovery point objective (RPO) of 30 days, you need a more robust backup strategy. You should create a scheduled query to make copies of the data to tables suffixed with the time of the backup. This approach allows you to retain the data for 30 days while maintaining a regional dataset to minimize costs. For more information, refer to: https://cloud.google.com/bigquery/docs/table-snapshots-intro