Exam Professional-Cloud-Database-Engineer Topic 5 Question 61 Discussion

Actual exam question for Google's Professional-Cloud-Database-Engineer exam
Question #: 61
Topic #: 5

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?

A. Create one regional Cloud SQL instance with a read replica in another region. B. Create one regional Cloud SQL instance in one zone with a standby instance in another zone in the same region. C. Create two read-write Cloud SQL instances in two different zones with a standby instance in another region. D. Create two read-write Cloud SQL instances in two different regions with a standby instance in another zone.

Suggested Answer: B Vote an answer

This answer is correct because it meets the requirements of having an optimal and highly available environment with automatic failover. According to the Google Cloud documentation1, a regional Cloud SQL instance is an instance that has a primary server in one zone and a standby server in another zone within the same region. The primary and standby servers are kept in sync using synchronous replication, which ensures zero data loss and minimal downtime in case of a zonal outage or an instance failure. If the primary server becomes unavailable, Cloud SQL automatically fails over to the standby server, which becomes the new primary server1.

by Harry at Jun 02, 2026, 05:12 AM

Limited Time Offer

15%

Off

Get Premium Professional-Cloud-Database-Engineer Questions as Interactive Self Test Engine or PDF

Comments

0 Satisfied Customers

0 Shares

0 Demo Downloads

10 Years in Business