Why do you use an INSTEAD OF trigger?

Why do you use an INSTEAD OF trigger?

A.
To perform clean up actions when ending a user session.

B.
To insert data into a view that normally does not accept inserts.

C.
To insert into an audit table when data is updated in a sensitive column.

D.
To modify data in which the DML statement has been issued against an inherently non-updateable view.

Explanation:
An INSTEAD OF trigger is used to perform a DML activity on the underlying tables of a view that is inherently non-updatable.
Incorrect Answers

A: This could be performed by a System Event Trigger (BEFORE LOGOFF) not by an INSTEAD OF Trigger.
B: You can’t insert data into a view, however, you can insert data into the underlying table that the view is based on.
C: This would not require an INSTEAD of Trigger, rather you would specify BEFORE UPDATE OF ColumnName ON TableName.