You are the administrator of your company network. And you are in charge of a SQL Server 2008 instance. You intend to design the security requirements for a new database application which uses a code segment.
The code segment includes the components bellow: A class definition which uses public static fields A method which accesses the registry on the SQL Server A method which accesses the file system on a network file server The code segment also uses SQL CLR integration and is implemented as a single assembly. So what should you do to deploy the application to the instance successfully?
A.
You should use the SAFE code access security for the assembly.
B.
You should replace all public static fields with public fields.
C.
You should replace all public static fields with public static read-only fields. Use the EXTERNAL_ACCESS code access security for the assembly.
D.
You should replace all public static fields with public static read-only fields. Register the assembly by using the regasm.exe utility before deployment.