Google Exam Professional Cloud Database Engineer Topic 6 Question 39 Discussion

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

Question #: 39
Topic #: 6

[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 Jonelle at Aug 06, 2024, 11:30 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

Lettie

3 months ago

B) CDC all the way! I bet the developers at Google are using it to keep their own databases running smoothly.

upvoted 0 times

...

Jesusita

3 months ago

C) A read replica in another region? Sounds like a good idea, but will it really withstand a zonal failure? I'm not convinced.

upvoted 0 times

Dalene

2 months ago

C) A read replica in another region? Sounds like a good idea, but will it really withstand a zonal failure? I'm not convinced.

upvoted 0 times

...

Josphine

3 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

3 months ago

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

upvoted 0 times

...

Merissa

4 months ago

A) Snapshots? Really? That's so 90s. We need a more modern approach for a cloud migration.

upvoted 0 times

Richelle

3 months ago

D) I agree, high availability is crucial for mission-critical databases in the cloud.

upvoted 0 times

...

Ronald

3 months ago

C) It might be a bit complex, but it's the best way to ensure minimal downtime and no data loss.

upvoted 0 times

...

Alonzo

3 months ago

A) But won't that be complex to set up and maintain?

upvoted 0 times

...

Juliana

3 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

...

Joanna

4 months ago

D) Hmm, I'm not sure. Enabling HA sounds like the easy way out. Google-recommended practices are usually more robust.

upvoted 0 times

...

Vicki

4 months ago

B) Definitely. A CDC pipeline is the way to go for mission-critical workloads. Ensures zero data loss and minimal downtime.

upvoted 0 times

Chan

3 months ago

B) Definitely. A CDC pipeline is the way to go for mission-critical workloads. Ensures zero data loss and minimal downtime.

upvoted 0 times

...

Ailene

4 months ago

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

upvoted 0 times

...

Dyan

4 months ago

I see your point, Lura, but I think option C is also a good choice. Creating a read replica in another region provides additional redundancy.

upvoted 0 times

...

Lura

4 months ago

I disagree, I believe option D is the way to go. Enabling high availability will ensure the database is regional and can withstand zonal failures.

upvoted 0 times

...

Leonardo

4 months ago

I think option A is the best choice because taking nightly snapshots ensures we have up-to-date data in a secondary zone.

upvoted 0 times

...