Q44 — AWS SAA-C03 Ch.16

Question 44 of 100 | ← Chapter 16

Q1244. A company wants to migrate a Microsoft SQL Server database server from an on-premises data center to AWS. The company needs access to the operating system of the SQL Server database.Which solution will meet these requirements?

Correct Answer: C. Migrate the database to Amazon EC2 instances that run SQL Server.

Explanation

The company wants to migrate a Microsoft SQL Server database from on-premises to AWS while retaining access to the operating system (OS) of the SQL Server database. Let's evaluate the options:Key Requirement:OS-level access The solution must allow administrative control over the underlying server (e.g., for custom configurations, installing agents, or troubleshooting).Analysis of Options:A. Migrate the database to Amazon Aurora Serverless.Incorrect:Aurora Serverless is a fully managed PostgreSQL/MySQL-compatible database service. Does not support SQL Server (Aurora is not for SQL Server).No OS access (fully managed, serverless).B. Migrate the database to Amazon RDS for SQL Server.Incorrect:Amazon RDS for SQL Server is a fully managed database service. No OS access (AWS manages the underlying OS, patches, and backups). Good for simplicity but does not meet the OS access requirement. C. Migrate the database to Amazon EC2 instances that run SQL Server.Correct:Amazon EC2 provides full OS access (Windows/Linux).You can install SQL Server on an EC2 instance and manage it like an on-premises server.Meets the requirement for OS-level control.Flexible (supports custom configurations, third-party tools, etc.).D. Migrate the database to Amazon Redshift.Incorrect:Amazon Redshift is a fully managed data warehousing service. Not designed for OLTP workloads (SQL Server is an OLTP database).No OS access (fully managed).Final Answer:C. Migrate the database to Amazon EC2 instances that run SQL Server.Why This is the Best Choice:OS Access: EC2 provides full administrative control over the server. SQL Server Support: EC2 supports SQL Server Standard/Enterprise editions. Customization: Allows installation of additional software, agents, or custom scripts. Migration Flexibility: Can use tools like AWS Database Migration Service (DMS) or native SQL Server backup/restore.Alternative Considerations:If OS access is not required, Amazon RDS for SQL Server (Option B) would be a better choice for managed simplicity.Aurora Serverless (A) and Redshift (D) are irrelevant for SQL Server migration.