nerdexam
Microsoft

70-465 · Question #19

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 requi

The correct answer is C. Create a database snapshot.. 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.

Submitted by yousef_jo· Mar 5, 2026Design and implement database solutions for SQL Server

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.

How the community answered

(55 responses)
  • A
    7% (4)
  • B
    4% (2)
  • C
    75% (41)
  • D
    15% (8)

Why each option

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.

APerform a copy-only database backup before the changes are deployed.

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.

BCreate a database snapshot.

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.

CCreate a database snapshot.Correct

Creating a database snapshot before deploying changes enables a significantly faster rollback to the database's pre-change state compared to restoring a full backup, directly addressing the 'undo quickly' requirement. Database snapshots also do not interfere with the regular backup operations of the source database, making it a non-disruptive solution.

DPerform a full database backup before the changes are deployed.

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

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

Topics

#database deployment#database snapshots#rollback strategies

Community Discussion

No community discussion yet for this question.

Full 70-465 Practice