Answer-first summary for fast verification
Answer: Leverage native database high availability tools to connect the source system with an Amazon RDS for Microsoft SQL Server DB instance. Configure replication appropriately. Upon completion of data replication, switch the workload to the Amazon RDS for Microsoft SQL Server DB instance.
The correct answer is C. To achieve near-zero downtime while migrating legacy Microsoft SQL Server databases to AWS, leveraging native database high availability tools and configuring replication to an Amazon RDS for Microsoft SQL Server DB instance is the most suitable solution. This method ensures that data replication is handled natively and efficiently. Once the replication is complete, the workload can be transitioned seamlessly to the new RDS instance. Options A and B involve more complex or time-consuming processes that are not ideal for achieving near-zero downtime, while D involves additional steps and complexity that can introduce more chances for downtime.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
A solutions architect is tasked with migrating critical legacy Microsoft SQL Server databases to a modern data architecture on AWS, ensuring near-zero downtime during the migration process. Which approach should the architect adopt to achieve this?
A
Employ AWS Application Migration Service in conjunction with the AWS Schema Conversion Tool (AWS SCT) to perform an in-place upgrade prior to migration. Subsequently, export the migrated data to Amazon Aurora Serverless and redirect the applications to use Amazon Aurora.
B
Utilize AWS Database Migration Service (AWS DMS) to rehost the database, targeting Amazon S3 as the destination. Implement change data capture (CDC) replication. Once the source and target are fully synchronized, transfer the data from Amazon S3 into an Amazon RDS for Microsoft SQL Server DB instance.
C
Leverage native database high availability tools to connect the source system with an Amazon RDS for Microsoft SQL Server DB instance. Configure replication appropriately. Upon completion of data replication, switch the workload to the Amazon RDS for Microsoft SQL Server DB instance.
D
Implement AWS Application Migration Service to rehost the database server on Amazon EC2. After data replication is complete, detach the database and transfer it to an Amazon RDS for Microsoft SQL Server DB instance. Reattach the database and finalize the migration by reconfiguring all network settings.