DBA > Job Interview Questions > Microsoft SQL Server FAQs

To maintain the best performance of your SQL Ser

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

(Continued from previous question...)

To maintain the best performance of your SQL Server 2005 databases, how should you deploy encryption technologies?

Answer
Encrypt data with a symmetric key and secure all keys with asymmetric keys.

Explanation
For performance reasons, you should encrypt data using a symmetric key and secure that key with an asymmetric key.

(Continued on next question...)

Other Job Interview Questions