CompTIA Cloud+ (CV0-003) — Question 240

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?

Answer options

• 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.

Correct answer: B

Explanation

The correct answer is B, as increasing caching on the database server can significantly improve performance by reducing the load on the database when handling complex queries. Options A, C, D, and E do not directly address the high RAM utilization and OPS limit being reached on storage, which are critical factors affecting performance.