SAP-C02 Question 651
Select 3A company is running a global e-commerce platform hosted on AWS. The platform uses Amazon RDS for PostgreSQL as the primary database. During peak traffic, the database experiences performance degradation due to high read traffic. The company wants to improve database performance while ensuring high availability and fault tolerance. Which of the following approaches should you implement?
- A
Enable Amazon RDS Read Replicas and configure the application to distribute read traffic to the replicas.
- B
Enable Multi-AZ deployment for the Amazon RDS instance to handle read traffic from the secondary database.
- C
Use Amazon ElastiCache to cache frequently accessed data and reduce database read load.
- D
Migrate the database to Amazon Aurora with read replicas for improved performance and scalability.
- E
Set up an Amazon S3 bucket to store read-heavy data and query it directly to offload the database.
Show answer and explanation
Correct answers: A, C, D
Explanation
To address high read traffic and improve database performance, the company can leverage Amazon RDS Read Replicas to offload read traffic, use Amazon ElastiCache for caching frequently accessed data, and consider migrating to Amazon Aurora, which provides better read scalability with optimized read replicas. Multi-AZ deployment is not relevant for improving read performance, and using Amazon S3 for database queries is not a feasible option.
- A. Correct.
Correct: Amazon RDS Read Replicas can be used to offload read traffic from the primary database, improving performance during high read workloads.
- B. Incorrect.
Incorrect: Multi-AZ is designed for high availability and failover, but it does not provide additional read capacity as the secondary database is not accessible for reads.
- C. Correct.
Correct: Amazon ElastiCache can be used as an in-memory data store to cache frequently accessed data, reducing the read load on the primary database.
- D. Correct.
Correct: Amazon Aurora offers better performance and scalability than standard RDS, and its read replicas are highly optimized for handling read traffic.
- E. Incorrect.
Incorrect: Amazon S3 is not designed for querying relational data or acting as a database replacement for read-heavy workloads.