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 financial services company launched a new application that uses an Amazon RDS for MySQL database. The company uses the application to track stock market trends. The company needs to operate the application for only 2 hours at the end of each week. The company needs to optimize the cost of running the database.
Which solution will meet these requirements MOST cost-effectively?
Other
Community
UAnonymous
A
Migrate the existing RDS for MySQL database to an Aurora Serverless v2 MySQL database cluster.
B
Migrate the existing RDS for MySQL database to an Aurora MySQL database cluster.
C
Migrate the existing RDS for MySQL database to an Amazon EC2 instance that runs MySQL. Purchase an instance reservation for the EC2 instance.
D
Migrate the existing RDS for MySQL database to an Amazon Elastic Container Service (Amazon ECS) cluster that uses MySQL container images to run tasks.
Explanation:
Explanation
Correct Answer: A - Migrate the existing RDS for MySQL database to an Aurora Serverless v2 MySQL database cluster.
Why Option A is Correct:
- Aurora Serverless v2 is designed for intermittent workloads where the database can scale to zero when not in use.
- The company only needs the database for 2 hours per week - Aurora Serverless v2 can automatically pause when there's no activity and resume when needed.
- With Aurora Serverless v2, you only pay for the compute capacity you consume on a per-second basis, making it highly cost-effective for sporadic usage patterns.
- It automatically scales capacity up and down based on application demand, eliminating the need for manual capacity planning.
Why Other Options Are Not Optimal:
Option B - Aurora MySQL database cluster:
- Aurora standard clusters run 24/7 with fixed capacity, incurring costs even during idle periods.
- Not cost-effective for a workload that only runs 2 hours per week.
Option C - EC2 instance with MySQL and instance reservation:
- Instance reservations require upfront payment and commitment for 1-3 years.
- The EC2 instance would still run 24/7 unless manually stopped/started, which adds operational overhead.
- Even with reservations, you're paying for capacity you don't use most of the time.
Option D - ECS cluster with MySQL containers:
- ECS clusters require underlying EC2 instances or Fargate compute.
- Similar to EC2, this would require running infrastructure 24/7 or complex scheduling.
- Container orchestration adds complexity without addressing the core cost optimization need.
Key AWS Cost Optimization Principles Applied:
- Right-sizing: Aurora Serverless v2 automatically right-sizes compute capacity.
- Pay for what you use: With Aurora Serverless v2, you only pay when the database is active.
- Automated scaling: Eliminates the need for manual intervention to start/stop instances.
For a database that's only needed 2 hours per week (approximately 104 hours per year), Aurora Serverless v2 provides the most cost-effective solution by eliminating idle compute costs.
Comments
Loading comments...