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 online while the changes are deployed.
• You must be able to undo quickly any changes made to objects.
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.