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 y
ou 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 f
ull 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.