Examkin

Question

Difficulty: EasyBusiness Continuity and Disaster Recovery

An organization maintains a database server that undergoes a full backup every Sunday at 01:00 and daily differential backups at 01:00 from Monday through Saturday. If the database server crashes on Friday at 15:00, which sequence of backup restorations must the network administrator perform to restore the database to its most recent valid state prior to the failure?

  1. Restore the Sunday full backup, followed by the Thursday differential backup.Answer
  2. B
    Restore the Sunday full backup, followed sequentially by the Monday, Tuesday, Wednesday, and Thursday differential backups.
  3. C
    Restore only the Thursday differential backup.
  4. D
    Restore the Sunday full backup, followed by the Friday differential backup.

Answer

Restore the Sunday full backup, followed by the Thursday differential backup.
A differential backup records all data modified since the last full backup was taken. To recover a system using differential backups, an administrator only needs to restore the initial baseline full backup (Sunday) and the most recent differential backup created prior to the crash (Thursday at 01:00).

Step-by-Step Solution

1
Identify the base restore point.
The last full backup executed on Sunday at 01:00.
Every system restoration requires the baseline full backup to re-establish the baseline filesystem and structure.
2
Identify the most recent completed target backup before the 15:00 Friday failure.
The Thursday differential backup executed at 01:00.
The Friday night backup has not run yet at 15:00 Friday, leaving Thursday's backup as the latest valid restore point.
3
Determine the restoration path for differential backups.
Apply only the Sunday full backup and the Thursday differential backup.
Differential backups accumulate all changes since the last full backup, requiring only the baseline full backup and the latest differential backup to achieve full restoration.

Key Concept

Differential Backup Restoration Procedure
Rate this question

Topics

Business Continuity and Disaster Recovery

More questions from this topic