AWS Certified Database – Specialty — Question 359

A company runs hundreds of Microsoft SQL Server databases on Windows servers in its on-premises data center. A database specialist needs to migrate these databases to Linux on AWS.
Which combination of steps should the database specialist take to meet this requirement? (Choose three.)

Answer options

• A. Install AWS Systems Manager Agent on the on-premises servers. Use Systems Manager Run Command to install the Windows to Linux replatforming assistant for Microsoft SQL Server Databases.
• B. Use AWS Systems Manager Run Command to install and configure the AWS Schema Conversion Tool on the on-premises servers.
• C. On the Amazon EC2 console, launch EC2 instances and select a Linux AMI that includes SQL Server. Install and configure AWS Systems Manager Agent on the EC2 instances.
• D. On the AWS Management Console, set up Amazon RDS for SQL Server DB instances with Linux as the operating system. Install AWS Systems Manager Agent on the DB instances by using an options group.
• E. Open the Windows to Linux replatforming assistant tool. Enter configuration details of the source and destination databases. Start migration.
• F. On the AWS Management Console, set up AWS Database Migration Service (AWS DMS) by entering details of the source SQL Server database and the destination SQL Server database on AWS. Start migration.

Correct answer: A, C, E

Explanation

To migrate SQL Server from Windows to Linux on AWS, the Windows to Linux replatforming assistant is the recommended tool, which requires the AWS Systems Manager Agent to be installed on the source Windows servers (Option A) and the target Linux EC2 instances (Option C). The migration is then executed by configuring and running the replatforming assistant tool (Option E). Amazon RDS for SQL Server does not support customer-managed Linux OS or SSM Agent installation via option groups, making Option D incorrect, while SCT and DMS (Options B and F) are not utilized by this specific replatforming workflow.