Which AWS service will meet the company’s requirements?
Amazon EC2 for Microsoft SQL Server
Amazon DynamoDB
Amazon RDS
Amazon Aurora
Explanations:
Amazon EC2 for Microsoft SQL Server provides infrastructure for running SQL Server but does not handle day-to-day database administration tasks like backups, patching, or monitoring, which would require manual management.
Amazon DynamoDB is a NoSQL database service, which is not compatible with SQL Server databases. It is not suited for migrating SQL Server databases.
Amazon RDS (Relational Database Service) for SQL Server allows AWS to manage day-to-day administration tasks such as backups, patching, and scaling, making it the best fit for the company’s requirements.
Amazon Aurora is a relational database service compatible with MySQL and PostgreSQL but not SQL Server. It cannot be used to migrate an on-premises SQL Server database.