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 1 Question 7 Discussion

You want to migrate an on-premises 100 TB Microsoft SQL Server database to Google Cloud over a 1 Gbps network link. You have 48 hours allowed downtime to migrate this database. What should you do? (Choose two.)
A) Use a change data capture (CDC) migration strategy. and D) Increase the network bandwidth to 2 Gbps, and then perform an offline data migration.
B) Move the physical database servers from on-premises to Google Cloud.
C) Keep the network bandwidth at 1 Gbps, and then perform an offline data migration.
E) Increase the network bandwidth to 10 Gbps, and then perform an offline data migration.

Google Professional Cloud Database Engineer Exam - Topic 1 Question 7 Discussion

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

You want to migrate an on-premises 100 TB Microsoft SQL Server database to Google Cloud over a 1 Gbps network link. You have 48 hours allowed downtime to migrate this database. What should you do? (Choose two.)

Show Suggested Answer Hide Answer
Suggested Answer: A, D

by Marge at Sep 19, 2022, 06:32 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
Ammie
7 months ago
Definitely need to stick with 1 Gbps for this migration.
upvoted 0 times
...
Keshia
7 months ago
Surprised that 10 Gbps is even an option for this!
upvoted 0 times
...
Josephine
7 months ago
Moving physical servers? That's a no-go for me.
upvoted 0 times
...
Vincenza
8 months ago
I think offline migration is the way to go.
upvoted 0 times
...
Johanna
8 months ago
CDC is a solid choice for minimizing downtime!
upvoted 0 times
...
Hyun
8 months ago
I’m leaning towards option C, but I wonder if we could really complete the migration in 48 hours with just 1 Gbps.
upvoted 0 times
...
Julio
8 months ago
I practiced a similar question where we had to consider downtime, and I feel like an offline migration might be safer.
upvoted 0 times
...
Rory
8 months ago
I think increasing the bandwidth could help, but I’m not clear on how much we actually need for a 100 TB database.
upvoted 0 times
...
Loreta
8 months ago
I remember studying about CDC strategies, but I'm not entirely sure if it's the best choice for this scenario.
upvoted 0 times
...
Leota
8 months ago
I'm feeling pretty confident about this one. The solution they provided seems to cover all the necessary steps, so I'll just go with that. As long as I navigate to the right place in Visual Studio and create the extension, I should be good to go.
upvoted 0 times
...
Charlene
8 months ago
I'm leaning towards the option about retaining ownership while using Cisco's solutions. It seems like a pretty big deal for a lot of businesses, right?
upvoted 0 times
...
Fatima
8 months ago
This seems pretty straightforward. If there are 3 data blocks and one is lost, I'll need to manually copy a copy to the node to restore it. I'm confident the answer is A, True.
upvoted 0 times
...

Save Cancel