Explanation:
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.
Ultimate access to all questions.
No comments yet.
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.