SY0-701 · Question #606
Which of the following options will provide the lowest RTO and RPO for a database?
The correct answer is D. Hot site. A hot site delivers the lowest RTO and RPO because it is a fully operational, real-time replica of your production environment - when the primary site fails, you fail over almost instantly with minimal or no data loss, since replication is continuous. Snapshots (A) are…
Question
Which of the following options will provide the lowest RTO and RPO for a database?
Options
- ASnapshots
- BOn-site backups
- CJournaling
- DHot site
How the community answered
(45 responses)- A2% (1)
- B2% (1)
- C9% (4)
- D87% (39)
Explanation
A hot site delivers the lowest RTO and RPO because it is a fully operational, real-time replica of your production environment - when the primary site fails, you fail over almost instantly with minimal or no data loss, since replication is continuous. Snapshots (A) are point-in-time copies taken at intervals, meaning you lose any data written since the last snapshot and must spend time restoring it - both RPO and RTO suffer. On-site backups (B) share the same interval-based data-loss problem as snapshots, and a site-level disaster would destroy both primary and backup simultaneously. Journaling (C) records incremental transaction logs and improves RPO over snapshots, but recovery still requires replaying the journal, making RTO significantly higher than a hot site.
Memory tip: Think of temperature as readiness - a hot site is already running (fastest), a warm site needs a few hours to spin up, and a cold site is just empty floor space (slowest). Lower temperature = higher RTO/RPO.
Topics
Community Discussion
No community discussion yet for this question.