Google Cloud Professional Data Engineer — Question 305

You have a data stored in BigQuery. The data in the BigQuery dataset must be highly available. You need to define a storage, backup, and recovery strategy of this data that minimizes cost. How should you configure the BigQuery table that have a recovery point objective (RPO) of 30 days?

Answer options

• 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.

Correct answer: C

Explanation

The correct answer is C because setting the dataset to be multi-regional provides higher availability and redundancy across multiple locations, ensuring recovery using point-in-time snapshots aligns with the 30-day RPO. The other options either limit the dataset to regional storage, which does not offer the same level of availability and resilience, or involve unnecessary complexity with scheduled backups when point-in-time snapshots are sufficient.