Google Professional Data Engineer Question 29
Select 3Google Cloud PlatformYour organization has a critical data processing pipeline running on Google Cloud that requires high availability and disaster recovery. The pipeline processes data using BigQuery and Google Cloud Storage. To ensure fault tolerance and meet aggressive recovery point objectives (RPO) and recovery time objectives (RTO), which of the following strategies should you implement?
- A
Enable BigQuery table snapshots to frequently back up your data.
- B
Configure multi-regional storage buckets for Google Cloud Storage.
- C
Set up a second instance of the pipeline in a different region with load balancing.
- D
Use a managed instance group (MIG) in a single zone for the processing infrastructure.
- E
Implement automated export of BigQuery data to Cloud Storage in a different region.
Show answer and explanation
Correct answers: A, B, E
Explanation
To ensure disaster recovery and fault tolerance, it is critical to back up and replicate data across regions. BigQuery table snapshots and exporting BigQuery data to a different region provide mechanisms to recover data in case of failures. Multi-regional storage for Google Cloud Storage ensures that data is available even if one region experiences an outage. These strategies collectively address both RPO and RTO requirements while ensuring high availability of data.
- A. Correct.
Correct: BigQuery table snapshots allow you to create point-in-time backups of your data, providing a way to recover from data loss or corruption.
- B. Correct.
Correct: Multi-regional storage ensures redundancy across multiple regions, increasing fault tolerance and disaster recovery capabilities.
- C. Incorrect.
Incorrect: While setting up a second pipeline instance in another region improves availability, it is not directly tied to disaster recovery of data or fault tolerance for the existing pipeline.
- D. Incorrect.
Incorrect: Using a managed instance group in a single zone does not provide sufficient fault tolerance since it does not account for regional failures.
- E. Correct.
Correct: Exporting BigQuery data to Cloud Storage in a different region ensures that a secondary copy of your data is available in case of a regional failure.