Answer-first summary for fast verification
Answer: Set the BigQuery dataset to be regional. Create a scheduled query to make copies of the data to tables suffixed with the time of the backup. In the event of an emergency, use the backup copy of the table.
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
Author: LeetQuiz Editorial Team
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?
A
Set the BigQuery dataset to be regional. In the event of an emergency, use a point-in-time snapshot to recover the data.
B
Set the BigQuery dataset to be regional. Create a scheduled query to make copies of the data to tables suffixed with the time of the backup. In the event of an emergency, use the backup copy of the table.
C
Set the BigQuery dataset to be multi-regional. In the event of an emergency, use a point-in-time snapshot to recover the data.
D
Set the BigQuery dataset to be multi-regional. Create a scheduled query to make copies of the data to tables suffixed with the time of the backup. In the event of an emergency, use the backup copy of the table.
No comments yet.