Which solution meets these requirements?

By:
In: SAA-C03
Tagged:
With: 1 Comment
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?

Migrate the databases to Amazon Aurora Serverless for Aurora MySQL.

Migrate the databases to Amazon Aurora Serverless for Aurora PostgreSQL.

Combine the databases into one larger MySQL database. Run the larger database on larger EC2 instances.

Create an EC2 Auto Scaling group for the database tier. Migrate the existing databases to the new environment.

Explanations:

Amazon Aurora Serverless for Aurora MySQL automatically scales the compute capacity up or down based on demand, simplifying management and improving performance and durability without manual intervention.

While Amazon Aurora Serverless for Aurora PostgreSQL also offers automatic scaling and improved performance, the requirement specifies a MySQL database, making this option unsuitable.

Combining databases into one larger MySQL database on larger EC2 instances does not simplify scaling or management. It may lead to performance bottlenecks and still requires manual intervention for scaling.

Creating an EC2 Auto Scaling group for the database tier does not address the inherent complexities of managing MySQL replication and scaling effectively, and still requires significant operational effort compared to a serverless solution.

2025-10-06

1 Comment

  1. Helen
    Author

    I structure that the answer is:
    Migrate the databases to Amazon Aurora Serverless for Aurora MySQL.

Leave a Reply

Your email address will not be published. Required fields are marked *

nineteen − 13 =