AWS Certified Solutions Architect Associate SAA-C03 Practice Question
A company has an online transaction processing (OLTP) workload on an Amazon RDS instance that experiences high read traffic during business hours. The database performance degrades due to the high number of read requests, impacting the user experience. Which of the following solutions should you implement to reduce the read load on the primary database instance and provide high-performing database responses?
Convert the database deployment to a Multi-AZ deployment for improved performance.
Implement Amazon ElastiCache to cache common queries and reduce the read load.
Increase the size of the existing database instance to a larger instance type.
Create multiple read replicas of the primary database instance and distribute the read traffic among them.