Q24 — AWS SAA-C03 Ch.13
Question 24 of 100 | ← Chapter 13
Q924. A company is designing an application to connect AWS Lambda functions to an Amazon RDS for MySQL DB instance.The DB instance manages many connections.The company needs to modify the application to improve connectivity and recovery.Which solution will meet these requirements with the LEAST operational overhead?
- A. Use Amazon RDS Proxy for connection pooling. Modify the application to use the RDS Proxy for connections to the DB instance. ✓
- B. Create a new RDS instance for connection pooling. Modify the application to use the new RDS instance for connectivity.
- C. Create read replicas to distribute the load of the DB instance. Create a Network Load Balancer to distribute the load across the read replicas
- D. Migrate the RDS for MySQL DB instance to Amazon Aurora MySQL to increase DB instance performance.
Correct Answer: A. Use Amazon RDS Proxy for connection pooling. Modify the application to use the RDS Proxy for connections to the DB instance.
Explanation
The solution that meets the requirements with the LEAST operational overhead is:A. Use Amazon RDS Proxy for connection pooling. Modify the application to use the RDS Proxy for connections to the DB instance.Here's why:RDS Proxy: RDS Proxy is a managed service that acts as a connection pooler and load balancer for your RDS instances. It handles connection management, reducing the overhead of establishing and maintaining connections from Lambda functions.Reduced Overhead: RDS Proxy eliminates the need for your application to manage connections directly, simplifying your code and reducing operational overhead.Improved Connectivity: Connection pooling helps improve connectivity by reusing existing connections, reducing latency and improving performance.Enhanced Recovery: RDS Proxy can automatically reconnect to the database instance in case of failures, improving application resilience.Why other options are less efficient:B. Create a new RDS instance for connection pooling. This approach requires creating and managing an additional RDS instance, increasing operational overhead and complexity.C. Create read replicas to distribute the load of the DB instance. Create a Network Load Balancer to distribute the load across the read replicas. While read replicas can improve performance, they don't address the issue of connection management and can add complexity to your application.D. Migrate the RDS for MySQL DB instance to Amazon Aurora MySQL to increase DB instance performance. Migrating to Aurora can improve performance, but it's a significant undertaking and doesn't directly address the connection management challenges.In summary:Using Amazon RDS Proxy (option A) is the most efficient and effective solution for improving connectivity and recovery for your Lambda functions connecting to an RDS for MySQL DB instance. It minimizes operational overhead and simplifies application development.