Question 122 of 139
Single answerYou 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
ATake nightly snapshots of the primary database instance, and restore them in a secondary zone.
BBuild a change data capture (CDC) pipeline to read transactions from the primary instance, and replicate them to a secondary instance.
CCreate a read replica in another region, and promote the read replica if a failure occurs.
.
✓DEnable high availability (HA) for the database to make it regional
✓
Correct Answer: D
Enable high availability (HA) for the database to make it regional
▥
Explanation
The correct answer is highlighted above. Review the wording carefully, then use the next question to continue building your understanding of Google certification topics.