Answer-first summary for fast verification
Answer: Deploy 2 Cloud SQL instances in the us-central1 region with HA enabled, and create read replicas in us-east1 and us-west1.
To ensure high availability (HA) and low latency for read and write operations across multiple regions in the US for a Cloud SQL for PostgreSQL instance serving 100 databases, the best approach is to deploy instances with HA enabled and strategically place read replicas. Option A is the correct choice because it suggests deploying 2 Cloud SQL instances in the us-central1 region with HA enabled, which ensures that the primary and standby instances are in the same region for synchronous replication, providing high availability. Additionally, creating read replicas in us-east1 and us-west1 allows for low-latency read operations in those regions, catering to the applications located there. This setup balances the need for high availability with the requirement for low-latency operations across multiple regions. Options B, C, and D either lack HA configuration or suggest an unnecessary number of instances, which does not align with the requirement for a highly available and efficient setup.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
How should you design a highly available Cloud SQL for PostgreSQL instance to support 100 databases, each with 80 tables migrated from on-premises to Google Cloud, ensuring low-latency read and write operations for applications distributed across multiple US regions?
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.