You are developing a database in SQL Server 2012 to store information about current employee projec

t 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.

Explanation:

DDL trigger

s 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