Exam CV0-003 topic 1 question 250 discussion

Actual exam question from CompTIA's CV0-003

Question #: 250
Topic #: 1

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,100Kbps.
• Disk throughput: 382,700Kbps

The administrator also looks at the storage for the database server and notices it is consistently near its OPS limit. Which of the following will BEST resolve these performance issues?

A. Increase CPU resources on the database server.
B. Increase caching on the database server.
C. Put the storage and the database on the same VLAN.
D. Enable compression on storage traffic.
E. Enable deduplication on the storage appliance.

Show Suggested Answer

Suggested Answer: B 🗳️

by BigM at Feb. 28, 2025, 2:58 p.m.

Comments

Submit Cancel

BigM

5 months, 2 weeks ago

Selected Answer: B

Explanation: The high RAM usage (97%) and the database storage being near its IOPS limit suggest that the database is frequently performing disk-intensive operations. Since disk throughput is nearly maxed out, increasing caching can help reduce the number of disk reads and improve query performance. Caching stores frequently accessed data in memory (RAM), significantly reducing disk I/O operations, which is the primary bottleneck here.

upvoted 1 times

...