Which solution will meet these requirements?

By: study aws cloud

On: January 7, 2025

Tagged: Solutions Architect Associate

With: 0 Comments

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.

Previous Post: Which solution will provide a consistent user experience that will allow the application and database tiers to scale?

Next Post: Which combination of the following actions MOST satisfies this requirement?

Leave a Reply Cancel reply