Explanation:
The correct strategy is option D. Opting for multi-regional storage in BigQuery ensures data replication across multiple regions, enhancing availability. Implementing a scheduled query to create timestamp-suffixed table copies offers a reliable backup mechanism, allowing for data restoration in emergencies. This approach effectively meets the 30-day RPO requirement while optimizing costs. Option A falls short as regional storage limits data to a single region, increasing vulnerability to regional failures. Option B's reliance on scheduled queries for backups is less reliable and may incur higher storage costs. Option C's use of point-in-time snapshots risks data loss, as it may not capture the most recent data changes.
Ultimate access to all questions.
No comments yet.
To ensure high availability of critical data in a BigQuery dataset with a recovery point objective (RPO) of 30 days while minimizing costs, which storage, backup, and recovery strategy should you implement?
A
Configure the BigQuery dataset for regional storage and utilize point-in-time snapshots for emergency data recovery.
B
Configure the BigQuery dataset for regional storage and establish a scheduled query to duplicate data into timestamp-suffixed tables for emergency backups.
C
Configure the BigQuery dataset for multi-regional storage and utilize point-in-time snapshots for emergency data recovery.
D
Configure the BigQuery dataset for multi-regional storage and establish a scheduled query to duplicate data into timestamp-suffixed tables for emergency backups.