SAP-C02 Question 79
Select 2A company is running a multi-tier e-commerce application on AWS. The application consists of an Application Load Balancer (ALB), an Auto Scaling group of Amazon EC2 instances for the web tier, an Amazon RDS database for the database tier, and Amazon S3 for static content. The company is experiencing intermittent slow responses from the application during traffic spikes, and the database is frequently hitting its connection limit. What should a Solutions Architect do to improve the application's performance and scalability?
- A
Enable Amazon RDS Proxy to manage database connections more efficiently.
- B
Configure Amazon ElastiCache to cache frequently accessed queries.
- C
Increase the size of the Amazon RDS instance to handle more database connections.
- D
Use AWS Global Accelerator to reduce latency for the application.
- E
Enable sticky sessions on the Application Load Balancer.
Show answer and explanation
Correct answers: A, B
Explanation
The root causes of the performance issues are the database hitting its connection limit and heavy demand on the database during traffic spikes. Using Amazon RDS Proxy helps manage and pool database connections efficiently, reducing the load on the database. Additionally, implementing Amazon ElastiCache to cache frequently accessed queries reduces the database demand, improving response time during traffic bursts. These solutions address the underlying scalability and performance challenges of the application more effectively than increasing the RDS instance size or enabling sticky sessions.
- A. Correct.
Amazon RDS Proxy can help manage and pool database connections efficiently, reducing the load on the database and minimizing connection limit issues.
- B. Correct.
Amazon ElastiCache can cache frequently accessed queries, reducing the demand on the database and improving response time during traffic spikes.
- C. Incorrect.
Simply increasing the size of the RDS instance may temporarily address connection limits but does not solve the root cause of inefficient connection management or database demand.
- D. Incorrect.
AWS Global Accelerator is designed to improve application performance by routing traffic to the optimal endpoint but does not address application-level performance issues like database connection limits or caching.
- E. Incorrect.
Enabling sticky sessions on the ALB may help with session persistence but does not address the underlying performance and scalability issues in the database or application.