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.
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.
If the deployment fails, restore the database to another server and recover the original objects from the
restored database.