Which action should you take?

You are a database developer on an instance of SQL Server 2008. You are creating a view that will allow users to query information for customer orders. Some users have full database access. You want to prevent these users from viewing the SELECT statement that defines the view. Which action should you take?
A. Delete the view from sys.objects.
B. Alter the view to remove schema binding.
C. Drop the view and re-create it including WITH ENCRYPTION.
D. Implement Transparent Data Encryption (TDE) for the view.

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.