Which code segment should you use?

You create a stored procedure that contains proprietary formulas. You need to ensure that no users are able to access Microsoft SQL Server Management Studio to view the definition of the stored procedure.
Which code segment should you use?
A. CREATE PROCEDURE Sales.uspFormula WITH EXECUTE AS SELF
B. CREATE PROCEDURE Sales.uspFormula WITH RECOMPILE
C. CREATE PROCEDURE Sales.uspFormula WITH EXECUTE AS OWNER
D. CREATE PROCEDURE Sales.uspFormula WITH ENCRYPTION

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.