Skip to content
PCA Practice
SQ56

A company's Cloud SQL instance fails over to the standby. The application experiences 30 seconds of connection errors. Which improvement most reduces failover impact?

  1. ASwitch to manual failover only
  2. BUse connection pooling with retry logic and short timeouts
  3. CRemove the failover replica
  4. DIncrease the Cloud SQL machine type
Show answer

Answer: B

Connection pooling with retries and appropriate timeouts allows the application to gracefully handle the brief connection disruption during failover. Increasing size doesn't improve failover speed. Removing the replica eliminates HA.

← SQ55Practice this topicSQ57 →