Exam 70-464 topic 1 question 7 discussion

A is correct

A is correct, as there are some restrictions to prevent from updating directly through view, but Instead of trigger doesn't have those kinds of restriction.

It should be A (Instead of trigger)

Views can be created in SQL Server WITH CHECK OPTION. WITH CHECK OPTION will make sure that all INSERT and UPDATE statements executed against the view meet the restrictions in the WHERE clause, and that the modified data in the view remains visible after INSERT and UPDATE statements. To test this, we will first create a table and insert some data in it: CREATE TABLE table_1 ( id int, data nvarchar(20) ) INSERT INTO table_1 VALUES (1, 'a'), (2, 'b'), (3, 'c') Next we will create a view using the WITH CHECK option: CREATE VIEW view_1 AS SELECT * FROM table_1 WHERE data like 'b%' WITH CHECK OPTION We can see only values in the data column that start with b: SELECT * FROM view_1 view_with_check_select_1 If we try to insert into view value that doesn't meet the WHERE criteria (WHERE data like 'b%'), it will fail: INSERT INTO view_1 VALUES (4, 'd')

I think that the fact that the view is updating multiple tables makes creating an INSTEAD OF trigger a better option

INSTEAD OF triggers can be created on a view to make a view updatable. The INSTEAD OF trigger is executed instead of the data modification statement on which the trigger is defined. This trigger lets the user specify the set of actions that must happen to process the data modification statement. Therefore, if an INSTEAD OF trigger exists for a view on a specific data modification statement (INSERT, UPDATE, or DELETE), the corresponding view is updatable through that statement. For more information about INSTEAD OF triggers, see DML Triggers.