You administer a SQL Server 2008 instance. You plan to design the security requirements
for a new database application. The application uses a code segment that contains the
following components: A method that accesses the registry on the SQL Server. A method
that accesses the file system on a network file server. A class definition that uses public
static fields The code segment uses SQL CLR integration and is implemented as a single
assembly. You need to ensure that the application is successfully deployed to the instance.
What should you do?
A.
Replace all public static fields with public static read-only fields. Register the assembly by
using the regasm.exe utility before deployment.
B.
Use the SAFE code access security for the assembly.
C.
Replace all public static fields with public fields.
D.
Replace all public static fields with public static read-only fields. Use the
EXTERNAL_ACCESS code access security for the assembly.
Explanation: