hardMultiple ChoiceObjective-mapped
CV0-004 Practice Question: Refer to the exhibit
Exhibit
Refer to the exhibit. ``` 2019-08-21 14:32:10 ERROR [main] com.example.service.DatabaseConnector - Connection to database failed: java.sql.SQLTimeoutException: Timeout trying to connect to database at jdbc:mysql://db-prod.internal.example.com:3306/appdb 2019-08-21 14:33:15 ERROR [main] com.example.service.DatabaseConnector - Connection to database failed: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure 2019-08-21 14:34:20 ERROR [main] com.example.service.DatabaseConnector - Connection to database failed: java.net.ConnectException: Connection refused (Connection refused) 2019-08-21 14:35:25 ERROR [main] com.example.service.DatabaseConnector - Connection to database failed: java.sql.SQLTimeoutException: Timeout trying to connect to database at jdbc:mysql://db-prod.internal.example.com:3306/appdb ```
Refer to the exhibit. An application in a cloud environment logs multiple database connection errors. The database is a managed MySQL instance in the same VPC. The timeouts and connection refused errors occur intermittently. Which of the following is the most likely cause?
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
✓
The database is hitting its maximum connections limit.
Intermittent connection refused and timeouts indicate that the database is reaching its maximum connections limit, causing new connections to be refused or timeout.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
The database is hitting its maximum connections limit.
Why this is correct
Correct. When max connections are reached, new connections are refused, and timeouts occur when waiting for a slot.
- ✗
The database instance is out of storage.
Why it's wrong here
Out of storage typically causes write errors, not connect timeouts or connection refused.
- ✗
The security group for the database is not allowing inbound traffic from the application.
Why it's wrong here
A security group misconfiguration would cause all connections to fail consistently, not intermittently.
- ✗
The database's DNS resolves to multiple IP addresses.
Why it's wrong here
Multiple IP addresses would not cause connection refused; it might cause occasional connection to different endpoints but not consistent refusal.
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.