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.
A. 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.
Answer: C
Latest 70-764 Dumps Valid Version with 451 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund