AWS Certified Database – Specialty — Question 88

A company wants to migrate its Microsoft SQL Server Enterprise Edition database instance from on-premises to AWS. A deep review is performed and the AWS
Schema Conversion Tool (AWS SCT) provides options for running this workload on Amazon RDS for SQL Server Enterprise Edition, Amazon RDS for SQL Server
Standard Edition, Amazon Aurora MySQL, and Amazon Aurora PostgreSQL. The company does not want to use its own SQL server license and does not want to change from Microsoft SQL Server.
What is the MOST cost-effective and operationally efficient solution?

Answer options

• A. Run SQL Server Enterprise Edition on Amazon EC2.
• B. Run SQL Server Standard Edition on Amazon RDS.
• C. Run SQL Server Enterprise Edition on Amazon RDS.
• D. Run Amazon Aurora MySQL leveraging SQL Server on Linux compatibility libraries.

Correct answer: B

Explanation

The correct answer is B because running SQL Server Standard Edition on Amazon RDS allows the company to avoid licensing costs associated with the Enterprise Edition while still using Microsoft SQL Server. Options A and C involve using the Enterprise Edition, which the company wishes to avoid, and option D shifts to Amazon Aurora MySQL, which does not meet the requirement to stay with Microsoft SQL Server.