You work as a Database Administrator (DBA) at ABC.com. All databases are hosted on Windows
Server 2012 servers running SQL Server 2012.
An application named CorpApp1 accesses data from multiple tables on a SQL Server named
ABC-SQL1. The data is accessed using a view.
You want to use the view to modify the tables by inserting rows.
How can you insert rows into the tables using the view?

A.
Modify the view by adding an INSTEAD OF trigger.

B.
Use the SCHEMABINDING option when defining the view.

C.
By creating a snapshot of the view.

D.
Use the ENCRYPTION option when defining the view.

Explanation: