A company wants to migrate its on-premises SQL Server database to the AWS Cloud. The company wants AWS to handle the day-to-day administration of the database. Which AWS service will meet the company'

Question

Options

• AAmazon EC2 for Microsoft SQL Server
• BAmazon DynamoDB
• CAmazon RDS
• DAmazon Aurora

• C
  96% (26)
• D
  4% (1)

Explanation

Amazon RDS (C) is correct because it is a fully managed relational database service that supports Microsoft SQL Server, handling day-to-day administration tasks like patching, backups, failover, and scaling - exactly what the company wants offloaded to AWS.

Why the distractors are wrong:

• A (EC2 for SQL Server): Running SQL Server on EC2 means you manage the OS, patches, backups, and database engine - AWS only manages the underlying hardware. This is "lift and shift," not managed.
• B (DynamoDB): DynamoDB is a fully managed NoSQL database. SQL Server is relational, and migrating to DynamoDB would require significant application re-architecture, not a straightforward migration.
• D (Aurora): Aurora is also a fully managed relational DB service, but it only supports MySQL and PostgreSQL - not SQL Server. It would require a database engine change, not just a migration.

Memory tip: Think of RDS as "Relational Database Service" - the S stands for "Someone else handles it." Whenever a question mentions keeping the same relational engine (SQL Server, Oracle, MySQL, etc.) and offloading admin work, RDS is the answer. If they also want to change engines to AWS-native, then Aurora enters the picture.

No community discussion yet for this question.