70-450 · Question #80
70-450 Question #80: Real Exam Question with Answer & Explanation
The correct answer is B. To finish the task, the witness server should be moved from the mirroring session.. Removing the witness will keep the mirroring session, but without automatic failover You can remove the witness from a session if you are connected to the current principal server. To remove the witness: 1. Connect to the principal server instance and, in the Object Explorer pane
Question
Options
- ATo finish the task, database mirroring should be paused.
- BTo finish the task, the witness server should be moved from the mirroring session.
- CTo finish the task, asynchronous operating mode should be utilized.
- DTo finish the task, database mirroring should be removed.
Explanation
Removing the witness will keep the mirroring session, but without automatic failover You can remove the witness from a session if you are connected to the current principal server. To remove the witness: 1. Connect to the principal server instance and, in the Object Explorer pane, click the server name to expand the server tree. 2. Expand Databases, and select the database whose witness you want to remove. 3. Flight-click the database, select Tasks, and then click Mirror. This opens the Mirroring page of the Database Properties dialog box. 4. To remove the witness, delete its server network address from the Witness field. Note lf you switch from high-safety mode with automatic failover to high-performance mode, the Witness field is automatically cleared.
Community Discussion
No community discussion yet for this question.