Answer-first summary for fast verification
Answer: Create one regional Cloud SQL instance in one zone with a standby instance in another zone in the same region.
To achieve an optimal and highly available PostgreSQL database environment in Cloud SQL with automatic failover, the best approach is to create a regional Cloud SQL instance with a standby instance in another zone within the same region. This setup ensures high availability within the same region, minimizing latency and providing automatic failover in case of a zone failure. Option B correctly describes this configuration. Options A, C, and D either involve unnecessary complexity, such as cross-region replication which can introduce latency, or do not fully leverage Cloud SQL's regional capabilities for high availability.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
How should you configure a new PostgreSQL database instance in Cloud SQL to ensure optimal performance, high availability, and automatic failover for uninterrupted operation?
A
Create one regional Cloud SQL instance with a read replica in another region.
B
Create one regional Cloud SQL instance in one zone with a standby instance in another zone in the same region.
C
Create two read-write Cloud SQL instances in two different zones with a standby instance in another region.
D
Create two read-write Cloud SQL instances in two different regions with a standby instance in another zone.
No comments yet.