AWS Certified Solutions Architect - Professional
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
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.