You are a professional level SQL Sever 2008 Database Administrator in an international corporation
named Wiikigo. You are experienced in managing databases in an enterprise-level organization, optimizing
and sustaining the database life cycle.
In the company, your job is to implement solutions on security, troubleshooting, deployment and optimization.
A SQL Server 2008 instance is managed by you. The security requirements should be designed for a new database application.
A code segment is utilized by the application, and the code segment includes the following components:
A method that the registry is accessed on the SQL Server,
a method that the file system is accessed on a network file server, and a class definition that public static fields are utilized.
SQL CLR integration is utilized by the code segment, and the code segment is implemented as a single assembly.
Since you are the technical support, you are required to make sure that the application should be successfully deployed to the instance.
Which action will you perform?
A.
The SAFE code access security should be utilized for the assembly.
B.
All public static fields should be replaced with public fields.
C.
All public static fields should be utilized with public static read-only fields. And then the assembly should be registered by utilizing the regasm.exe utility before deployment.
D.
All public static fields should be replaced with public static read-only fields. And then the EXTERNAL_ACCESS code access security should be utilized for the assembly.