SAP-C02 Question 360
Select 3Your company has an e-commerce platform hosted on AWS, which handles millions of user transactions daily. Currently, the application is deployed using an Auto Scaling group behind an Application Load Balancer (ALB) in multiple Availability Zones. After a recent performance review, you identified that your database tier, hosted on Amazon RDS for MySQL, is becoming a bottleneck during peak loads. The team has asked you to implement improvements to the database tier to handle these performance issues while keeping costs reasonable. Which of the following actions should you take to improve the system's performance and scalability?
- A
Enable Amazon RDS read replicas to offload read traffic from the primary database.
- B
Migrate the database to Amazon Aurora for MySQL to leverage its distributed architecture and read scaling capabilities.
- C
Increase the instance size of the Amazon RDS for MySQL database to a larger instance type for higher CPU and memory resources.
- D
Implement Amazon ElastiCache to cache frequently accessed queries and reduce database load.
- E
Switch to deploying the database on Amazon EC2 instances for full control over the database and server configuration.
Show answer and explanation
Correct answers: A, B, D
Explanation
To improve scalability and performance of the database layer, you can offload read traffic using Amazon RDS read replicas or migrate to Amazon Aurora for its distributed architecture and read scaling capabilities. Additionally, implementing Amazon ElastiCache for caching frequently accessed queries helps reduce database load. Increasing the instance size or moving to Amazon EC2 are less optimal solutions for addressing the root cause of the scalability issue.
- A. Correct.
Enabling Amazon RDS read replicas is a valid approach to offload read traffic from the primary database, improving scalability and performance.
- B. Correct.
Migrating to Amazon Aurora for MySQL can provide better scalability and performance due to its distributed nature and built-in support for multiple read replicas.
- C. Incorrect.
Increasing the instance size can temporarily alleviate performance issues but is not a cost-effective or scalable long-term solution for handling high read traffic.
- D. Correct.
Using Amazon ElastiCache to cache frequently accessed queries reduces the load on the database, improving performance and scalability.
- E. Incorrect.
Deploying the database on Amazon EC2 instances adds unnecessary operational complexity and does not inherently solve the scalability issue for high-traffic applications.