Google Cloud Professional Cloud Database Engineer — Question 69

You are designing a highly available (HA) Cloud SQL for PostgreSQL instance that will be used by 100 databases. Each database contains 80 tables that were migrated from your on-premises environment to Google Cloud. The applications that use these databases are located in multiple regions in the US, and you need to ensure that read and write operations have low latency. What should you do?

Answer options

• A. Deploy 2 Cloud SQL instances in the us-central1 region with HA enabled, and create read replicas in us-east1 and us-west1.
• B. Deploy 2 Cloud SQL instances in the us-central1 region, and create read replicas in us-east1 and us-west1.
• C. Deploy 4 Cloud SQL instances in the us-central1 region with HA enabled, and create read replicas in us-central1, us-east1, and us-west1.
• D. Deploy 4 Cloud SQL instances in the us-central1 region, and create read replicas in us-central1, us-east1 and us-west1.

Correct answer: A

Explanation

The correct answer is A because deploying 2 Cloud SQL instances with HA ensures high availability, while the read replicas in us-east1 and us-west1 provide low-latency access for applications in those regions. Options B, C, and D do not adequately address the HA requirement or do not optimize for low-latency access across multiple regions.