Google Professional Data Engineer Question 30
Select 3Google Cloud PlatformYour organization is running a critical database system on Google Cloud, and it must remain operational even in the event of a regional outage. You have been asked to design a disaster recovery and fault-tolerant solution using Google Cloud's managed services. Which of the following steps should you implement to meet the requirement?
- A
Configure a multi-region Cloud Spanner instance to ensure data availability across multiple regions.
- B
Use a zonal Google Cloud SQL instance with frequent backups stored in the same zone.
- C
Set up a BigQuery dataset in a multi-region location to ensure analytics capabilities are unaffected by a regional outage.
- D
Implement a cross-region replication strategy for Google Cloud Storage buckets to protect stored data.
- E
Rely solely on Google Cloud's SLA for fault tolerance without configuring additional redundancy.
Show answer and explanation
Correct answers: A, C, D
Explanation
To achieve disaster recovery and fault tolerance, it is critical to leverage Google Cloud's managed services and configure them to span multiple regions. Multi-region configurations for services like Cloud Spanner and BigQuery ensure high availability. Additionally, cross-region replication for Google Cloud Storage provides resilience against regional outages. Single-zone setups or reliance solely on SLAs do not meet disaster recovery requirements.
- A. Correct.
Correct. Configuring a multi-region Cloud Spanner instance ensures high availability and fault tolerance, as the data is automatically replicated across multiple regions.
- B. Incorrect.
Incorrect. Using a zonal Cloud SQL instance with backups stored in the same zone does not provide protection against regional outages, as both the instance and backups would be impacted by a zone-level failure.
- C. Correct.
Correct. Storing BigQuery datasets in a multi-region location ensures that the data remains available even if one region becomes unavailable.
- D. Correct.
Correct. Cross-region replication for Google Cloud Storage buckets ensures that data remains accessible even in the event of a regional outage.
- E. Incorrect.
Incorrect. Relying solely on Google's SLA does not offer a proactive strategy for disaster recovery or fault tolerance, as it does not address data replication or regional outages.