nerdexam
Microsoft

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.

Submitted by helene.fr· Mar 5, 2026Design and implement database solutions for SQL Server

Question

You need to recommend a solution that meets the data recovery requirement. What should you include in the recommendation?

Options

  • AA database snapshot
  • BA transaction log backup
  • CSnapshot isolation
  • DA differential backup

How the community answered

(52 responses)
  • A
    10% (5)
  • B
    17% (9)
  • C
    4% (2)
  • D
    69% (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.

AA database snapshot

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.

BA transaction log backup

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.

CSnapshot isolation

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.

DA differential backupCorrect

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

#SQL Server backups#Data recovery#Differential backup

Community Discussion

No community discussion yet for this question.

Full 70-465 Practice