Valid CV0-003 Dumps shared by ExamDiscuss.com for Helping Passing CV0-003 Exam! ExamDiscuss.com now offer the newest CV0-003 exam dumps, the ExamDiscuss.com CV0-003 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com CV0-003 dumps with Test Engine here:
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?
Correct Answer: B
The performance issue is caused by the high demand of complex SQL queries on the database server, which consumes a lot of RAM and disk throughput. Increasing caching on the database server would reduce the number of disk reads and writes, as well as improve the response time of the queries by storing frequently accessed data in memory. This would be the best solution to resolve the performance issue. Reference: CompTIA Cloud+ Certification Exam Objectives, Domain 4.0 Troubleshooting, Objective 4.3 Given a scenario, troubleshoot capacity issues within a cloud environment.