SAP-C02 Question 515
Select 2A company hosts a multi-tier web application on AWS. The application uses an Application Load Balancer (ALB) to distribute traffic to a fleet of Amazon EC2 instances in an Auto Scaling group. The backend database is hosted on Amazon RDS. The company has recently experienced a significant increase in traffic, resulting in slower response times. Upon investigation, you determine that the database is the bottleneck. You need to implement a scalable solution to improve database performance while keeping costs under control. Which combination of actions should you take?
- A
Enable Amazon ElastiCache to cache frequently accessed data and reduce database load
- B
Use Amazon RDS Read Replicas to offload read-intensive queries from the primary database
- C
Upgrade the RDS instance type to a larger instance with more CPU and memory
- D
Migrate the database to Amazon DynamoDB for better scalability
- E
Deploy the database in a Multi-AZ configuration for higher availability
Show answer and explanation
Correct answers: A, B
Explanation
To address the performance bottleneck caused by the database, you can implement solutions that scale the read and write operations. Amazon ElastiCache reduces database load by caching frequently accessed data, while RDS Read Replicas offload read-heavy queries. These solutions are cost-effective and scalable, making them suitable for the given scenario. Upgrading the instance type or switching to DynamoDB may not be ideal due to cost, complexity, or unnecessary changes to the architecture. Multi-AZ improves availability but does not directly solve performance issues.
- A. Correct.
Enabling Amazon ElastiCache allows caching of frequently accessed data, which can significantly reduce the load on the database and improve response times.
- B. Correct.
Using Amazon RDS Read Replicas offloads read-intensive queries from the primary database, helping scale the read operations and improving performance.
- C. Incorrect.
Upgrading the RDS instance type might temporarily improve performance, but it does not provide scalability in the long term and can increase costs significantly.
- D. Incorrect.
While Amazon DynamoDB is highly scalable, migrating from RDS to DynamoDB is a complex and time-consuming process that may not be necessary for this scenario.
- E. Incorrect.
Deploying the database in a Multi-AZ configuration improves availability and fault tolerance but does not address the performance bottleneck in this case.