AWS Certified Solutions Architect - Associate
Get started today
Ultimate access to all questions.
Deep dive into the quiz with AI chat providers.
We prepare a focused prompt with your quiz and certificate details so each AI can offer a more tailored, in-depth explanation.
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?
Other
Community
UAnonymous
A
Amazon DynamoDB
B
Amazon RDS for MySQL
C
MySQL-compatible Amazon Aurora Serverless
D
MySQL deployed on Amazon EC2 in an Auto Scaling group
Explanation:
Explanation
MySQL-compatible Amazon Aurora Serverless (Option C) is the correct solution for the following reasons:
Key Requirements Analysis:
- Sporadic usage patterns - Heavy usage at beginning of each month, moderate usage at start of each week, unpredictable usage during the week
- Cost-effective solution - Need to minimize costs during low usage periods
- No database modifications required - Must be compatible with existing MySQL database
- Moving from on-premises MySQL to AWS Cloud
Why Aurora Serverless is the Best Choice:
Automatic Scaling:
- Aurora Serverless automatically scales database capacity up and down based on actual usage
- Perfect for sporadic workloads where usage is unpredictable
- Scales to zero when not in use (cost savings)
Cost Optimization:
- Pay only for the database capacity you use
- No need to provision for peak capacity that sits idle most of the time
- Automatic pause during idle periods reduces costs significantly
MySQL Compatibility:
- Aurora Serverless is fully compatible with MySQL
- No database modifications required
- Uses the same MySQL protocol and APIs
Managed Service Benefits:
- AWS handles patching, backups, and maintenance
- High availability with multi-AZ deployments
- Automated failover
Why Other Options Are Not Optimal:
A. Amazon DynamoDB:
- NoSQL database, not compatible with MySQL
- Would require significant application/database modifications
- Not suitable for relational data without major changes
B. Amazon RDS for MySQL:
- Requires provisioning fixed capacity
- Not cost-effective for sporadic usage (pay for idle capacity)
- Manual scaling required
D. MySQL on EC2 with Auto Scaling:
- Complex to manage scaling for databases
- Auto Scaling groups work better for stateless applications
- Database replication and data consistency challenges with scaling
- Requires manual management of database software
Cost Comparison:
- Aurora Serverless: Pay per ACU (Aurora Capacity Unit) per second, scales to zero
- RDS MySQL: Pay for provisioned instance 24/7 regardless of usage
- EC2: Pay for EC2 instances + EBS storage + management overhead
Performance Considerations:
- Aurora Serverless provides fast scaling (typically within 5 seconds)
- Maintains connections during scaling operations
- Built-in read replicas for high availability
Conclusion: Aurora Serverless provides the perfect balance of MySQL compatibility, automatic scaling for sporadic workloads, and cost optimization by only charging for actual usage.
Comments
Loading comments...