70-450 · Question #71
You are a professional level SQL Sever 2008 Database Administrator. The security requirements should be designed for a new database application. A code segment is utilized by the application, and…
The correct answer is D. All public static fields should be replaced with public static read-only fields. And then the. Creates a managed application module that contains class metadata and managed code as an object in an instance of SOL Server. By referencing this module, common language runtime (CLR) functions, stored procedures, triggers, user-defined aggregates, and user-defined types can be…
Question
You are a professional level SQL Sever 2008 Database Administrator. 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
- A class definition that public static fields are utilized
- SQL CLR integration is utilized by the code segment
- 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?
Options
- AThe SAFE code access security should be utilized for the assembly.
- BAll public static fields should be replaced with public fields.
- CAll public static fields should be utilized with public static read-only fields. And then the
- DAll public static fields should be replaced with public static read-only fields. And then the
How the community answered
(23 responses)- A4% (1)
- B4% (1)
- C9% (2)
- D83% (19)
Explanation
Creates a managed application module that contains class metadata and managed code as an object in an instance of SOL Server. By referencing this module, common language runtime (CLR) functions, stored procedures, triggers, user-defined aggregates, and user-defined types can be created in the database. PERMISSION_SET { SAFE | EXTERNAL_ACCESS I UNSAFE} Specifies a set of code access permissions that are granted to the assembly when it is accessed by SOL Server. If not specified, SAFE is applied as the default. We recommend using SAFE. SAFE is the most restrictive permission set. Code executed by an assembly with SAFE permissions cannot access external system resources such as files, the network, environment variables, or the registry. EXTERNAL_ACCESS enables assemblies to access certain external system resources such as files, networks, environmental variables, and the registry.
Topics
Community Discussion
No community discussion yet for this question.