Which action should you take?

You are database developer on an instance of SQL Server 2008. The development team has recently created and compiled an assembly using a .NET Framework language. The assembly includes a method that requires access to the file system. You want to allow a user to access the method directly from Transact-SQL.
Which action should you take?
A. Set the TRUSTWORTHY database property to OFF.
B. Grant the user access to the stored procedure using a database role that has elevated privileges.
C. Grant the user the db_accessadmin fixed database role.
D. Register the assembly with the EXTERNAL_ACCESS permission.

microsoft-exams

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.