A company plans to migrate its on-premises SQL Server database to AWS and wants AWS to manage routine database administration. Which AWS service meets this requirement?
Choose an answer
Tap an option to check your answer.
Correct answer: Amazon RDS.
Why this is the answer
Amazon RDS (Relational Database Service) is the correct choice because it is a managed relational database service that supports Microsoft SQL Server. RDS automates common administrative tasks like patching, backups, and scaling, freeing the company from these operational burdens. While Amazon EC2 for Microsoft SQL Server allows you to run SQL Server on EC2 instances, it requires you to manage the operating system and database administration yourself, which contradicts the requirement for AWS to manage routine administration. Amazon DynamoDB is a NoSQL database service and is not suitable for migrating a relational SQL Server database directly. Amazon Aurora is a relational database service compatible with MySQL and PostgreSQL, not SQL Server.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed