Question 212 of 977
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
About these practice questions
Courseiva creates original exam-style practice questions with explanations and wrong-answer analysis. It does not publish real exam questions, exam dumps, or protected exam content. Learn why practice questions differ from exam dumps →
Last reviewed: Jun 24, 2026
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.
Question Discussion
Share a tip, memory trick, or ask about the reasoning behind this question. Do not post real exam questions, leaked content, braindumps, or copyrighted exam material. Comments are moderated and may be removed without notice.
Sign in to join the discussion.