A solutions architect is planning to migrate critical Microsoft SQL Server databases to AWS. Because the databases are legacy systems, the solutions architect will move the databases to a modern data architecture. The solutions architect must migrate the databases with near-zero downtime. Which solution will meet these requirements?
Select one answer.
Marked answer: C
Community Discussion
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
Chose C1
Native SQL Server replication (transactional replication, Always On, or log shipping depending on your environment) lets you keep the source fully operational while you replicate changes to the AWS target. That minimizes the cutover window and supports near-zero downtime cutover
Chose C1
C is correct because using SQL Server’s native high availability and replication tools allows near-real-time synchronization to Amazon RDS for SQL Server. This approach enables a quick cutover with minimal downtime and avoids extra migration steps or intermediate data loads required by the other options.
Chose C2
Uses native replication; minimal downtime; direct migration
