70-431 Microsoft SQL Server 2005 - Implementation and Maintenance Testking Exam

Demo Question 6.

You work as a database administrator at EliteCertify.com. The EliteCertify.com network consists of a single Active Directory domain named EliteCertify.com. Your duties include administrating a SQL Server 2005 database named EliteCertify -DB01. You have received instruction from the CIO to create a view to join the Clients and Products tables in EliteCertify -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.


Display Answer

Answer: A

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.