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

• Using Reporting Services 2005, it is true or false that subreports execute a query against the datasource once for every detail row in the report?
• Using Report Builder, which of the following is the best statement about the formatting options for boolean columns?
• What method would you call to create this key?
• Which types of replication work with Oracle publishers?
• You have specified that a SQL Server 2005 login must respect the password policy on a Windows XP host. Which of the following are valid passwords for the user Kendall?
• What does this return? select (1324 & 1024)
• Which is these is not necessary for a well-formed XML document?
• Which of the following classes provide the context of the caller to SQLCLR Assemblies? Submitted by Michael Coles
• You are using SQL Server 2005 and you wish to find a number of details about stored procedures created...
• In SQL Server 2005 Integration Services, if you want to import a flat file very quickly that contains only integer data, what type of parsing should you use?
• More...