CV0-004 Troubleshooting Practice Question
During a disaster recovery test, a cloud administrator discovers that the standby database in a different region is not synchronized with the primary. The primary database uses asynchronous replication. What is the MOST likely reason for the sync failure?
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
✓
Network latency causing replication lag
Asynchronous replication does not guarantee immediate synchronization; network latency between regions can cause replication lag, meaning the standby may not have the latest data if the primary fails before sync completes. Option A is incorrect because license expiration would typically prevent the standby from starting or functioning, not cause lag. Option C is incorrect because a firewall blocking port 3306 would completely halt replication, not cause lag. Option D is incorrect because while incorrect configuration could cause sync issues, the question specifies a standby database, and a read replica would not be used as a standby; the most likely reason in a DR test with async replication is network latency.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
License expiration on the standby database
Why it's wrong here
Licensing does not affect replication sync.
- ✓
Network latency causing replication lag
Why this is correct
Asynchronous replication allows lag; high latency can increase lag, causing data not to be current.
- ✗
Firewall rules blocking port 3306 between regions
Why it's wrong here
Blocked port would stop replication entirely, not just cause sync lag.
- ✗
Incorrect replication configuration using a read replica instead of a standby
Why it's wrong here
Read replicas and standbys are different but both can be configured for async replication.
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.