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.
Question
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)- A7% (4)
- B4% (2)
- C75% (41)
- D15% (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.
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.
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.
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.
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
Community Discussion
No community discussion yet for this question.