CompTIA
CV0-003 · Question #921
CV0-003 Question #921: Real Exam Question with Answer & Explanation
Sign in or unlock CV0-003 to reveal the answer and full explanation for question #921. The question stem and answer options stay visible for context.
Troubleshooting
Question
A systems administrator is diagnosing performance issues on a web application. The web application sends thousands of extremely complex SQL queries to a database server, which has trouble retrieving the information in time. The administrator checks the database server and notes the following resource utilization: - CPU: 64% - RAM: 97% - Network throughput: 384/1000 Kbps - Disk throughput: 382,700 Kbps The administrator also notices that the storage for the database server is consistently near its IOPS limit. Which of the following will best resolve these performance issues?
Options
- AIncrease CPU resources on the database server.
- BIncrease caching on the database server.
- CPut the storage and the database on the same VLAN.
- DEnable compression on storage traffic.
- EEnable deduplication on the storage appliance.
Unlock CV0-003 to see the answer
You've previewed enough free CV0-003 questions. Unlock CV0-003 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.
Topics
#database performance#RAM utilization#IOPS#caching