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.
Question
Options
- AA differential backup
- BA transaction log backup
- CSnapshot isolation
- DA database snapshot
How the community answered
(56 responses)- A9% (5)
- B4% (2)
- C5% (3)
- D82% (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.
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.
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.
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.
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
Community Discussion
No community discussion yet for this question.