You are a database administrator for AIOTestKing.com. You are configuring a SQL Server 2005 database on a server named ServerA to use a CLR user-defined type. The CLR user-defined type needs to access a configuration file on a server named ServerB. You create a CLR assembly by using the default permission set. However, when the CLR user-defined type is called on ServerA, the assembly returns a security error. You need to correct the problem. What should you do?
A.
Alter the assembly to use the SAFE permission set.
B.
Alter the assembly to use the EXTERNAL_ACCESS permission set.
C.
Alter the assembly to use the VISIBILITY = ON option.
D.
Alter the assembly to use the UNCHECKED DATA option.
Explanation:
EXTERNAL_ACCESS enables assemblies to access certain external system resources such as files, networks, environmental variables, and the registry.