hardMultiple ChoiceObjective-mapped
CV0-004 A cloud application is intermittently slow Practice Question
Exhibit
Refer to the exhibit. [2025-02-20 14:32:15] ERROR: Connection timeout to database endpoint db.example.com:3306 [2025-02-20 14:32:20] WARN: Retry attempt 1 of 3... [2025-02-20 14:32:25] ERROR: All retries exhausted. Falling back to cached data.
A cloud application is intermittently slow. Based on the exhibit, which of the following is the most likely cause?
⚠ Common exam trap
CompTIA often tests the distinction between intermittent failures (caused by network filtering or transient connectivity issues) versus persistent failures (caused by overload or misconfiguration), leading candidates to incorrectly choose database overload or DNS errors.
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
✓
A network security group is blocking port 3306.
The intermittent slowness points to a network security group blocking port 3306, which is used by MySQL/MariaDB. When the NSG intermittently drops packets to this port, the application experiences timeouts and retries, causing sporadic slowdowns. This is a common issue in cloud environments where security rules are misconfigured or applied at the wrong priority level.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
A network security group is blocking port 3306.
Why this is correct
Blocking the port prevents TCP handshake, causing a timeout. This matches the error logs.
- ✗
The database server is overloaded.
Why it's wrong here
Overloaded database would likely produce slow query responses or error messages, not consistent connection timeouts.
- ✗
The database endpoint DNS record is incorrect.
Why it's wrong here
An incorrect DNS record would cause a name resolution failure (e.g., 'Name or service not known'), not a timeout.
- ✗
The application has insufficient memory.
Why it's wrong here
Insufficient memory would lead to out-of-memory errors or swapping, not database connection timeouts.
Go deeper
Related to this question
About these practice questions
One of 977 original CV0-004 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. 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.