SK0-003 · Question #884
Which of the following is the MAIN advantage of using a differential backup over an incremental backup?
The correct answer is D. Restore time is faster. The question asks for the primary advantage of a differential backup over an incremental backup. The key benefit of differential backups is their ability to restore data more quickly.
Question
Which of the following is the MAIN advantage of using a differential backup over an incremental backup?
Options
- ADoes not require drive space
- BBackup time is faster
- CDoes not depend on a full backup
- DRestore time is faster
How the community answered
(27 responses)- A7% (2)
- B4% (1)
- D89% (24)
Why each option
The question asks for the primary advantage of a differential backup over an incremental backup. The key benefit of differential backups is their ability to restore data more quickly.
All backup types, including differential, require storage space to store the backed-up data.
Differential backups typically take longer than incremental backups because they back up all changes since the last full backup, whereas incremental backups only back up changes since the *last* backup (full or incremental).
Both differential and incremental backups rely on an initial full backup to serve as a baseline for subsequent changes.
The main advantage of a differential backup over an incremental backup is a faster restore time. To restore data from a differential backup, you only need the last full backup and the most recent differential backup, as the differential contains all changes since the last full backup.
Concept tested: Backup types: differential vs. incremental
Source: https://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/backup-overview-sql-server
Topics
Community Discussion
No community discussion yet for this question.