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 **D. Schedule a daily export of the table to a Cloud Storage dual or multi-region bucket.** This approach ensures your data is stored in a separate, resilient location, achieving an RPO of less than 24 hours by backing up data daily. Using a dual or multi-region bucket in Cloud Storage guarantees data replication across multiple regions, offering high availability and durability against regional failures, all while minimizing costs by exporting only necessary data. - **Option A** increases complexity and costs by maintaining duplicate data copies in different regions. - **Option B** is less cost-effective for frequently updated data and more suited for consistent, point-in-time backups. - **Option C** may not meet the RPO requirement efficiently due to potential delays in copying large datasets and higher costs.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
In the scenario of using BigQuery for a multi-region dataset that includes a table updated several times daily with daily sales volumes, what is the most cost-effective method to protect the sales table against regional failures, ensuring a Recovery Point Objective (RPO) of under 24 hours?
A
Modify the ETL job to load the data into both the current and another backup region.
B
Schedule a daily BigQuery snapshot of the table.
C
Schedule a daily copy of the dataset to a backup region.
D
Schedule a daily export of the table to a Cloud Storage dual or multi-region bucket.
No comments yet.