AWS Certified Cloud Practitioner — Question 172

A company's IT team is managing MySQL database server clusters. The IT team has to patch the database and take backup snapshots of the data in the clusters.
The company wants to move this workload to AWS so that these tasks will be completed automatically.
What should the company do to meet these requirements?

Answer options

• A. Deploy MySQL database server clusters on Amazon EC2 instances.
• B. Use Amazon RDS with a MySQL database.
• C. Use an AWS CloudFormation template to deploy MySQL database servers on Amazon EC2 instances.
• D. Migrate all the MySQL database data to Amazon S3.

Correct answer: B

Explanation

The correct answer is B because Amazon RDS provides a managed database service that automates patching, backups, and scaling for MySQL databases, meeting the company's requirements for automation. Option A requires manual management and does not provide the automation needed. Option C also involves managing the EC2 instances directly, which does not fulfill the automation goal. Option D is not applicable as S3 is not a database service and cannot replace the functionality of a MySQL database.