Answer-first summary for fast verification
Answer: Schedule a daily export of the table to a Cloud Storage dual or multi-region bucket.
The correct answer is A: Schedule a daily export of the table to a Cloud Storage dual or multi-region bucket. Exporting the data to a Google Cloud Storage bucket that is either dual or multi-regional ensures that your backups are stored in a different geographic location, which is critical for protecting against hard regional failures. This provides high durability and is a cost-effective solution compared to maintaining active replicas of data in multiple regions. The export process can be automated and scheduled to occur daily, aligning with your RPO of less than 24 hours. In the event of a regional failure, the data can be restored from the Cloud Storage backup to another operational BigQuery region, ensuring continuity of operations.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
You are working with Google BigQuery, managing a multi-region dataset that includes a table recording daily sales volumes. This sales table is updated several times throughout each day. To ensure you can recover your sales data in the event of regional failures while maintaining a recovery point objective (RPO) of under 24 hours and keeping costs as low as possible, what steps should you take to protect your table?
A
Schedule a daily export of the table to a Cloud Storage dual or multi-region bucket.
B
Schedule a daily copy of the dataset to a backup region.
C
Schedule a daily BigQuery snapshot of the table.
D
Modify ETL job to load the data into both the current and another backup region.
No comments yet.