Exam AWS Certified Database - Specialty topic 1 question 292 discussion

Exam question from Amazon's AWS Certified Database - Specialty

Question #: 292
Topic #: 1

[All AWS Certified Database - Specialty Questions]

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?

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.

Show Suggested Answer

Suggested Answer: C 🗳️

by rdiaz at March 26, 2023, 4:19 p.m.

Disclaimers:

- ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
- Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Submit Cancel

rdiaz

Highly Voted 2 years, 2 months ago

Selected Answer: C

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/rds-proxy-managing.html#rds-proxy-connection-pooling-tuning.maxidleconnectionspercent

upvoted 5 times

Mintwater

2 years, 2 months ago

MaxIdleConnectionsPercent "You can control the number of idle database connections that RDS Proxy can keep in the connection pool. RDS Proxy considers a database connection in it's pool to be idle when there's been no activity on the connection for five minutes. You specify the limit as a percentage of the maximum connections available for your database. The default value is 50 percent of MaxConnectionsPercent, and the upper limit is the value of MaxConnectionsPercent. With a high value, the proxy leaves a high percentage of idle database connections open. With a low value, the proxy closes a high percentage of idle database connections. If your workloads are unpredictable, consider setting a high value for MaxIdleConnectionsPercent. Doing so means that RDS Proxy can accommodate surges in activity without opening a lot of new database connections."

upvoted 2 times

...

DanShone

Most Recent 1 year, 8 months ago

Selected Answer: C

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/rds-proxy-managing.html#rds-proxy-connection-pooling-tuning.maxidleconnectionspercent

upvoted 1 times

...

Windy

1 year, 10 months ago

It's C.

upvoted 1 times

...