PrepAway - Latest Free Exam Questions & Answers

Tag: sql permission to use cert

What permission set should you use?

You are employed as a database administrator at Domain.com. Your duties at Domain.com are the administrating of the SQL Server 2005 database computer named Certkiller -DB07.
The application developers in the Research and Development department have created an assembly that contains a CLR function. The purpose of the CLR function is to read data from a spreadsheet, perform several calculations and returning the information to Certkiller -DB07. You need to register the assembly with Certkiller -DB07 by using the CREATE ASSEMBLY statement and the least privileged security permission set.
What permission set should you use?