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 8 Question 19 Discussion

Your company wants to migrate its MySQL, PostgreSQL, and Microsoft SQL Server on-premises databases to Google Cloud. You need a solution that provides near-zero downtime, requires no application changes, and supports change data capture (CDC). What should you do?
B) Create a database on Google Cloud, and use database links to perform the migration.
A) Use the native export and import functionality of the source database.
C) Create a database on Google Cloud, and use Dataflow for database migration.
D) Use Database Migration Service.

Google Professional Cloud Database Engineer Exam - Topic 8 Question 19 Discussion

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

Your company wants to migrate its MySQL, PostgreSQL, and Microsoft SQL Server on-premises databases to Google Cloud. You need a solution that provides near-zero downtime, requires no application changes, and supports change data capture (CDC). What should you do?

Show Suggested Answer Hide Answer
Suggested Answer: B

by Willard at Aug 31, 2023, 11:08 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
Ligia
9 months ago
B seems complicated, I’d stick with D for simplicity.
upvoted 0 times
...
Justa
10 months ago
Wait, can we really do this without any app changes? Sounds too good to be true.
upvoted 0 times
...
Buck
10 months ago
I think A could work, but not sure about zero downtime.
upvoted 0 times
...
Verdell
10 months ago
Totally agree, Database Migration Service is designed for this!
upvoted 0 times
...
Verdell
10 months ago
D is the best choice for zero downtime migration.
upvoted 0 times
...
Ethan
11 months ago
I recall that Database Migration Service is specifically designed for this kind of task, so it seems like the most straightforward choice.
upvoted 0 times
...
Florinda
11 months ago
I think we practiced a similar question where Dataflow was mentioned, but I’m not confident it supports CDC as well as the other options.
upvoted 0 times
...
Paul
11 months ago
I'm not entirely sure, but I feel like using native export and import could lead to more downtime, which we want to avoid.
upvoted 0 times
...
Heidy
11 months ago
I remember we discussed the importance of minimizing downtime during migrations, so I think Database Migration Service might be the best option here.
upvoted 0 times
...
Tarra
11 months ago
Dataflow could be an interesting option, but I'm not sure if it has the same level of database migration capabilities as the dedicated Database Migration Service.
upvoted 0 times
...
Howard
11 months ago
I'm a bit confused by the database links approach. That doesn't seem like it would provide the seamless migration they're looking for.
upvoted 0 times
...
Dorothy
11 months ago
Database Migration Service sounds like the best option here. It's designed for this exact use case and should meet all the requirements.
upvoted 0 times
...
Jannette
11 months ago
Hmm, the native export and import functionality might not work since it doesn't mention supporting CDC. I'll have to think this through.
upvoted 0 times
...
Willard
11 months ago
This looks like a tricky question. I'll need to carefully consider the requirements of near-zero downtime, no application changes, and CDC support.
upvoted 0 times
...
Cecily
11 months ago
This looks like a straightforward question on Optional usage. I'll carefully read through the code and think through the logic step-by-step.
upvoted 0 times
...
Thersa
11 months ago
Hmm, this looks straightforward. I think I can use the LOWER() and LEFT() functions to get the first initial, then concatenate that with the last name and the email domain.
upvoted 0 times
...

Save Cancel