Administering a SQL Database Infrastructure — Question 143

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.

Answer options

• A. Perform a copy-only database backup before the changes are deployed. If the deployment fails, restore the database to another server and recover the original. Objects from the restored database.
• B. Create a database snapshot. If the deployment fails, recover the objects from the database snapshot.
• C. Create a database snapshot. If the deployment fails, revert the database to the database snapshot.
• D. Perform a full database backup before the changes are deployed.

Correct answer: C

Explanation

The best recommendation is to create a database snapshot because it allows for a quick revert to the previous state if something goes wrong during the deployment. Options A and D involve backups that may not meet the requirement for quick undoing, while option B lacks the specific ability to revert the entire database to its previous state as efficiently as option C does.