Which solution will meet these requirements?

By:
In: SAA-C03
Tagged:
With: 1 Comment
A company has a web application with sporadic usage patterns.There is heavy usage at the beginning of each month, moderate usage at the start of each week, and unpredictable usage during the week.The application consists of a web server and a MySQL database server running inside the data center.The company would like to move the application to the AWS Cloud, and needs to select a cost-effective database platform that will not require database modifications.

Which solution will meet these requirements?

Amazon DynamoDB

Amazon RDS for MySQL

MySQL-compatible Amazon Aurora Serverless

MySQL deployed on Amazon EC2 in an Auto Scaling group

Explanations:

Amazon DynamoDB is a NoSQL database service that requires significant changes to the application code and data model, which goes against the requirement of no database modifications.

Amazon RDS for MySQL is a managed relational database service but does not offer automatic scaling based on usage patterns, which may lead to cost inefficiencies during low usage periods.

MySQL-compatible Amazon Aurora Serverless automatically scales the database capacity based on application demand and is compatible with existing MySQL applications, requiring no database modifications.

Deploying MySQL on Amazon EC2 in an Auto Scaling group would require more management overhead and may not be cost-effective due to the need to manage the EC2 instances and potentially underutilized resources during low usage periods.

2025-10-16

1 Comment

  1. Kathryn
    Author

    If I’m not mistaken, the answer is:
    MySQL-compatible Amazon Aurora Serverless

Leave a Reply

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

7 + eight =