Exam 70-764 topic 1 question 150 discussion

Actual exam question from Microsoft's 70-764

Question #: 150
Topic #: 1

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.

Show Suggested Answer

Suggested Answer: C 🗳️

by TheSwedishGuy at Jan. 29, 2020, 12:43 p.m.

Comments

Submit Cancel

TheSwedishGuy

5 years, 5 months ago

A database snapshot is literally a read-only snapshot of the source database. You can revert (restore) the database to the snapshot. It does not affect the backup operation. https://docs.microsoft.com/en-us/sql/relational-databases/databases/database-snapshots-sql-server?view=sql-server-ver15

upvoted 1 times

...