ITIL4F ITIL Service Value System Practice Question
A large e-commerce company is experiencing slow response times on its website during peak shopping hours. The IT team has identified that the database server is under high CPU load. They have tried scaling up the server resources, but the issue persists. The team suspects that inefficient database queries are the cause. The service owner wants to implement a solution that aligns with the ITIL guiding principles. The company has a limited budget for this initiative. Which course of action should the team take to address the problem most effectively?
⚠ Common exam trap
Candidates often assume scaling up hardware (Option A) is always the answer to performance issues, but ITIL emphasizes solving the root cause first, and the question explicitly states that scaling up has already failed.
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
✓
Analyze and optimize the slow database queries identified by the database administrator.
The root cause is inefficient database queries, not insufficient hardware. Optimizing queries directly addresses the high CPU load by reducing the processing required per query, aligning with the ITIL guiding principle of 'Focus on Value' by solving the actual problem without unnecessary expenditure. This approach also respects the limited budget, as query optimization typically requires only DBA time rather than costly infrastructure upgrades.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Upgrade to a more powerful database server with more CPUs.
Why it's wrong here
This approach addresses a symptom (lack of processing power) rather than the root cause of inefficient queries. While a more powerful server might temporarily mask the performance issue by providing more resources, it represents a significant capital expenditure without resolving the underlying software inefficiency. The problem will likely recur as data volume or query complexity grows, making it an unsustainable and costly solution that doesn't align with ITIL's 'Optimize and automate' principle.
- ✓
Analyze and optimize the slow database queries identified by the database administrator.
Why this is correct
This option directly targets the identified root cause: inefficient database queries. By analyzing query execution plans, creating appropriate indexes, or rewriting suboptimal SQL statements, performance improvements are achieved at the source. This aligns perfectly with ITIL's 'Focus on value' by delivering tangible performance gains and 'Optimize and automate' by improving the efficiency of existing resources, offering a sustainable and cost-effective solution without unnecessary expenditure.
- ✗
Implement a caching layer to reduce database load.
Why it's wrong here
Implementing a caching layer can reduce direct database load for frequently accessed data, but it acts as a workaround rather than a fundamental fix for inefficient queries. While it might improve response times for cached data, the underlying slow queries still consume resources and impact uncached operations. This introduces additional architectural complexity, potential data staleness issues, and does not adhere to the 'Start where you are' or 'Optimize and automate' principles by ignoring the existing inefficiency.
- ✗
Hire a database consultant to review the entire database architecture.
Why it's wrong here
Hiring a database consultant to review the entire architecture is a broad, costly engagement that does not directly target the specific, suspected root cause of inefficient queries. The scenario demands a focused, low-cost intervention, such as query optimisation or indexing, not a full architectural audit. This option is tempting because a consultant can provide expert guidance on systemic design flaws, and it would be correct if the problem were a poorly normalised schema or capacity planning failure rather than isolated query inefficiency.
Go deeper
Related to this question
About these practice questions
This ITIL4F question is part of Courseiva's 805-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This ITIL4F practice question is part of Courseiva's free PeopleCert 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 ITIL4F exam.