AWS Certified Database – Specialty — Question 214

A database specialist observes several idle connections in an Amazon RDS for MySQL DB instance. The DB instance is using RDS Proxy. An application is configured to connect to the proxy endpoint.

What should the database specialist do to control the idle connections in the database?

Answer options

• A. Modify the MaxConnectionsPercent parameter through the RDS Proxy console.
• B. Use CALL mysql.rds_kill(thread-id) for the IDLE threads that are returned from the SHOW FULL PROCESSLIST command.
• C. Modify the MaxIdleConnectionsPercent parameter for the RDS proxy.
• D. Modify the max_connections configuration setting for the DB instance. Modify the ConnectionBorrowTimeout parameter for the RDS proxy.

Correct answer: C

Explanation

The correct answer is C because modifying the MaxIdleConnectionsPercent parameter specifically targets the proportion of idle connections allowed in the RDS Proxy, directly addressing the issue. Options A and D do not pertain to idle connections but rather overall connection limits, while option B addresses killing idle threads manually, which is not a sustainable solution.