Google Cloud Professional Data Engineer PDE — Topic 1 Question 103

Question

You have a data stored in BigQuery. The data in the BigQuery dataset must be highly available. You need to define a storage, backup, and recovery strategy of this data that minimizes cost. How should you configure the BigQuery table that have a recovery point objective (RPO) of 30 days?

Accepted Answer

Correct answer: B. The correct answer is B. Option B: Set the BigQuery dataset to be regional. Create a scheduled query to make copies of the data to tables suffixed with the time of the backup. In the event of an emergency, use the backup copy of the table. BigQuery is a serverless, petabyte-scale data warehouse for fast SQL analytics with no infrastructure to manage. By spanning multiple Availability Zones / adding redundancy, this option provides the high availability and resilience required.

Google Cloud Professional Data Engineer PDE — Question 103