Question: 1/50
An online retail application uses Cloud SQL for PostgreSQL. The database must remain available during a zonal outage, and the application requires a single writable primary endpoint. What should you implement?
Enable high availability (regional) with automatic failover and use the instance IP/connection name as the primary endpoint
Create a read replica in another zone and manually promote it during an outage
Export the database to Cloud Storage daily and restore it in another zone during an outage
Use Cloud SQL Auth Proxy with a single-zone instance to avoid IP dependency during an outage