PrepAway - Latest Free Exam Questions & Answers

What should you do?

You are a database administrator for AIOTestKing.com. You are configuring a SQL Server 2005 database on a server named ServerA to use a CLR user-defined type. The CLR user-defined type needs to access a configuration file on a server named ServerB. You create a CLR assembly by using the default permission set. However, when the CLR user-defined type is called on ServerA, the assembly returns a security error. You need to correct the problem. What should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
Alter the assembly to use the SAFE permission set.

B.
Alter the assembly to use the EXTERNAL_ACCESS permission set.

C.
Alter the assembly to use the VISIBILITY = ON option.

D.
Alter the assembly to use the UNCHECKED DATA option.

Explanation:
EXTERNAL_ACCESS enables assemblies to access certain external system resources such as files, networks, environmental variables, and the registry.


Leave a Reply