Google Professional Cloud Database Engineer Question 22
Select 2Google Cloud PlatformYour company is running a mission-critical application on Cloud SQL for PostgreSQL. The application requires minimal downtime and data loss in case of regional outages. You need to design a high availability and disaster recovery solution that meets these requirements while keeping operational overhead low. What should you do?
- A
Enable high availability (HA) for the Cloud SQL instance and configure automated backups.
- B
Configure a read replica in a different region.
- C
Set up a cross-region failover replica for the Cloud SQL instance.
- D
Use Memorystore for caching to reduce database load during outages.
- E
Configure a scheduled export of the database to Cloud Storage.
Show answer and explanation
Correct answers: A, C
Explanation
For mission-critical applications with strict high availability and disaster recovery requirements, enabling HA ensures minimal downtime within a region, while a cross-region failover replica provides resilience against regional outages. Together, these solutions address both availability and disaster recovery needs.
- A. Correct.
Enabling high availability (HA) ensures automatic failover to a standby instance within the same region, reducing downtime during regional issues. Automated backups ensure recovery from data loss scenarios.
- B. Incorrect.
Configuring a read replica in a different region provides read scalability but does not support automatic failover, making it unsuitable for disaster recovery in this scenario.
- C. Correct.
Setting up a cross-region failover replica ensures that the database can fail over to a different region during a regional outage, achieving high availability and disaster recovery.
- D. Incorrect.
Using Memorystore for caching can improve application performance but does not directly address high availability or disaster recovery for the database.
- E. Incorrect.
Scheduled exports to Cloud Storage provide point-in-time recovery options but do not provide the immediate failover needed for high availability or disaster recovery.