(Continued from previous part...)

You are looking to secure your publisher to prevent unauthorized logins from accessing the data through replication. Where do you add the list of logins that have access?

Answer
Add them to the Publication Access List in the publication database.

Explanation
All access to publications is controlled with the Publication Access List (PAL), which is similar to the Windows ACLs. A list is created for each publication that is set up.

What does the ERROR_PROCEDURE() function return?

Answer
The name of the stored procedure that caused an error.

Explanation
The ERROR_PROCEDURE() function is placed in the catch block of a TRY..CATCH construct and returns the name of the procedure that caused an error to be thrown.

Credentials in SQL Server 2005 are used to access what?

Answer
Resources outside the SQL Server

Explanation
A credential is used to access resources outside of SQL Server. It contains the authentication information needed for accessing these resources.

Which of the following is an invalid file name for a database file?

Answer
None of the above

Explanation
Explanation from BOL: SQL Server 2005 does not enforce the .mdf, .ndf, and .ldf file name extensions, but these extensions help you identify the different kinds of files and their use.

(Continued on next part...)