SAA-C03 Question 206
Single answerYou are designing a high-traffic application that connects to an Amazon RDS database. You have noticed an increase in connection churn and inefficient connection management during traffic spikes, which is affecting database performance. How can you improve the application’s scalability and ensure efficient database connection management?
- A
Use Amazon RDS Proxy to manage database connections and optimize connection pooling.
- B
Increase the size of the Amazon RDS instance to handle more database connections.
- C
Deploy an Amazon ElastiCache cluster in front of your Amazon RDS database.
- D
Enable Amazon Aurora Serverless to auto-scale the database capacity based on demand.
Show answer and explanation
Correct answer: A
Explanation
Amazon RDS Proxy is designed to manage database connection pooling efficiently, which reduces the overhead of opening and closing database connections during traffic spikes. This makes it an ideal solution for applications with unpredictable or spiky workloads, as it improves scalability and minimizes the impact on the database.
- A. Correct.
Correct: Amazon RDS Proxy helps manage database connections by pooling and reusing connections, reducing connection churn and improving scalability for high-traffic applications.
- B. Incorrect.
Incorrect: Simply increasing the database instance size might temporarily address the issue, but it does not directly solve inefficient connection management or connection churn during spikes.
- C. Incorrect.
Incorrect: Amazon ElastiCache is used to improve application performance by caching frequently accessed data, but it does not address database connection management.
- D. Incorrect.
Incorrect: Amazon Aurora Serverless provides auto-scaling for database capacity but does not help with connection pooling or reducing connection churn.