ISC2 Certified Secure Software Lifecycle Professional (CSSLP) Practice Question
Your SaaS platform currently runs a single-instance PostgreSQL database in one availability zone. Management sets an objective of a 5-minute recovery point and automatic failover within the same region while keeping write-latency impact to a minimum. Which approach best satisfies these availability requirements?
Asynchronous streaming replication to a hot standby in another availability zone within the region, with automatic failover configured
Change-data-capture exports to an external analytics cluster updated every few minutes
Nightly full backups to object storage with manual restore when needed
Synchronous replication to a standby node in a different geographic region
Asynchronous streaming replication to a hot standby in the same region continuously ships WAL records to the standby, keeping replicas typically seconds behind the primary-well within a 5-minute RPO. Because the primary does not wait for acknowledgements, write-latency overhead is minimal, and a promotion script or managed service can trigger automatic failover. Nightly backups provide no real-time copy and require manual restore, so they miss both the RPO and failover goals. Synchronous cross-region replication meets a strong RPO but adds commit latency because each write must be acknowledged over a longer network path. Exporting change-data-capture feeds to an analytics cluster is intended for reporting, not operational failover, and usually lacks automatic promotion capability.
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 asynchronous streaming replication?
Open an interactive chat with Bash
What is a Recovery Point Objective (RPO) and how does it relate to databases?
Open an interactive chat with Bash
How does automatic failover work in a database setup?
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 .