SOA-C02 Question 314
Single answerYour organization is running an on-premises MySQL database for a business-critical application. The database requires frequent patching, backups, and performance tuning, which currently consume significant time for the operations team. Management wants to migrate this database to AWS to reduce the operational overhead associated with maintenance. Which AWS service would best meet these requirements while minimizing operational effort?
- A
Amazon RDS
- B
Amazon EC2 with MySQL installed
- C
AWS Fargate
- D
Amazon EFS
Show answer and explanation
Correct answer: A
Explanation
Amazon RDS is the ideal choice for migrating the on-premises MySQL database to AWS because it is a fully managed service that automates routine database maintenance tasks. This significantly reduces the operational burden on the team while ensuring the database remains performant and secure.
- A. Correct.
Amazon RDS is a managed database service that automates tasks such as backups, patching, and performance tuning for databases, making it the best choice to reduce operational overhead.
- B. Incorrect.
Running MySQL on Amazon EC2 would still require you to handle backups, patching, and performance tuning manually, which does not address the goal of minimizing operational effort.
- C. Incorrect.
AWS Fargate is a serverless compute engine for containers and is not designed for running relational databases like MySQL.
- D. Incorrect.
Amazon EFS is a fully managed file storage service and is not suitable for hosting relational databases like MySQL.