SAP-C02 Question 104
Select 2A company is running a high-traffic e-commerce application on AWS. The application uses an Auto Scaling group for the web tier behind an Application Load Balancer (ALB) and stores transaction data in an Amazon RDS database. During seasonal sales events, the application experiences significant spikes in traffic, leading to increased database query latency. The company wants to optimize database performance during these spikes while minimizing changes to the application architecture. What should the Solutions Architect recommend?
- A
Enable Amazon RDS Read Replicas and configure the application to distribute read queries to the replicas.
- B
Scale the Amazon RDS instance vertically by selecting a larger instance type.
- C
Use Amazon ElastiCache for Redis to cache frequently accessed query results.
- D
Migrate the Amazon RDS database to Amazon DynamoDB to improve performance at scale.
- E
Enable Amazon RDS Multi-AZ deployment for improved read performance.
Show answer and explanation
Correct answers: A, C
Explanation
The best solutions for optimizing database performance during traffic spikes are enabling RDS Read Replicas to handle additional read queries and using Amazon ElastiCache to cache frequently accessed data. These approaches minimize changes to the application architecture while effectively reducing database load. Scaling the RDS instance vertically or migrating to DynamoDB would require more effort and are less suitable for handling temporary spikes. Multi-AZ is focused on availability, not performance.
- A. Correct.
This option is correct. Using Amazon RDS Read Replicas allows the application to offload read queries to the replicas, reducing the load on the primary database and improving performance during traffic spikes.
- B. Incorrect.
While scaling the RDS instance vertically can improve performance, it may not be the most cost-effective or scalable solution for handling spikes during seasonal events. Additionally, it could lead to downtime during the scaling process.
- C. Correct.
This option is correct. Amazon ElastiCache for Redis can cache frequently accessed query results, reducing the number of database queries and improving overall application performance during high-traffic events.
- D. Incorrect.
Migrating to DynamoDB would require significant changes to the application architecture and is not necessary for addressing temporary spikes in traffic.
- E. Incorrect.
Multi-AZ deployment is designed for high availability and failover rather than improving read performance. It does not address the query latency issue directly.