AWS Certified Solutions Architect – Professional (SAP-C02) — Question 294

A company's solutions architect is evaluating an AWS workload that was deployed several years ago. The application tier is stateless and runs on a single large Amazon EC2 instance that was launched from an AMI. The application stores data in a MySQL database that runs on a single EC2 instance.

The CPU utilization on the application server EC2 instance often reaches 100% and causes the application to stop responding. The company manually installs patches on the instances. Patching has caused downtime in the past. The company needs to make the application highly available.

Which solution will meet these requirements with the LEAST development me?

Answer options

Correct answer: D

Explanation

Migrating the application to an Auto Scaling group behind an Application Load Balancer resolves the CPU bottleneck and provides high availability without requiring code changes. Using AWS Systems Manager Agent (SSM Agent) enables automated, non-disruptive patching, while migrating the MySQL database to Amazon Aurora MySQL provides a highly available, fully compatible managed database with minimal migration effort. Other options involve migrating to different database paradigms (NoSQL, Document, or Graph) or refactoring the application code (Lambda or Docker), which would require significant development time.