PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #100
PROFESSIONAL-CLOUD-DATABASE-ENGINEER Question #100: Real Exam Question with Answer & Explanation
Sign in or unlock PROFESSIONAL-CLOUD-DATABASE-ENGINEER to reveal the answer and full explanation for question #100. The question stem and answer options stay visible for context.
Question
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?
Options
- 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
- 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.
Unlock PROFESSIONAL-CLOUD-DATABASE-ENGINEER to see the answer
You've previewed enough free PROFESSIONAL-CLOUD-DATABASE-ENGINEER questions. Unlock PROFESSIONAL-CLOUD-DATABASE-ENGINEER for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.