Which Solution Provides the Lowest RTO and RPO for a Database?
Which of the following options will provide the lowest RTO and RPO for a database?
Community Votes
57% of anonymous learners picked answer D. Votes are pick records left by other test-takers — they are not the verified answer.
Community Insight
It distinguishes between transaction-level data logging and full-environment redundancy, trapping candidates who confuse granular data recovery speed with complete system availability.
This question tests your understanding of Recovery Time Objective (RTO) and Recovery Point Objective (RPO) metrics across different backup and replication strategies. The community consensus recognizes a hot site as the optimal choice for achieving near-zero downtime and minimal data loss through continuous infrastructure synchronization.
Candidates often select Journaling (C) because it records every database transaction, incorrectly assuming that precise point-in-time recovery automatically translates to the fastest overall system restoration. This overlooks the fact that journaling does not rebuild servers, networks, or applications, making it inadequate for meeting strict RTO targets.
Community Discussion (7 comments)
Comments & Corrections
No comments yet — spotted an error or have a note? Share it below.
Expert Analysis
Understanding RTO and RPO
Recovery Time Objective (RTO) defines the maximum acceptable downtime before operations must resume, while Recovery Point Objective (RPO) dictates the maximum tolerable data loss measured in time. To achieve the lowest values for both, a solution must automate infrastructure restoration and synchronize data continuously.Why a Hot Site is Correct
A hot site is a fully provisioned, geographically separate facility equipped with identical hardware, software, and network configurations. It maintains continuous real-time replication of the primary database, enabling automatic failover or near-instantaneous manual switchover. As noted in community discussions, this architecture delivers near-zero RTO and RPO because the standby environment is always ready to assume production workloads without provisioning delays or data restoration bottlenecks.The Journaling Misconception
Many candidates favor journaling (Option C) because it logs every transaction commit, theoretically allowing recovery to the exact millisecond of failure. While journaling excels at minimizing RPO for individual database instances, it strictly handles data consistency, not infrastructure resilience. Restoring a failed server, reconfiguring networking, and restarting dependent services still require significant manual effort, which inflates the RTO. Commenters highlighting journaling's transactional precision often conflate database-level recovery with enterprise-wide business continuity.Evaluating Alternatives
Snapshots (Option A) capture state at a specific moment but share underlying storage dependencies, increasing corruption risk during catastrophic failures. On-site backups (Option B) suffer from lengthy media retrieval, verification, and restoration cycles, resulting in the highest RTO and RPO among the choices. Only a hot site addresses both compute/storage redundancy and data synchronization simultaneously, aligning with CompTIA's business resiliency framework expectations.Official Reference
- NIST Special Publication 800-34 Rev. 1: Contingency Planning Guide for Federal Information Systems
- https://csrc.nist.gov/pubs/sp/800-34/r1/final
- CompTIA Security+ SY0-701 Exam Objectives: Domain 4.0
- https://www.comptia.org/certifications/security
Exam Strategy
When evaluating disaster recovery options, always separate infrastructure readiness from data granularity. If an answer choice requires manual server rebuilding, network reconfiguration, or media loading, it cannot possibly deliver the lowest RTO regardless of how precise its data logging is. For absolute minimum downtime and data loss, prioritize solutions featuring automated failover and continuous cross-site replication.
Related Analysis
Practice All SY0-701 Questions
Access 100 questions with complete answers and detailed explanations.
View Full SY0-701 Practice Test →