hardMultiple ChoiceObjective-mapped
CV0-004 Practice Question: Is deploying a multi-tier application in the cloud
An organization is deploying a multi-tier application in the cloud. The web tier uses auto scaling, and the database tier uses a managed database service. During a load test, the web tier scales up correctly, but the database performance degrades significantly, causing timeout errors. The administrator reviews the database metrics and finds that CPU and memory are normal, but the number of connections is high. Which of the following is the BEST action to resolve the issue?
⚠ Common exam trap
Candidates often confuse high connection count with high CPU/memory load and choose to scale the database vertically (Option C), when the real issue is connection exhaustion that is solved by pooling.
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
✓
Implement connection pooling on the web servers to limit database connections.
The issue is that the database is overwhelmed by a high number of connections, not by CPU or memory pressure. Connection pooling on the web servers reuses a fixed set of database connections, reducing the connection overhead and preventing the database from hitting its maximum connection limit. This directly addresses the symptom of high connection count without changing the database's compute capacity or the web tier's scaling behavior.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Add read replicas to offload read traffic from the primary database.
Why it's wrong here
Read replicas help reads, but the issue is high connection count, likely from writes.
- ✗
Increase the maximum number of web servers in the auto scaling group.
Why it's wrong here
More web servers would increase database connections, worsening the problem.
- ✗
Increase the compute size of the database instance.
Why it's wrong here
CPU and memory are normal, so compute is not the bottleneck.
- ✓
Implement connection pooling on the web servers to limit database connections.
Why this is correct
Connection pooling reduces the number of simultaneous database connections, improving performance.
Visual reference
Go deeper
Related to this question
About these practice questions
Courseiva writes every CV0-004 question from scratch — 977 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or 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 CV0-004 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 CV0-004 exam.