Question 230
A hospital requires database recovery to a minute before an accidental table deletion; weekly backups are its only current protection. Which limitation must be considered before claiming the issue is fully resolved?
Explanation
Correct Answer
PITR capability depends on retained logs and supported database configuration. This caution prevents extrapolating beyond the specific evidence or product boundary. Database protection must match the granularity of the recovery requirement. The unresolved point should be tested using database log retention, PITR configuration and representative restore rehearsal rather than assuming a working interface proves full compliance or resilience.
Incorrect Answers
Any timestamp requested can be restored even if logs have already expired. This limitation is framed as a blanket exception, but the case requires a different, narrower caution. The relevant boundary is that PITR capability depends on retained logs and supported database configuration. Database protection must match the granularity of the recovery requirement. Inspect database log retention, PITR configuration and representative restore rehearsal.
Point-in-time restore always works for timestamps outside the configured log window. The proposed claim mistakes an incomplete signal or product feature for a universal guarantee. The relevant boundary is that PITR capability depends on retained logs and supported database configuration. Database protection must match the granularity of the recovery requirement. Inspect database log retention, PITR configuration and representative restore rehearsal.
PITR recovery is guaranteed for arbitrarily old timestamps without retained logs. This claim exceeds the evidence and ignores an important risk or operational dependency. The relevant boundary is that PITR capability depends on retained logs and supported database configuration. Database protection must match the granularity of the recovery requirement. Inspect database log retention, PITR configuration and representative restore rehearsal.