IBM
C2180-317 · Question #17
C2180-317 Question #17: Real Exam Question with Answer & Explanation
Sign in or unlock C2180-317 to reveal the answer and full explanation for question #17. The question stem and answer options stay visible for context.
Question
While monitoring a JDBC data source's performance during a test load, a system administrator notices that there are a large number of prepared statements discarded from the cache. In order to improve application throughput, how should the administrator tune the data source?
Options
- AIncrease the size of the prepared statement cache until there are no statement discards under load.
- BIncrease the maximum connection pool size and keep the prepared statement cache at its default size.
- CSet the connection pool purge policy to "EntirePool" and increase the maximum connection pool size.
- DSet the minimum connection pool size equal to the maximum connection pool size and keep the prepared
Unlock C2180-317 to see the answer
You've previewed enough free C2180-317 questions. Unlock C2180-317 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.