PCA Question 69

Community Discussion

Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.

• Chose D1

  A read replica is for scaling read traffic, not automatic failover.

• 1

  C. Create a read replica instance in the same region, but in a different zone: This is incorrect. A read replica is not a failover replica. As mentioned above, it is for read-heavy workloads and does not support automatic failover. D. Create a failover replica instance in the same region, but in a different zone: This is the correct approach. Cloud SQL's high availability configuration automatically creates a standby instance (failover replica) in a different zone from the primary instance. If the primary instance or its zone fails, Cloud SQL automatically switches over to the standby instance. The standby instance takes over the primary's static IP address, providing a seamless failover with minimal downtime.

• Chose D2

  The correct answer is D. Create a failover replica instance in the same region, but in a different zone. To provide high availability for a Cloud SQL instance, the standard practice is to use a failover replica. A failover replica is a standby instance that is kept in sync with the primary instance and is located in a different zone within the same region. This configuration is known as a regional instance and provides automatic failover.