Associate Data Practitioner

By Google · Question Mode

QuestionQ55

Data Management

You work for a global financial services company that trades stocks 24/7. You have a Cloud SGL for PostgreSQL user database. You need to identify a solution that keeps the database continuously operational, minimizes downtime, and does not lose data if a zonal outage occurs. What should you do?

Explanation

A Cloud SQL instance configured for regional high availability has a primary and standby in separate zones. Writes are synchronously replicated to persistent disks in both zones before commit, and Cloud SQL automatically fails over to the standby during a zonal outage, avoiding data loss while limiting interruption.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!