ISC2 Certified Secure Software Lifecycle Professional (CSSLP) Practice Question
During a design review, you learn that a public-facing SaaS platform uses two stateless web servers behind a highly available load balancer, but stores all state in a single on-premises database server. From a resiliency standpoint, which change would most effectively remove the remaining single point of failure?
Enable TLS 1.3 for all client connections to the application servers.
Deploy a replicated database cluster with automatic failover between primary and secondary nodes.
Place a web application firewall in front of the load balancer to filter malicious traffic.
Schedule nightly full backups of the database to off-site storage.
The lone database server is the system's only component without redundancy. Implementing a replicated database cluster with automatic failover provides multiple identical nodes; if the primary fails, a secondary can take over with minimal interruption, eliminating that single point of failure. A web application firewall improves security but leaves the database dependency unchanged. Enabling TLS 1.3 protects data in transit, not availability. Nightly backups safeguard data but do not keep the application online if the sole database host goes down.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is a replicated database cluster?
Open an interactive chat with Bash
How does automatic failover work in a database cluster?
Open an interactive chat with Bash
Why is the single on-premises database server a vulnerability in this design?
Open an interactive chat with Bash
ISC2 Certified Secure Software Lifecycle Professional (CSSLP)
Secure Software Concepts
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99
$19.99/mo
Billed monthly, Cancel any time.
3 Month Pass
$44.99
$14.99/mo
One time purchase of $44.99, Does not auto-renew.
MOST POPULAR
Annual Pass
$119.99
$9.99/mo
One time purchase of $119.99, Does not auto-renew.
BEST DEAL
Lifetime Pass
$189.99
One time purchase, Good for life.
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .