hardMultiple ChoiceObjective-mapped
CV0-004 Practice Question: A company deploys a multi-tier application in a…
A company deploys a multi-tier application in a public cloud. The web tier uses an auto scaling group across multiple availability zones. The database tier runs on a single large VM. The application experiences intermittent slowdowns during peak load. Which of the following is the BEST long-term solution?
⚠ Common exam trap
It's easy for candidates to assume scaling the web tier (Option D) or vertically scaling the database (Option C) is sufficient, but CompTIA tests the understanding that the database tier is the bottleneck and requires a horizontally scalable, managed solution for long-term reliability and performance.
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
✓
Migrate the database to a managed database service with read replicas
The database tier is a single point of failure and a performance bottleneck during peak load. Migrating to a managed database service with read replicas offloads read-heavy traffic, improves scalability, and provides automatic failover, addressing both performance and availability issues. This is a long-term solution that aligns with cloud best practices for multi-tier applications.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Migrate the database to a managed database service with read replicas
Why this is correct
Managed service provides scaling and high availability.
- ✗
Add a load balancer in front of the database tier
Why it's wrong here
Load balancer does not help if database is a single instance.
- ✗
Upgrade the database VM to a larger instance type
Why it's wrong here
Vertical scaling has physical limits and still single point of failure.
- ✗
Increase the number of web servers in the auto scaling group
Why it's wrong here
Web tier scaling does not address database bottleneck.
Go deeper
Related to this question
About these practice questions
This CV0-004 question is part of Courseiva's 977-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam 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.