Which action should you take?

Correct Answer for the following Question is given below

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?The WITH ENCRYPTION clause is used to encrypt the CREATE VIEW statement that is stored in the sys.syscomments table. This ensures that the statement is not stored in plain text that is readable by others. When a view is encrypted, the view’s definition cannot be accessed using the sp_helptext system stored procedure, directly queried from the sys.sql_modules catalog view, or accessed from the Visual Designer in SQL Server Management Studio.You should not delete the view from sys.objects. You should never directly alter data in system objects, but rather allow SQL Server to manage them.You should not alter the view to remove schema binding. Schema binding of a view ensures that the base tables used by the view remain usable; it does not control whether the statement that defines the view is encrypted or stored as plain text. The WITH SCHEMABINDING clause of the CREATE VIEW statement ensures that base tables of a view cannot be dropped or modified in a way that affects the view’s definition. This prevents users from dropping or modifying base tables in such a way that the view becomes unusable. To drop base tables or make such modifications, you would need to first drop the view, alter the view omitting SCHEMABINDING, or alter the view to remove any unwanted dependencies.You should not implement Transparent Data Encryption (TDE) for the view. TDE is a special type of full database encryption that uses a symmetric key to encrypt the entire database. It is not used to encrypt the statements that define views, functions, stored procedures, or triggers.


Which action should you take?


Delete the view from sys.objects.

Alter the view to remove schema binding.

Drop the view and re-create it including WITH ENCRYPTION.

Implement Transparent Data Encryption (TDE) for the view.

Correct Answer

The Correct Answer for this Question is

Drop the view and re-create it including WITH ENCRYPTION.


The Question – Which action should you take? has been answered correctly and answers for the question is Drop the view and re-create it including WITH ENCRYPTION.

More about these Exams

These Exam Questions and the order of these questions keep changing. but the answers are obviously same. so if you don’t find a question after another we suggest you search it in the search box and we are sure you’ll find it. you can bookmark this site for Quick access in future.

We hope you found it helpful don’t forget to leave a comment if you feel a need to correct or ask we’re always here to help.

you can find more here at mnccertified

Feel free to contact via comment or email.

Happy Learning

Cheers, Team MNCcertified

You may also like...

Leave a Reply

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