A Company Wants to Migrate Its Microsoft SQL Server Enterprise

question 114

Multiple Choice

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?

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

---

Definitions:

Strategic Orientation

An approach or planning framework that aligns an organization's resources and activities with its long-term goals and competitive environment.

Cost Conscious

The mindset of being aware of costs and striving to minimize expenses without sacrificing quality or value.

Volume Conscious

Awareness and focus on producing or handling large quantities of goods or services to leverage economies of scale or meet high demand.

Vertical Coordination

It refers to the process of managing and integrating processes, functions, and activities across different levels within an organization to ensure alignment and efficiency towards a common goal.