Answer-first summary for fast verification
Answer: Configure the primary instance in zone A, the standby instance in zone C, and the read replica in zone B, all in the same region.
To ensure high availability in Google Cloud SQL for PostgreSQL, it's recommended to distribute your instances across different zones within the same region. This setup protects against zonal failures while keeping latency low. Option A correctly distributes the primary, standby, and read replica instances across three different zones (A, C, and B) within the same region, following Google's recommended practices for high availability. Option B places both the primary and standby instances in the same zone (A), which does not provide zonal redundancy for the standby. Option C suggests distributing instances across different regions, which is not necessary for high availability within the context of a single region's setup and could introduce unnecessary latency. Option D places all instances in the same zone, which offers no protection against zonal failures.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
How should you configure a new Cloud SQL for PostgreSQL instance in Google Cloud with one primary, one standby, and one read replica while adhering to Google's best practices for high availability?
A
Configure the primary instance in zone A, the standby instance in zone C, and the read replica in zone B, all in the same region.
B
Configure the primary and standby instances in zone A and the read replica in zone B, all in the same region.
C
Configure the primary instance in one region, the standby instance in a second region, and the read replica in a third region.
D
Configure the primary, standby, and read replica instances in zone A, all in the same region.
No comments yet.