Microsoft
70-450 · Question #123
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…
The correct answer is C. Replace all public static fields with public static read-only fields. See the full explanation below for the reasoning.
Question
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?
Options
- AUse the SAFE code access security for the assembly.
- BReplace all public static fields with public fields.
- CReplace all public static fields with public static read-only fields.
- DReplace all public static fields with public static read-only fields.
How the community answered
(56 responses)- A4% (2)
- B13% (7)
- C77% (43)
- D7% (4)
Community Discussion
No community discussion yet for this question.