SK0-004 · Question #466
The last available backup is from 12 months ago. Which of the following should an administrator perform prior to applying a critical application patch to a guest OS? (Choose two.)
The correct answer is A. Full backup B. Database snapshot. When the last backup is 12 months old and a critical patch is imminent, a full backup and a database snapshot must be taken to ensure both complete data protection and a consistent, recoverable database state.
Question
The last available backup is from 12 months ago. Which of the following should an administrator perform prior to applying a critical application patch to a guest OS? (Choose two.)
Options
- AFull backup
- BDatabase snapshot
- CIncremental backup
- DVirtual machine snapshot
- EFile system copy
How the community answered
(23 responses)- A74% (17)
- C4% (1)
- D13% (3)
- E9% (2)
Why each option
When the last backup is 12 months old and a critical patch is imminent, a full backup and a database snapshot must be taken to ensure both complete data protection and a consistent, recoverable database state.
A full backup captures the complete current state of all data on the system, which is essential given the 12-month-old baseline - any restore attempt without a current full backup would leave up to a year of data unprotected if the patch causes system failure.
A database snapshot creates a point-in-time, read-only image of the database immediately before the patch is applied, allowing administrators to rapidly roll back the database to its exact pre-patch state if the application patch causes data corruption or application failure.
An incremental backup only captures changes since the last backup, but with the last full backup being 12 months old it would not provide a reliable or complete restore point - a full backup must be established first.
A virtual machine snapshot is a temporary short-term rollback mechanism not designed as a long-term backup solution, and it degrades storage and VM performance over time making it unsuitable as the primary pre-patch protection strategy.
A file system copy does not account for open or locked database files and cannot guarantee transactional consistency, making it an unreliable and incomplete protection method before applying a critical patch.
Concept tested: Pre-patch backup and snapshot strategy for guest OS
Source: https://learn.microsoft.com/en-us/sql/relational-databases/databases/database-snapshots-sql-server
Topics
Community Discussion
No community discussion yet for this question.