SAA-C03 Question 476
Single answerA small e-commerce company is experiencing rapid growth and wants to optimize the cost of their database solution for their online store. Currently, they are using a single Amazon RDS MySQL instance with minimal read traffic, but they expect traffic to increase significantly during holiday sales. They want a solution that can handle spikes in read traffic cost-effectively while minimizing operational overhead. Which solution is the most cost-optimized for their use case?
- A
Enable Multi-AZ deployment for Amazon RDS MySQL to improve availability during traffic spikes.
- B
Scale up the Amazon RDS instance to a larger instance type to handle increased traffic.
- C
Configure Amazon RDS MySQL to use Read Replicas to offload read traffic.
- D
Migrate to Amazon Aurora with Auto Scaling to automatically adjust capacity.
Show answer and explanation
Correct answer: C
Explanation
Using Read Replicas with Amazon RDS MySQL is the most cost-optimized solution in this scenario. Read Replicas allow the company to handle increased read traffic by distributing it across multiple replicas without scaling up the primary database. This approach is cost-efficient and minimizes operational overhead compared to alternatives like scaling up the instance or migrating to a more complex database solution.
- A. Incorrect.
Enabling Multi-AZ deployment improves availability and failover capabilities but does not address cost optimization for read traffic, as it only creates a standby database instance, not a read replica.
- B. Incorrect.
Scaling up the RDS instance increases capacity but is not cost-optimized. A larger instance incurs higher costs and may not fully utilize resources during non-peak periods.
- C. Correct.
Configuring Read Replicas offloads read traffic from the primary database, which is a cost-effective way to handle spikes in read traffic without scaling up the primary instance.
- D. Incorrect.
Migrating to Amazon Aurora with Auto Scaling could be a viable solution for large-scale applications, but it may not be cost-effective for a small e-commerce company with relatively low traffic outside peak periods.