SAP-C02 Question 357
Single answerA company uses an Amazon RDS Multi-AZ deployment for its critical production database to ensure high availability. Recently, the database usage has increased significantly, leading to performance bottlenecks. The company wants to improve read scalability while ensuring minimal changes to the existing architecture. What is the BEST solution to address this requirement?
- A
Add Amazon RDS Read Replicas and configure the application to offload read queries to the replicas.
- B
Upgrade the RDS instance to a larger instance type with higher IOPS.
- C
Enable RDS Performance Insights and tune the database queries.
- D
Deploy a caching solution using Amazon ElastiCache to handle read-heavy workloads.
Show answer and explanation
Correct answer: A
Explanation
Adding Amazon RDS Read Replicas is the best solution as it directly improves read scalability by offloading read queries from the primary database. This approach ensures high performance while requiring minimal changes to the existing architecture. Other options either involve significant architectural changes, increased costs, or do not directly address the scalability requirement.
- A. Correct.
This is the correct answer. Amazon RDS Read Replicas are specifically designed to improve read scalability by offloading read queries from the primary database. This approach also ensures minimal changes to the existing architecture since the primary database remains unaffected.
- B. Incorrect.
While upgrading the RDS instance might improve overall database performance, it does not specifically address read scalability. Additionally, upgrading the instance could increase costs significantly without solving the problem efficiently.
- C. Incorrect.
Enabling RDS Performance Insights can help identify problematic queries, but it does not directly improve read scalability. It is more of a diagnostic tool than a solution to handle a read-heavy workload.
- D. Incorrect.
Deploying Amazon ElastiCache can improve performance by caching frequently accessed data, but it requires significant changes to the application architecture to integrate caching effectively. It is not the most efficient solution for the given requirement of improving read scalability with minimal changes.