Microsoft
70-451 · Question #145
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…
The correct answer is C. Create a database snapshot. See the full explanation below for the reasoning.
Question
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.
Options
- APerform a copy-only database backup before the changes are deployed.
- BCreate a database snapshot.
- CCreate a database snapshot.
- DPerform a full database backup before the changes are deployed.
How the community answered
(27 responses)- A4% (1)
- B11% (3)
- C81% (22)
- D4% (1)
Community Discussion
No community discussion yet for this question.