PrepAway - Latest Free Exam Questions & Answers

You are designing a database named DB1.

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.


Leave a Reply