AWS Certified Cloud Practitioner — Question 318

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?

Answer options

• A. Amazon Redshift
• B. Amazon ElastiCache
• C. Amazon RDS
• D. Amazon Elastic File System (Amazon EFS)

Correct answer: C

Explanation

Amazon RDS is a managed service that automates time-consuming administration tasks such as hardware provisioning, database setup, patching, and backups for relational databases like MySQL. Amazon Redshift is designed for analytical data warehousing, while Amazon ElastiCache is for in-memory caching, making them unsuitable for direct transactional database migration. Amazon EFS is a shared file system and does not function as a database service.