Google Cloud Professional Cloud Database Engineer PCDBE — Topic 1 Question 99

Question

You are configuring a brand new PostgreSQL database instance in Cloud SQL. Your application team wants to have an optimal and highly available environment with automatic failover to avoid any unplanned outage. What should you do?

Accepted Answer

Correct answer: B. The correct answer is B. Option B: Create one regional Cloud SQL instance in one zone with a standby instance in another zone in the same region. Cloud SQL is a managed relational database (MySQL/PostgreSQL/SQL Server) that handles patching, backups, and failover. By spanning multiple Availability Zones / adding redundancy, this option provides the high availability and resilience required.

Google Cloud Professional Cloud Database Engineer PCDBE — Question 99