Exam AWS Certified Database - Specialty topic 1 question 257 discussion

Exam question from Amazon's AWS Certified Database - Specialty

Question #: 257
Topic #: 1

[All AWS Certified Database - Specialty Questions]

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.)

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.

Show Suggested Answer

Suggested Answer: ACE 🗳️

by gairaj at Sept. 9, 2022, 7:54 p.m.

Disclaimers:

- ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
- Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Submit Cancel

Changwha

Highly Voted 2 years, 8 months ago

Selected Answer: ACE

Migration using backup and restore. https://docs.aws.amazon.com/AWSEC2/latest/WindowsGuide/replatform-sql-server.html Bx: Not STS, Dx: Not RDS, Fx: Not DMS

upvoted 5 times

...

Sathish_dbs

Most Recent 1 year, 8 months ago

Okay the Key is "hundreds of database", wondering why can't we simply use DMS but that's hectic, as we can simply backup and restore but the answer E slightly mislead saying "Start Migration" instead of backup and restore, great learning

upvoted 1 times

...

Germaneli

1 year, 8 months ago

Selected Answer: ACE

Why not B, D or F? B. You don't want to convert the schema (using AWS Schema Conversion Tool) because you're just replatforming SQL Server on-prem to SQL Server on AWS. D. AN RDS for SQL Server instance doesn't have an OS that you can modify. It'S just RDS (Platform as a service). F. The task is to re-platform from Windows to Linux, not simply to migrate the data. For this, (E) is better suited.

upvoted 1 times

...

Pranava_GCP

1 year, 9 months ago

Selected Answer: ACE

https://docs.aws.amazon.com/AWSEC2/latest/WindowsGuide/replatform-sql-server.html https://docs.aws.amazon.com/prescriptive-guidance/latest/patterns/migrate-an-on-premises-microsoft-sql-server-database-to-microsoft-sql-server-on-amazon-ec2-running-linux.html

upvoted 1 times

...