Microsoft
70-432 · Question #175
You administer a Microsoft SQL Server 2008 R2 instance. Mirroring has been configured between two servers. You need to ensure that automatic failover will occur when the principal server fails What…
The correct answer is A. Create a witness server to monitor the mirroring session. On the principal server, use the. See the full explanation below for the reasoning.
Question
You administer a Microsoft SQL Server 2008 R2 instance. Mirroring has been configured between two servers. You need to ensure that automatic failover will occur when the principal server fails What should you do?
Options
- ACreate a witness server to monitor the mirroring session. On the principal server, use the
- BCreate a witness server to monitor the mirroring session. On both partner servers, use the
- CCreate a Microsoft SQL Server Integration Services package on the partner server to monitor
- DImplement Policy Based Management. Enable the Server Performance management facet.
How the community answered
(64 responses)- A70% (45)
- B16% (10)
- C9% (6)
- D5% (3)
Community Discussion
No community discussion yet for this question.