Answer-first summary for fast verification
Answer: Configure the BigQuery dataset for multi-regional storage and establish a scheduled query to duplicate data into timestamp-suffixed tables for emergency backups.
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.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
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.
No comments yet.