You are a database developer at an independent software vendor. You create stored procedures
that contain proprietary code.
You need to protect the code from being viewed by your customers.
Which stored procedure option should you use?
A.
ENCRYPTBYKEY
B.
ENCRYPTION
C.
ENCRYPTBYPASSPHRASE
D.
ENCRYPTBYCERT
Explanation:
http://technet.microsoft.com/en-us/library/bb510663.aspx
http://technet.microsoft.com/en-us/library/ms174361.aspx
http://msdn.microsoft.com/en-us/library/ms187926.aspx
http://technet.microsoft.com/en-us/library/ms190357.aspx
http://technet.microsoft.com/en-us/library/ms188061.aspx
b
B.
Encryption – Indicates that SQL Server will convert the original text of the CREATE PROCEDURE statement to an obfuscated format. The output of the obfuscation is not directly visible in any of the catalog views in SQL Server. Users who have no access to system tables or database files cannot retrieve the obfuscated text. However, the text will be available to privileged users who can either access system tables over the DAC port or directly access database files. Also, users who can attach a debugger to the server process can retrieve the decrypted procedure from memory at runtime. For more information about accessing system metadata, see Metadata Visibility Configuration.
B.
ENCRYPTION
b
ENCRYPTION does not exist
but WITH ENCRYPTION exists
so I believe it is A.ENCRYPTBYKEY