nerdexam
CompTIA

SG0-001 · Question #555

The backup regimen for a file server is to run a full backup every Sunday and cumulative incremental backups Monday thru Saturday evenings. On Wednesday morning, the server and storage are lost in a c

The correct answer is B. 2. To recover a server lost on Wednesday morning with a backup regimen of a Sunday full backup and Monday-Saturday cumulative incremental backups, two tapes are required: the latest full backup and the latest cumulative incremental backup.

Storage Management

Question

The backup regimen for a file server is to run a full backup every Sunday and cumulative incremental backups Monday thru Saturday evenings. On Wednesday morning, the server and storage are lost in a catastrophic event. Assuming a different backup tape is used every day, how many tapes are required to recover the server?

Options

  • A1
  • B2
  • C3
  • D4

How the community answered

(49 responses)
  • A
    4% (2)
  • B
    71% (35)
  • C
    10% (5)
  • D
    14% (7)

Why each option

To recover a server lost on Wednesday morning with a backup regimen of a Sunday full backup and Monday-Saturday cumulative incremental backups, two tapes are required: the latest full backup and the latest cumulative incremental backup.

A1

One tape is insufficient because a full restore requires both the full backup and the cumulative incremental backup containing all changes up to the point of failure.

B2Correct

To restore the server, you need the last full backup performed, which was on Sunday. Additionally, with cumulative incremental backups, you only need the latest cumulative incremental tape to restore all changes since the last full backup. Since Wednesday morning is after Tuesday evening's backup, the Tuesday tape contains all changes from Monday and Tuesday relative to Sunday's full backup, requiring a total of two tapes (Sunday's full and Tuesday's cumulative incremental).

C3

Three tapes would be needed if the regimen was differential incremental (full + Monday + Tuesday) or if you needed more than just the latest cumulative.

D4

Four tapes is incorrect as the cumulative incremental strategy consolidates changes, meaning only the most recent cumulative tape is needed along with the full backup.

Concept tested: Backup types and restore strategy (cumulative incremental)

Source: https://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/backup-overview-sql-server?view=sql-server-ver16#backup-types

Topics

#backup strategies#cumulative incremental backup#full backup#data recovery

Community Discussion

No community discussion yet for this question.

Full SG0-001 Practice