SAA-C03 Question 205
Select 3Your company is running an application that connects to an Amazon RDS database. Recently, the application has experienced connection exhaustion issues during traffic spikes, causing downtime. To address this, you decide to implement Amazon RDS Proxy. Which benefits does Amazon RDS Proxy provide in this scenario?
- A
Improves application scalability by pooling and sharing database connections.
- B
Encrypts data in transit between the application and the database.
- C
Allows for database read replicas to be used automatically for write operations.
- D
Reduces the need for application retries during failovers.
- E
Automatically scales the underlying RDS instance during high traffic.
Show answer and explanation
Correct answers: A, B, D
Explanation
Amazon RDS Proxy is designed to improve the performance and availability of applications that use Amazon RDS. It achieves this by pooling and sharing database connections, encrypting data in transit, and minimizing downtime during failovers. However, it does not automatically scale the database instance or enable write operations on read replicas.
- A. Correct.
Correct. Amazon RDS Proxy pools and shares database connections, which helps prevent connection exhaustion and improves application scalability.
- B. Correct.
Correct. Amazon RDS Proxy ensures data in transit is encrypted using TLS, enhancing security.
- C. Incorrect.
Incorrect. Amazon RDS Proxy does not route write operations to read replicas; read replicas are used for read-only queries and require manual configuration.
- D. Correct.
Correct. Amazon RDS Proxy reduces downtime during database failovers by automatically handling connection retries, improving application availability.
- E. Incorrect.
Incorrect. Amazon RDS Proxy does not scale the underlying RDS instance. Scaling the instance must be done manually or using other AWS features like Auto Scaling.