SAA-C03 Question 297
Select 4A company runs a highly transactional e-commerce application and uses Amazon RDS for its database backend. The application experiences fluctuating traffic patterns, with peak usage during sales events. The operations team has noticed performance bottlenecks during peak traffic, including high latency for read and write operations. As a Solutions Architect, which of the following solutions would help address the performance issues while optimizing costs?
- A
Enable Auto Scaling for Amazon RDS to dynamically increase the instance size during peak traffic.
- B
Migrate to an Amazon RDS instance type with more CPU and memory capacity, such as moving from db.m5.large to db.m5.xlarge.
- C
Use Amazon RDS Provisioned IOPS (PIOPS) for the database storage to handle higher I/O requirements.
- D
Implement Amazon ElastiCache as a caching layer in front of the database to reduce the load on the database.
- E
Read replicas can be created to offload read queries from the primary database instance.
Show answer and explanation
Correct answers: B, C, D, E
Explanation
To address performance bottlenecks in a transactional application, scaling the database instance type (Option 2) and leveraging Provisioned IOPS (Option 3) can improve performance for read and write operations. Adding a caching solution like Amazon ElastiCache (Option 4) can reduce database load by serving frequent queries from the cache. Additionally, creating read replicas (Option 5) can offload read-heavy workloads from the primary database. Option 1 is incorrect because RDS does not support Auto Scaling of instance sizes; such scaling must be performed manually or by using Aurora Serverless.
- A. Incorrect.
Amazon RDS does not support Auto Scaling for instance sizes. You must scale the instance size manually or use Aurora Serverless for automatic scaling.
- B. Correct.
Scaling up to a larger instance type with more CPU and memory can help handle increased traffic and improve database performance during peak periods.
- C. Correct.
Provisioned IOPS provides predictable and consistent performance for database storage, which is ideal for handling high I/O workloads, such as a transactional e-commerce application.
- D. Correct.
Using Amazon ElastiCache as a caching layer reduces the load on the database by serving frequently accessed data from the cache, improving overall performance.
- E. Correct.
Read replicas offload read queries from the primary database, reducing its load and improving responsiveness during traffic spikes.