You are a database developer. You plan to design a database solution by using SQL Server 2008. You configure a database on a server to use a common language runtime (CLR). You need to create a CLR assembly that enables the CLR stored procedure to access environment variables available on the server. You also need to ensure that the CLR assembly has the minimum permissions assigned. What should you do?
A.
Enable the TRUSTWORTHY database property.
B.
Create the assembly by using the SAFE permission set.
C.
Create the assembly by using the UNSAFE permission set.
D.
Create the assembly by using the EXTERNAL_ACCESS permission set.
Explanation:
EXTERNAL_ACCESS enables assemblies to access certain external system resources such as files, networks, environmental variables, and the registry.