Google Exam Professional Cloud Database Engineer Topic 7 Question 50 Discussion

Actual exam question for Google's Professional Cloud Database Engineer exam

Question #: 50
Topic #: 7

[All Professional Cloud Database Engineer Questions]

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?

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.

Show Suggested Answer

Suggested Answer: D

by Carey at Jan 14, 2025, 07:02 AM

Limited Time Offer

25%

Off

Get Premium Professional Cloud Database Engineer Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Raul

6 days ago

I think option D is the best choice because enabling high availability will make the database regional.

upvoted 0 times

...

Lilli

10 days ago

Option B is the way to go! Building a CDC pipeline ensures zero data loss and minimal downtime. That's the Google-recommended approach right there.

upvoted 0 times

...