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.)

AUse a change data capture (CDC) migration strategy.

BMove the physical database servers from on-premises to Google Cloud.

CKeep the network bandwidth at 1 Gbps, and then perform an offline data migration.

DIncrease the network bandwidth to 2 Gbps, and then perform an offline data migration.

EIncrease the network bandwidth to 10 Gbps, and then perform an offline data migration.

Show Suggested 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:

Submit Cancel

Ammie

4 months ago

Definitely need to stick with 1 Gbps for this migration.

upvoted 0 times

...

Keshia

4 months ago

Surprised that 10 Gbps is even an option for this!

upvoted 0 times

...

Josephine

4 months ago

Moving physical servers? That's a no-go for me.

upvoted 0 times

...

Vincenza

4 months ago

I think offline migration is the way to go.

upvoted 0 times

...

Johanna

4 months ago

CDC is a solid choice for minimizing downtime!

upvoted 0 times

...

Hyun

5 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

5 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

5 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

5 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

5 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

5 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

5 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

...