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
9 months ago
Definitely need to stick with 1 Gbps for this migration.
upvoted 0 times
...
Keshia
9 months ago
Surprised that 10 Gbps is even an option for this!
upvoted 0 times
...
Josephine
9 months ago
Moving physical servers? That's a no-go for me.
upvoted 0 times
...
Vincenza
9 months ago
I think offline migration is the way to go.
upvoted 0 times
...
Johanna
9 months ago
CDC is a solid choice for minimizing downtime!
upvoted 0 times
...
Hyun
9 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
9 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
9 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
10 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
10 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
10 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
10 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