Get 70-461 PDF With Actual Questions Answers

Question No : 3

You are developing a database in SQL Server 2012 to store information about current employee project assignments.

You are creating a view that uses data from the project assignment table.

You need to ensure that the view does not become invalid if the schema of the project assignment table changes.

What should you do?

A. Create the view by using an account in the sysadmin role.
B. Add a DDL trigger to the project assignment table to re-create the view after any schema change. C. Create the view in a new schema.
D. Add a DDL trigger to the view to block any changes.

Answer: B 
Explanation: 
DDL triggers are a special kind of trigger that fire in response to Data Definition Language (DDL) statements. They can be used to perform administrative tasks in the database such as auditing and regulating database operations.

Reference: 
DDL Triggers https://technet.microsoft.com/en-us/library/ms190989(v=sql.105).aspx