Topic 1 Question 128
You want to migrate an on-premises mission-critical PostgreSQL database to Cloud SQL. The database must be able to withstand a zonal failure with less than five minutes of downtime and still not lose any transactions. You want to follow Google-recommended practices for the migration. What should you do?
Take nightly snapshots of the primary database instance, and restore them in a secondary zone.
Build a change data capture (CDC) pipeline to read transactions from the primary instance, and replicate them to a secondary instance.
Create a read replica in another region, and promote the read replica if a failure occurs.
Enable high availability (HA) for the database to make it regional.
γ³γ‘γ³γ(2)
D. Mission critical means make the instance HA. Nothing else makes sense apart from D.
π 2dynamic_dba2023/03/27D, zonal failure > enable HA to recover
π 1AnilKr2023/03/23
γ·γ£γγγ«γ’γΌγ