Microsoft
70-451 · Question #90
You are a database developer. You plan to design a database solution by using SQL Server 2008. You configure a database on a server to use a common language runtime (CLR). You need to create a CLR…
The correct answer is D. Create the assembly by using the EXTERNAL ACCESS permission set. See the full explanation below for the reasoning.
Question
You are a database developer. You plan to design a database solution by using SQL Server 2008. You configure a database on a server to use a common language runtime (CLR). You need to create a CLR assembly that enables the CLR stored procedure to access environment variables available on the server. You also need to ensure that the CLR assembly has the minimum permissions assigned. What should you do?
Options
- AEnable the TRUSTWORTHY database property.
- BCreate the assembly by using the SAFE permission set.
- CCreate the assembly by using the UNSAFE permission set.
- DCreate the assembly by using the EXTERNAL ACCESS permission set.
How the community answered
(22 responses)- A5% (1)
- B14% (3)
- C5% (1)
- D77% (17)
Community Discussion
No community discussion yet for this question.