CV0-004 Cloud Architecture and Design Practice Question
A company uses a public cloud IaaS model to host a database. They want to ensure the database remains available if an entire availability zone fails. Which configuration would provide the highest availability with automatic failover?
⚠ Common exam trap
The CV0-004 exam often tests the distinction between high availability (automatic failover within the same region) and disaster recovery (manual or automated recovery to a different region), and the trap here is that candidates confuse a read replica or cross-region snapshot with a true high-availability solution that provides automatic failover and zero data loss.
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
✓
Deploy the database with a stand-by replica in a different availability zone using synchronous replication
Deploying a database with a stand-by replica in a different availability zone using synchronous replication ensures that all committed transactions are written to both the primary and the stand-by before acknowledging the client. This provides automatic failover with zero data loss (RPO=0) and high availability, as the stand-by replica can immediately take over if the entire availability zone fails.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Use a single database instance with automated snapshots to a different region
Why it's wrong here
Snapshots are not real-time and recovery takes time.
- ✗
Deploy the database in a single availability zone with multiple EC2 instances
Why it's wrong here
This protects against instance failure but not zone failure.
- ✗
Use a read replica in a different region with asynchronous replication
Why it's wrong here
Asynchronous replication may cause data loss and failover is not automatic.
- ✓
Deploy the database with a stand-by replica in a different availability zone using synchronous replication
Why this is correct
Synchronous replication and automatic failover protect against zone failure.
Visual reference
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.