You are a database developer. You plan to design a database solution by using SQL Server
2008. A database contains a view that has the following features: ·It contains a WHERE
clause that filters specific records. ·It allows data updates. You need to prevent data
modifications that do not conform to the WHERE clause. You want to achieve this goal by
using minimum effort. What should you do?
A.
Create an INSTEAD OF trigger on the view.
B.
Create a unique clustered index on the view.
C.
Alter the view by adding the WITH CHECK OPTION clause.
D.
Alter the view by adding the WITH SCHEMABINDING clause.
Explanation: