AWS Certified Solutions Architect – Associate (SAA-C02) — Question 401

A company manages its own Amazon EC2 instances that run MySQL databases. The company is manually managing replication and scaling as demand increases or decreases. The company needs a new solution that simplifies the process of adding or removing compute capacity to or from its database tier as needed. The solution also must offer improved performance, scaling, and durability with minimal effort from operations.
Which solution meets these requirements?

Answer options

• A. Migrate the databases to Amazon Aurora Serverless for Aurora MySQL.
• B. Migrate the databases to Amazon Aurora Serverless for Aurora PostgreSQL.
• C. Combine the databases into one larger MySQL database. Run the larger database on larger EC2 instances.
• D. Create an EC2 Auto Scaling group for the database tier. Migrate the existing databases to the new environment.

Correct answer: A

Explanation

Amazon Aurora Serverless for Aurora MySQL is the ideal solution because it automatically scales database capacity up or down based on application demand, ensuring high performance and durability with minimal operational effort. Migrating to Aurora PostgreSQL is incorrect because the existing databases are MySQL-based, which would require an unnecessary database engine conversion. Options C and D still require manual database administration and replication management, failing to meet the requirement for minimal operational effort.