(Continued from previous part...)

What algorithm is used to encrypt the Database Master Key when it is created?

Answer
Triple DES
Explanation
When you create a Database Master Key, it is encrypted using the password you supply with the Triple DES algorithm.

Which protocols support Kerberos authentication on SQL Server 2005?

Answer
TCP/IP
Explanation
Only those clients connecting with TCP/IP can use Kerberos authentication.

You have a few new SQL Server 2005 server instances and you want to be sure that SQL authenticated logins must abide by the password policy. On this platforms can you enforce this?

Answer
Windows 2003 Server
Explanation
You can only enforce password policy on the Windows 2003 Server platform and newer.

You are setting up a native XML web service on your SQL Server 2005 to respond to inventory requests. How can you you be sure that a SOAP queries that are looking for a WSDL response will be provided?

Answer
Use the WSDL=DEFAULT parameter in the create endpoint statement.
Explanation
When using the CREATE ENDPOINT command, you can specify the WSDL=DEFAULT parameter to generate a default WSDL response or use WSDL="spname" where spname is the name of a custom stored procedure to return WSDL responses.

Where can you view the list of server-scoped DDL triggers?

Answer
The Object Explorer for the server has a "Triggers" folder.
Explanation
The server-scoped DDL triggers will appear in Management Studio in the Object Explorer under the "Triggers" folder.

You want to be sure that your reporting solutions using a database snapshot are properly protected from disaster. How can you back up your database snapshots?

Answer
You cannot back up a database snapshot.
Explanation
A database snapshot cannot be backed up or restored.

(Continued on next part...)