You work as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. Your duties include administrating a SQL Server 2005 database named Certkiller -DB01. You have received instruction from the CIO to create a view to join the Clients and Products tables in Certkiller -DB01. You instruct him to make sure that the view cannot be affected by modifications to underlying table schemas. You need to accomplish this with the minimal amount of overhead.
What should Rory Allen do?
A.
You need to create the view and identify the WITH SCHEMABINDING option.
B.
You need to create a SCHEMA option on the tables.
C.
You need to create a DML AFTER trigger to roll back the changes to the tables if the changes affect the columns in the view.
D.
You need to create a DDL trigger to roll back any changes to the tables if the changes affect the columns in the view.
E.
You need to specify the WITH CHECK option first.
Thereafter you can create the view.
Explanation:
Once you identify the SCHEMABINDING option, you are unable to drop any tables, views, or functions referenced by the view without first dropping the view.