Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
How can you migrate an on-premises mission-critical PostgreSQL database to Cloud SQL with less than five minutes of downtime during a zonal failure, ensure zero transaction loss, and adhere to Google's recommended practices?
A
Take nightly snapshots of the primary database instance, and restore them in a secondary zone.
B
Build a change data capture (CDC) pipeline to read transactions from the primary instance, and replicate them to a secondary instance.
C
Create a read replica in another region, and promote the read replica if a failure occurs.
D
Enable high availability (HA) for the database to make it regional.
