Google Cloud Professional Data Engineer — Question 137

You are using BigQuery with a multi-region dataset that includes a table with the daily sales volumes. This table is updated multiple times per day. You need to protect your sales table in case of regional failures with a recovery point objective (RPO) of less than 24 hours, while keeping costs to a minimum. What should you do?

Answer options

• 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.

Correct answer: A

Explanation

Option A is correct because exporting the table daily to a dual or multi-region Cloud Storage bucket provides a reliable backup solution while keeping costs down. Option B may incur higher costs and does not ensure the same level of redundancy as option A. Option C, while useful, does not provide a backup in the same way and may not meet the RPO requirement. Option D could increase complexity and costs without providing significant benefits over option A.