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

Question

You are designing a database named DB1. Changes will be deployed to DB1 every Wednesday night. You need to recommend a strategy to deploy the changes to DB1. The strategy must meet the following requirements: - The strategy must not disrupt backup operations. - DB1 must be unavailable to users while the changes are deployed. - You must be able to undo quickly the entire operation. What should you recommend? More than one answer choice may achieve the goal. Select the BEST answer.

Options

• APerform a copy-only database backup before the changes are deployed.
• BCreate a database snapshot.
• CCreate a database snapshot.
• DPerform a full database backup before the changes are deployed.

Explanation

The recommended strategy is to create a database snapshot, as it allows for rapid rollback of changes without interfering with ongoing backup operations, meeting all specified requirements.

Common mistakes.

• A. Performing a copy-only database backup allows for restoration, but the process of restoring a full backup is typically much slower than reverting a database using a snapshot, thus not meeting the 'undo quickly' requirement as efficiently.
• B. Although creating a database snapshot is a technically correct and effective strategy for meeting the specified requirements, this option is a duplicate of choice C, which is explicitly designated as the correct answer.
• D. Performing a full database backup can potentially disrupt subsequent differential backups by resetting the differential base, and restoring from a full backup is generally slower than reverting using a snapshot, failing to meet the 'undo quickly' requirement optimally.

Concept tested. SQL Server Database Snapshots for rapid rollback

Reference. https://learn.microsoft.com/en-us/sql/relational-databases/snapshots/database-snapshots-sql-server?view=sql-server-ver16

No community discussion yet for this question.