70-465 · Question #70
You need to recommend a solution that meets the data recovery requirement. What should you include in the recommendation?
The correct answer is D. A differential backup. To meet data recovery requirements, a differential backup is an efficient solution as it captures changes since the last full backup, facilitating quicker restoration.
Question
Options
- AA database snapshot
- BA transaction log backup
- CSnapshot isolation
- DA differential backup
How the community answered
(52 responses)- A10% (5)
- B17% (9)
- C4% (2)
- D69% (36)
Why each option
To meet data recovery requirements, a differential backup is an efficient solution as it captures changes since the last full backup, facilitating quicker restoration.
A database snapshot creates a read-only, static view of a database at a specific point in time, primarily used for reporting or testing purposes, not as a primary method for restoring a production database in case of data loss.
A transaction log backup captures all transactions since the last log backup and is crucial for point-in-time recovery and minimizing data loss, but it cannot be restored independently and requires a preceding full (and often differential) backup as its foundation.
Snapshot isolation is a database concurrency control mechanism that allows transactions to read a consistent view of the database without locking, and it is unrelated to backing up or recovering data.
A differential backup copies all data that has changed since the last full database backup, offering a more efficient way to capture recent modifications compared to frequent full backups. This allows for data recovery by restoring the last full backup and then applying the most recent differential backup, reducing recovery time objectives (RTO).
Concept tested: Database backup strategies for data recovery
Source: https://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/differential-backups-sql-server
Topics
Community Discussion
No community discussion yet for this question.