PrepAway - Latest Free Exam Questions & Answers

Which action should you perform to finish the task?

You are a professional level SQL Sever 2008 Database Administrator in an international corporation
named Wiikigo. You are experienced in managing databases in an enterprise-level organization, optimizing
and sustaining the database life cycle.
In the company, your job is to implement solutions on security, troubleshooting, deployment and optimization.
A SQL Server 2008 instance is managed by you.
A database is hosted by the instance and the database is configured by utilizing high-safety mirroring
operation mode along with a witness server. A memory failure is experienced by the witness server;
therefore the server will be offline for five hours.
The mirroring strategy should be reset to cut the risk of database unavailability to the least level.
Which action should you perform to finish the task?

PrepAway - Latest Free Exam Questions & Answers

A.
To finish the task, database mirroring should be paused.

B.
To finish the task, the witness server should be moved from the mirroring session.

C.
To finish the task, asynchronous operating mode should be utilized.

D.
To finish the task, database mirroring should be removed.


Leave a Reply