Google Cloud Professional Cloud Database Engineer — Question 81

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

Answer options

• A. Use a change data capture (CDC) migration strategy.
• 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.
• D. Increase the network bandwidth to 2 Gbps, and then perform an offline data migration.
• E. Increase the network bandwidth to 10 Gbps, and then perform an offline data migration.

Correct answer: A, E

Explanation

The use of a change data capture (CDC) migration strategy (A) allows for ongoing data synchronization during the migration, ensuring minimal downtime. Increasing the network bandwidth to 10 Gbps (E) significantly reduces the time required for the offline data migration, fitting within the 48-hour window. The other options either do not leverage bandwidth effectively or propose impractical methods like moving physical servers.