Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

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?

Show Suggested Answer Hide 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
Lina
1 months ago
I'm picturing the database admin frantically trying to restore from a nightly snapshot while the stakeholders are breathing down their neck. Option B for the win!
upvoted 0 times
...
Anissa
1 months ago
Haha, snapshots? Really? That's so 2010. I wouldn't trust that for a mission-critical database. Option B is the clear winner here.
upvoted 0 times
...
Jarod
1 months ago
I'm with Lilli on this one. Replicating transactions to a secondary instance is the best way to achieve the required reliability and durability.
upvoted 0 times
Lorrine
12 days ago
C) Create a read replica in another region, and promote the read replica if a failure occurs.
upvoted 0 times
...
Gilma
17 days ago
Alex: Yeah, replicating transactions to a secondary instance ensures we don't lose any data during a zonal failure.
upvoted 0 times
...
Krystal
18 days 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
...
Jesusita
18 days ago
Lilli: I agree, setting up a CDC pipeline is the way to go.
upvoted 0 times
...
Fletcher
21 days ago
A) Take nightly snapshots of the primary database instance, and restore them in a secondary zone.
upvoted 0 times
...
...
Raul
1 months ago
That's a good point, Linwood. Option C does provide a good solution for ensuring minimal downtime and no data loss during a zonal failure.
upvoted 0 times
...
Linwood
1 months ago
I disagree, I believe option C is the way to go. Creating a read replica in another region and promoting it in case of failure seems more reliable.
upvoted 0 times
...
Raul
2 months ago
I think option D is the best choice because enabling high availability will make the database regional.
upvoted 0 times
...
Lilli
2 months 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
Paris
20 days ago
Absolutely, CDC pipeline is the most reliable way to replicate transactions and prevent any data loss.
upvoted 0 times
...
Stephane
24 days ago
I agree! CDC pipeline is definitely the best choice for ensuring data integrity during the migration.
upvoted 0 times
...
Anissa
1 months 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
...
...

Save Cancel