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
6 months ago
B seems complicated, I’d stick with D for simplicity.
upvoted 0 times
...
Justa
7 months ago
Wait, can we really do this without any app changes? Sounds too good to be true.
upvoted 0 times
...
Buck
7 months ago
I think A could work, but not sure about zero downtime.
upvoted 0 times
...
Verdell
7 months ago
Totally agree, Database Migration Service is designed for this!
upvoted 0 times
...
Verdell
7 months ago
D is the best choice for zero downtime migration.
upvoted 0 times
...
Ethan
8 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
8 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
8 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
8 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
8 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
8 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
8 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
8 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
8 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
8 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
8 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