Google Exam Professional Cloud Database Engineer Topic 11 Question 33 Discussion

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

Question #: 33
Topic #: 11

[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 Willetta at May 22, 2024, 01:10 PM

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

Jina

9 months ago

Ah, the age-old question of how to migrate a mission-critical database to the cloud. I say go with B - it's the only option that guarantees zero data loss!

upvoted 0 times

...

Fatima

9 months ago

I'm going with B. A CDC pipeline is the way to go for mission-critical databases. Plus, it's a Google-recommended practice, so you can't go wrong.

upvoted 0 times

...

Kristeen

9 months ago

Hmm, I'm not sure. C seems like it might work, but I'm worried about the potential for data loss during the failover process.

upvoted 0 times

Sabine

8 months ago

C) Create a read replica in another region, and promote the read replica if a failure occurs.

upvoted 0 times

...

Percy

8 months ago

B) Build a change data capture (CDC) pipeline to read transactions from the primary instance, and replicate them to a secondary instance.

upvoted 0 times

...

Delisa

9 months ago

A) Take nightly snapshots of the primary database instance, and restore them in a secondary zone.

upvoted 0 times

...

9 months ago

I think B is the correct answer. A CDC pipeline will ensure no transactions are lost, and it follows Google's recommended practices for high availability.

upvoted 0 times

Bong

9 months ago

Yes, a CDC pipeline is the way to go for maintaining high availability and following Google's recommendations.

upvoted 0 times

...

Pedro

9 months ago

I agree, B is the best option for ensuring no transaction loss during a zonal failure.

upvoted 0 times

...