nerdexam
Microsoft

70-459 · Question #100

You are designing a database named DB1. 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 operati

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. 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.

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

(44 responses)
  • A
    2% (1)
  • B
    11% (5)
  • C
    82% (36)
  • D
    5% (2)

Community Discussion

No community discussion yet for this question.

Full 70-459 Practice