SAA-C03 Question 170
Single answerA company is running an e-commerce application on Amazon EC2 instances behind an Application Load Balancer (ALB). The application stores transactional data in an Amazon RDS PostgreSQL database. The company wants to improve the scalability of the database to handle an increase in read traffic during peak times while ensuring high availability. Which solution should the Solutions Architect recommend?
- A
Enable Multi-AZ deployment for the RDS database.
- B
Create Read Replicas for the RDS database and configure the application to distribute read traffic to them.
- C
Upgrade the RDS database instance to a larger instance type.
- D
Enable Amazon ElastiCache in front of the database to cache frequent queries.
Show answer and explanation
Correct answer: B
Explanation
To improve read scalability for the RDS database, creating Read Replicas is the most appropriate solution. Read Replicas allow the read workload to be distributed across multiple database instances, reducing the burden on the primary database instance. This approach is commonly used to handle increased read traffic and is supported by Amazon RDS for PostgreSQL.
- A. Incorrect.
Enabling Multi-AZ deployment provides high availability and failover support for the RDS database but does not improve read scalability. This option addresses availability, not scalability.
- B. Correct.
Creating Read Replicas allows the database to handle increased read traffic by distributing the load across multiple instances. This directly addresses the requirement to improve read scalability during peak times.
- C. Incorrect.
Upgrading the RDS database instance to a larger instance type may improve performance temporarily but does not provide a scalable solution for handling increases in read traffic during peak times.
- D. Incorrect.
Amazon ElastiCache can improve performance by offloading query results from the database, but it requires specific configurations and may not be suitable for all types of transactional data. This option is not the most direct solution to the scalability issue.