Google Professional Cloud Database Engineer Q28

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?

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.