Question 37

Answer B is correct. EXTERNAL_ACCESS enables assemblies to access certain external system resources such as files, networks, environmental variables, and the registry. The default setting is SAFE, which is the most restrictive permission set. Code executed by an assembly with SAFE permissions cannot access external system resources such as files, the network, environment variables, or the registry.

For more information, see the following sources:

• Chapter 3, "Implementing Database Objects"

• SQL Server 2005 Books Online: "Samples and Sample Databases, Samples, SQL Server SQL Server Database Engine Samples, Programmability Samples, CLR Programmability Samples"

• "Programmability," http://msdn.microsoft.com/sql/learning/prog/default.aspx

• "Assemblies (Database Engine)," http://msdn2.microsoft.com/en-us/library/ms186221(SQL.90).aspx