Google Professional Cloud Database Engineer Question 21
Select 3Google Cloud PlatformYour organization needs to design a highly available and disaster-resilient architecture for a mission-critical PostgreSQL database hosted on Google Cloud. The requirements are as follows: The database must have automated failover, data replication across regions, and a Recovery Point Objective (RPO) of less than 1 minute. Which of the following options would meet these requirements?
- A
Set up a Cloud SQL instance with high availability configuration and enable read replicas in a different region.
- B
Use a Cloud Spanner instance with multi-region configuration for automatic replication and failover.
- C
Deploy PostgreSQL on Compute Engine VMs with persistent disks and configure cross-region replication manually.
- D
Utilize Cloud SQL with cross-region failover replicas and configure binary log replication.
- E
Implement a custom PostgreSQL deployment on Kubernetes Engine with a multi-zone configuration.
Show answer and explanation
Correct answers: A, B, D
Explanation
To meet the requirements of high availability, disaster recovery, and an RPO of less than 1 minute, you need solutions that provide automated failover and cross-region replication. Cloud SQL with high availability and cross-region failover replicas, as well as Cloud Spanner with its multi-region configuration, are suitable options. Manually configuring replication or using custom deployments on Compute Engine or Kubernetes Engine can increase complexity and may not meet the strict RPO requirement.
- A. Correct.
This option meets the requirement of high availability with automated failover using Cloud SQL's high availability configuration. By enabling read replicas in a different region, it also ensures disaster recovery with RPO under 1 minute.
- B. Correct.
Cloud Spanner is a fully managed, highly available database that supports multi-region configurations with automatic replication and failover, making it an ideal choice for the given requirements.
- C. Incorrect.
While deploying PostgreSQL on Compute Engine VMs allows customization, cross-region replication must be configured manually, which can increase complexity and may not guarantee an RPO of less than 1 minute.
- D. Correct.
Cloud SQL with cross-region failover replicas and binary log replication provides automated failover and ensures data replication across regions, meeting the high availability and disaster recovery requirements.
- E. Incorrect.
A custom PostgreSQL deployment on Kubernetes Engine with multi-zone configuration does not inherently provide cross-region disaster recovery or an RPO of less than 1 minute without significant additional configuration.