A company manages an on-premises MySQL database on a Windows server.The company wants to migrate the database to AWS and needs a solution that will reduce the administrative overhead of the database.
Which AWS service will meet this requirement?
Amazon Redshift
Amazon ElastiCache
Amazon RDS
Amazon Elastic File System (Amazon EFS)
Explanations:
Amazon Redshift is primarily used for data warehousing, not for running MySQL databases.
Amazon ElastiCache is used for in-memory caching, not as a primary relational database service.
Amazon RDS provides managed MySQL databases, reducing administrative overhead on AWS.
Amazon EFS is a file storage service, not intended for database hosting or management.