Google Professional Data Engineer
Get started today
Ultimate access to all questions.
Comments
Loading comments...
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.