SAA-C03 Question 365
Single answerA company is running a high-traffic e-commerce website and has noticed that the current Amazon RDS database instance is experiencing high latency during peak times. They require a solution that can handle sudden spikes in traffic, provide read scalability, and meet their business performance requirements. What is the best approach to address this issue?
- A
Scale the RDS instance vertically by upgrading to a larger instance type.
- B
Enable Multi-AZ deployment for the RDS instance to improve performance.
- C
Add read replicas to the RDS instance to distribute read traffic.
- D
Migrate the database to Amazon DynamoDB for better scalability.
Show answer and explanation
Correct answer: C
Explanation
The best approach to address the company's requirements is to add read replicas to the RDS instance. This solution allows the company to handle sudden spikes in traffic by offloading read queries to replicas, thereby reducing latency and improving performance without requiring a complete migration or major architectural changes.
- A. Incorrect.
Scaling vertically (upgrading to a larger instance type) can improve performance temporarily but does not address the need for read scalability or sudden spikes in traffic. It also has limitations as hardware resources are finite.
- B. Incorrect.
Multi-AZ deployment provides high availability and failover support but does not directly improve database performance or handle read scalability issues.
- C. Correct.
Adding read replicas is the correct solution. Read replicas distribute read traffic across multiple instances, reducing latency during high traffic periods and providing better read scalability.
- D. Incorrect.
Migrating to Amazon DynamoDB might improve scalability but would require significant changes to the application and schema. This is not the most efficient solution for the given scenario as the company is already using Amazon RDS.