Answer: Use a change data capture (CDC) migration strategy., Increase the network bandwidth to 10 Gbps, and then perform an offline data migration.

Given the scenario of migrating a 100 TB Microsoft SQL Server database to Google Cloud with a 48-hour downtime window and a 1 Gbps network link, the most effective strategies would involve minimizing the downtime and ensuring the data transfer is feasible within the given constraints. Option A, using a change data capture (CDC) migration strategy, is correct because CDC allows for the initial bulk data transfer followed by continuous replication of changes, minimizing downtime. Option E, increasing the network bandwidth to 10 Gbps and then performing an offline data migration, is also correct because a higher bandwidth significantly reduces the time required for the initial data transfer, making it feasible within the 48-hour window. Options B and C are less optimal; moving physical servers is impractical for cloud migration, and keeping the bandwidth at 1 Gbps would likely not suffice for transferring 100 TB within 48 hours. Option D, while improving bandwidth, may not provide enough improvement to ensure the migration completes within the allowed downtime.

Author: LeetQuiz Editorial Team