Google Professional Data Engineer Question 277
Select 2Google Cloud PlatformYou are designing a high-availability architecture for an e-commerce application that uses Cloud SQL as its primary database. The application must remain operational during regional outages, and data loss must be minimized. Which actions should you take to meet these requirements?
- A
Enable cross-region replicas for Cloud SQL.
- B
Configure automated backups and point-in-time recovery for Cloud SQL.
- C
Rely on a single-zone instance for Cloud SQL to simplify deployment.
- D
Set up a read replica in the same region as the primary instance.
- E
Implement a failover replica for Cloud SQL in a different region.
Show answer and explanation
Correct answers: A, E
Explanation
To ensure high availability for Cloud SQL during regional outages, you must implement cross-region replication to maintain a synchronized copy of data in another region. Additionally, a failover replica in a different region allows for automatic promotion to primary in case of a regional failure, minimizing downtime and preventing data loss. Other options like same-region replicas or single-zone instances do not address the scenario's requirements.
- A. Correct.
Enabling cross-region replicas ensures that there is a synchronized copy of your data in a different region, which helps maintain availability during regional outages.
- B. Incorrect.
Automated backups and point-in-time recovery are useful for recovering from data corruption or accidental deletion but do not address high availability during regional outages.
- C. Incorrect.
Relying on a single-zone instance introduces a single point of failure and does not provide regional failover capabilities.
- D. Incorrect.
A read replica in the same region does not protect against regional outages as it is still dependent on the same region as the primary instance.
- E. Correct.
A failover replica in a different region provides high availability and ensures minimal downtime during a regional outage by promoting the replica to the primary instance.