Question #1455
A company migrated its on-premises MySQL database to Amazon RDS for MySQL. Following a seasonal sales event, the database workload has significantly increased. The company aims to manage the higher workload cost-effectively without provisioning additional infrastructure.
Which solution BEST meets these requirements?
Purchase reserved DB instances and scale up the Amazon RDS for MySQL instance size.
Convert the Amazon RDS for MySQL instance to a Multi-AZ deployment.
Purchase reserved DB instances and launch an additional Amazon RDS for MySQL instance.
Switch the Amazon RDS for MySQL instance to on-demand pricing.
Explanation
Answer A is correct because:
- Reserved DB Instances: Purchasing reserved instances reduces costs compared to on-demand pricing, aligning with the goal of cost-effectiveness.
- Scaling Up: Increasing the RDS instance size (vertical scaling) improves compute, memory, and storage capacity to handle the higher workload without provisioning additional infrastructure.
Other options are incorrect because:
- B (Multi-AZ): Multi-AZ deployments provide high availability but do not improve performance for read/write workloads.
- C (Additional Instance): Launching a new RDS instance adds infrastructure, which violates the requirement.
- D (On-Demand Pricing): On-demand is more expensive than reserved instances, making it less cost-effective.
Key Points: Use reserved instances for cost savings and vertical scaling (scaling up) to manage workload spikes without adding new resources.
Answer
The correct answer is: A