Google Cloud Professional Data Engineer — Question 238

You are using BigQuery with a regional 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

The correct answer is A because exporting the table to a dual or multi-region Cloud Storage bucket ensures that the data is preserved and accessible even in the event of regional failures, while keeping costs lower than other options. Options B and D involve creating copies in another region, which could incur higher costs and potentially extend the RPO. Option C, while useful, does not provide the necessary protection against regional failures in an efficient manner.