DBA > Job Interview Questions > Microsoft SQL Server FAQs

You want to be sure that your Scalable Shared Da

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

You want to be sure that your Scalable Shared Database is as available as possible. Which of the following is not needed for this?

Answer
Use Database Mirroring to fail over between the old reporting database and the new one.

Explanation
The update process for a Scalable Shared database with minimal downtime involves putting out a new copy of the database, detaching the old database from each server, and then attaching the new database to each server.

(Continued on next question...)

Other Job Interview Questions