70-465 Question #54: Real Exam Question with Answer & Explanation

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

Explanation

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.

Common mistakes.

• A. 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.
• B. 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.
• C. 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.

Concept tested. SQL Server Database Snapshot for Recovery

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

No community discussion yet for this question.