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…

Question

Options

• ADeploy 2 Cloud SQL instances in the us-central1 region with HA enabled, and create read
• BDeploy 2 Cloud SQL instances in the us-central1 region, and create read replicas in us-east1 and
• CDeploy 4 Cloud SQL instances in the us-central1 region with HA enabled, and create read
• DDeploy 4 Cloud SQL instances in the us-central1 region, and create read replicas in us-central1,

• A
  5% (2)
• B
  13% (5)
• C
  79% (31)
• D
  3% (1)

Explanation

With 100 databases and 80 tables each, the workload needs to be distributed across multiple Cloud SQL instances to stay within instance limits and maintain performance. Deploying 4 Cloud SQL instances in us-central1 with HA enabled provides high availability via synchronous standby replicas in a different zone within the same region. Adding read replicas in other US regions (e.g., us-east1, us-west1) ensures low-latency reads for applications in those regions. HA enabled (vs. not enabled in option D) is critical to meet the 'highly available' requirement. Options A and B use only 2 instances, which is insufficient for distributing 100 databases at the required scale.

No community discussion yet for this question.