Microsoft
70-450 · Question #88
You administer two SQL Server 2008 instances on separate servers named Server1 and Server2. The AdventureWorks database is set up for synchronous mirroring between the two instances. You need to…
The correct answer is D. Configure the mirroring session by adding a witness server to it. See the full explanation below for the reasoning.
Question
You administer two SQL Server 2008 instances on separate servers named Server1 and Server2. The AdventureWorks database is set up for synchronous mirroring between the two instances. You need to configure the database to support automatic failover. What should you do?
Options
- AConfigure the mirroring session by using the FAILOVER option.
- BConfigure the mirroring session with the SAFETY option set to OFF.
- CConfigure the mirroring session with the SAFETY option set to FULL.
- DConfigure the mirroring session by adding a witness server to it.
How the community answered
(51 responses)- A16% (8)
- B4% (2)
- C10% (5)
- D71% (36)
Community Discussion
No community discussion yet for this question.