Question 73 of 144
SK0-005 server-administration Practice Question
A MySQL database server on Linux is experiencing high CPU utilization during peak business hours. Upon investigation, the administrator finds that the query cache hit ratio is below 20%, and the query_cache_size is set to 0. The server has 64 GB of RAM and the database workload is primarily read-heavy. Which of the following actions should the administrator take FIRST to improve performance?
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Set query_cache_size to an appropriate value, such as 256M, and monitor.
Option D is correct because the query cache is disabled (size 0). Enabling it and setting an appropriate size will increase cache hits and reduce CPU load. Option A adds RAM but does not address the misconfigured cache. Option B identifies queries but does not directly fix the cache. Option C rebuilds indexes, which may not impact query caching.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Set query_cache_size to an appropriate value, such as 256M, and monitor.
Why this is correct
Enabling and sizing the query cache for a read-heavy workload can dramatically increase cache hits and reduce CPU.
- ✗
Add more RAM to the server.
Why it's wrong here
More RAM could help overall, but the immediate bottleneck is that the query cache is turned off, not insufficient memory.
- ✗
Rebuild all indexes on the database tables.
Why it's wrong here
Index maintenance may improve some queries but does not enable the query cache, which is the immediate issue.
- ✗
Enable the slow query log to identify inefficient queries.
Why it's wrong here
This is a diagnostic step, not a performance fix; the low cache hit ratio directly points to query_cache_size.
About these practice questions
Courseiva creates original exam-style practice questions with explanations and wrong-answer analysis. It does not publish real exam questions, exam dumps, or protected exam content. Learn why practice questions differ from exam dumps →
Last reviewed: Jul 26, 2026
This SK0-005 practice question is part of Courseiva's free CompTIA certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the SK0-005 exam.
Question Discussion
Share a tip, memory trick, or ask about the reasoning behind this question. Do not post real exam questions, leaked content, braindumps, or copyrighted exam material. Comments are moderated and may be removed without notice.
Sign in to join the discussion.