SAP-C02 Question 76
Single answerA company is using an Amazon RDS MySQL database to store transactional data for their e-commerce application. The application experiences unpredictable traffic spikes and requires low latency during these events. The company wants to ensure the database can handle these spikes while minimizing costs. What is the best solution to address this requirement?
- A
Enable Amazon RDS Multi-AZ Deployment to improve database performance during traffic spikes.
- B
Enable Amazon RDS Auto Scaling to automatically add more read and write capacity during traffic spikes.
- C
Configure Amazon RDS Read Replicas to handle read-heavy traffic and offload queries from the primary database.
- D
Upgrade the RDS instance to a larger instance class to handle the increased traffic.
Show answer and explanation
Correct answer: C
Explanation
The best solution for handling unpredictable traffic spikes in a cost-effective manner is to use Amazon RDS Read Replicas. Read Replicas allow the application to offload read-heavy traffic from the primary database, which can handle write operations. This approach ensures low latency during spikes while minimizing costs compared to upgrading the instance class. Multi-AZ deployment and instance upgrades address different concerns, such as availability or fixed capacity, but do not provide the dynamic scalability required in this scenario.
- A. Incorrect.
Amazon RDS Multi-AZ Deployment improves availability and failover capabilities, but it does not enhance database performance or scalability. It is designed for high availability and disaster recovery, not handling traffic spikes.
- B. Incorrect.
Amazon RDS Auto Scaling does not exist. RDS does not natively scale read and write capacity automatically. Instead, other features like Read Replicas or Aurora's Auto Scaling can be used for scalability.
- C. Correct.
Amazon RDS Read Replicas are specifically designed to improve read scalability by offloading read-heavy traffic from the primary database. This solution is cost-effective for handling unpredictable spikes in read traffic.
- D. Incorrect.
Upgrading the RDS instance class increases compute and memory resources, but it is a static solution that may increase costs significantly. It does not dynamically scale with traffic spikes, and may lead to over-provisioning.