CV0-004 Troubleshooting Practice Question
A cloud administrator is troubleshooting a database failover issue. The database is a managed service with a primary and standby replica in different availability zones. The application uses a read-write endpoint. During a recent maintenance event, the primary database failed over automatically, but the application experienced a 10-minute outage. The administrator checks the failover logs and sees that it completed within 2 minutes. What is the most likely cause of the extended outage?
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 application's database connection pool does not retry DNS resolution
If the application's connection pool caches the IP address of the primary database, it will not automatically re-resolve the DNS after failover, causing prolonged outages. Option B is wrong because multi-AZ configuration is about the database, not the application's endpoint configuration. Option C is wrong because if the standby was out of sync, failover would not complete cleanly. Option D is wrong because the DNS change is usually fast but the application may not re-query DNS.
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 application's database connection pool does not retry DNS resolution
Why this is correct
Stale connections continue to point to the old primary IP, causing failures until the pool refreshes.
- ✗
The application was not configured to use multiple availability zones
Why it's wrong here
This does not explain the 10-minute outage; the database itself is multi-AZ.
- ✗
The standby replica was not in sync
Why it's wrong here
If out of sync, failover would not succeed or would take longer than 2 minutes.
- ✗
The failover triggered a change in the endpoint DNS record
Why it's wrong here
DNS record change happens quickly, but the application may not re-resolve.
Visual reference
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.