Explanation:
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.
Ultimate access to all questions.
No comments yet.
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.