nerdexam
Microsoft

70-432 · Question #90

You are the administrator of three SQL Server 2008 instances named Instance1, Instance2, and Instance3. Each of the three instances runs on a separate server. A mission-critical database is mirrored…

The correct answer is D. Suspend the mirroring session. See the full explanation below for the reasoning.

Question

You are the administrator of three SQL Server 2008 instances named Instance1, Instance2, and Instance3. Each of the three instances runs on a separate server. A mission-critical database is mirrored between Instance1 and Instance2. Instance3 acts as the witness. Instance1 currently acts as the Principal. You plan to apply a patch to both servers. The patch requires a restart of the server. You need to find out the sequence of steps necessary to ensure that the following requirements are met: 1. The patching process is completed in the shortest possible time. 2. The database is online on the partner that currently does not apply the patch. 3. The database does not failover to the other partner during this time. What should you do?

Options

  • AApply the patch to the server that runs Instance2.
  • BApply the patch to the server that runs Instance2.
  • CRemove the mirroring session.
  • DSuspend the mirroring session.

How the community answered

(47 responses)
  • A
    6% (3)
  • B
    17% (8)
  • C
    2% (1)
  • D
    74% (35)

Community Discussion

No community discussion yet for this question.

Full 70-432 Practice