AWS Certified Solutions Architect – Associate (SAA-C03) — Question 250

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

The correct answer is A because Amazon Aurora Serverless for Aurora MySQL automatically adjusts compute capacity as needed, providing improved performance and reducing manual management. Option B is incorrect as it refers to PostgreSQL instead of MySQL. Option C does not address the need for dynamic scaling and increases operational complexity. Option D involves setting up an Auto Scaling group, which still requires manual intervention in terms of database migration and management.