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 Professional Cloud Database Engineer Exam - Topic 11 Question 12 Discussion

You want to migrate your on-premises PostgreSQL database to Compute Engine. You need to migrate this database with the minimum downtime possible. What should you do?
B) Create a read replica on Cloud SQL, and then promote it to a read/write standalone instance.
A) Perform a full backup of your on-premises PostgreSQL, and then, in the migration window, perform an incremental backup.
C) Use Database Migration Service to migrate your database.
D) Create a hot standby on Compute Engine, and use PgBouncer to switch over the connections.

Google Professional Cloud Database Engineer Exam - Topic 11 Question 12 Discussion

Actual exam question for Google's Professional Cloud Database Engineer exam
Question #: 12
Topic #: 11
[All Professional Cloud Database Engineer Questions]

You want to migrate your on-premises PostgreSQL database to Compute Engine. You need to migrate this database with the minimum downtime possible. What should you do?

Show Suggested Answer Hide Answer
Suggested Answer: B

by Novella at Dec 29, 2022, 09:38 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Angelo
9 months ago
Definitely leaning towards C, it's designed for migrations!
upvoted 0 times
...
Joni
9 months ago
Wait, can you really use PgBouncer for that? Sounds sketchy.
upvoted 0 times
...
Billy
9 months ago
A full backup sounds risky, I wouldn't go with A.
upvoted 0 times
...
Rolande
9 months ago
I think B could work too, but it might take longer.
upvoted 0 times
...
Celestine
9 months ago
Option C is the best choice for minimal downtime!
upvoted 0 times
...
Chara
9 months ago
Option D seems a bit complex with the hot standby and PgBouncer. I don't remember covering that in detail, so I’m hesitant to choose it.
upvoted 0 times
...
Eileen
9 months ago
I recall something about using incremental backups, which makes me lean towards option A, but I’m worried about the downtime during the migration window.
upvoted 0 times
...
Silva
9 months ago
I'm not entirely sure, but I feel like option B could work too. Setting up a read replica seems like it could help with the transition, but I’m not confident about the promotion process.
upvoted 0 times
...
Dalene
10 months ago
I think option C sounds familiar; I remember practicing with the Database Migration Service in our labs. It seemed like a solid choice for minimizing downtime.
upvoted 0 times
...
Chantell
10 months ago
Okay, let's see. The question is asking about the impact of running that cache:clean command. I'm pretty sure it has to do with the target_rule cache, but I want to double-check the options.
upvoted 0 times
...
Laurene
10 months ago
Hmm, this looks tricky. I'm not sure how to approach it. Maybe I should re-read the question carefully and try to break it down.
upvoted 0 times
...
Olen
10 months ago
No problem, I've got this. I'll use the formula for the 95% CI: sample mean +/- 1.96 * (sample standard deviation / sqrt(sample size)). Should be straightforward to plug in the numbers.
upvoted 0 times
...

Save Cancel