nerdexam
Microsoft

70-465 · Question #54

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 database snapshot. To meet a data recovery requirement, a database snapshot should be recommended as it allows for a quick reversion of a database to a previous known good state.

Submitted by akirajp· 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 differential backup
  • BA transaction log backup
  • CSnapshot isolation
  • DA database snapshot

How the community answered

(56 responses)
  • A
    9% (5)
  • B
    4% (2)
  • C
    5% (3)
  • D
    82% (46)

Why each option

To meet a data recovery requirement, a database snapshot should be recommended as it allows for a quick reversion of a database to a previous known good state.

AA differential backup

A differential backup records all changes since the last full backup and requires the prior full backup for restoration, making it a longer recovery process than reverting to a database snapshot.

BA transaction log backup

A transaction log backup captures all transaction log records since the last log backup, which is essential for point-in-time recovery but is a component of a larger backup strategy, not a standalone reversion mechanism like a snapshot.

CSnapshot isolation

Snapshot isolation is a concurrency control mechanism that provides transactions with a consistent view of data, but it does not serve as a direct data recovery or restoration tool.

DA database snapshotCorrect

A database snapshot creates a static, read-only view of a SQL Server database at a specific point in time, which can be used to quickly revert the source database to that earlier state. This feature allows for rapid recovery from accidental data modifications or corruption by restoring the database to a known good point without a full restore operation.

Concept tested: SQL Server Database Snapshot for Recovery

Source: https://learn.microsoft.com/en-us/sql/relational-databases/databases/revert-a-database-to-a-database-snapshot-sql-server

Topics

#Database snapshots#Data recovery#Point-in-time recovery

Community Discussion

No community discussion yet for this question.

Full 70-465 Practice