CCSP Cloud Application Security Practice Question
A cloud application experiences intermittent failures during peak load. Logs show database connection timeouts. Which architecture change would best address this issue?
⚠ Common exam trap
ISC2 often tests the misconception that scaling the application tier or database size alone solves connection management issues, when the real bottleneck is connection establishment overhead and pool limits.
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
✓
Implement connection pooling
Connection pooling reuses a set of established database connections, avoiding the overhead of repeatedly opening and closing connections during high concurrency. This directly resolves intermittent timeouts caused by connection exhaustion or slow connection establishment under peak load, without requiring additional infrastructure.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Implement connection pooling
Why this is correct
Connection pooling reuses connections, reducing overhead and preventing timeouts under load.
- ✗
Enable auto-scaling on the application tier
Why it's wrong here
Auto-scaling adds more application instances but does not manage database connections.
- ✗
Use read replicas
Why it's wrong here
Read replicas distribute read queries but do not address connection management.
- ✗
Increase database instance size
Why it's wrong here
Larger instance provides more resources but does not optimize connection reuse.
Visual reference
Go deeper
Related to this question
About these practice questions
One of 964 original CCSP 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 CCSP practice question is part of Courseiva's free ISC2 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 CCSP exam.