Question 240
Finance can tolerate at most 15 minutes of transaction loss after a database failure. Which resilience or recovery decision most directly meets this business requirement?
Explanation
Correct Answer
Specify a recovery point objective no greater than 15 minutes for the finance database, meaning recovery must be able to reach a point at most 15 minutes before the failure under the defined scenario. Choose backup frequency, transaction-log shipping or replication according to that objective and test actual recoverable points. RPO concerns potential data loss, not time required to resume service; the latter is measured by RTO. A strong design also protects older restore points from logical corruption.
Incorrect Answers
Offline or immutable backups protect recovery copies against deletion or tampering by an attacker with ordinary administrative access. They improve recoverability but do not by themselves define how much recent transaction history the business may lose. A nightly immutable copy could still be far older than the allowed 15-minute data-loss window.
Recovery time objective limits how long a service may be unavailable after disruption. Restoring operations in two hours could still lose yesterday's transactions if recoverable data copies are old. The statement here explicitly limits lost transaction history, so the correct metric is recovery point objective rather than elapsed downtime.
A hot site can provide quickly available infrastructure and reduce service restoration time. That does not guarantee that its data replica is current within 15 minutes or that a logical deletion was not replicated. The required maximum transaction loss must be quantified as RPO and validated independently of standby-site readiness.