You develop a Microsoft SQL Server 2012 database that contains tables named Employee and
Person. The tables have the following definitions:

You create a view named VwEmployee as shown in the following Transact-SQL statement.

Users are able to use single INSERT statements or INSERT…SELECT statements into this view.
You need to create an audit record only when either the Retail Price to insert records into both
Employee and Person tables by using the VwEmployee view. Which Transact-SQL statement
should you use?

A.
Option A

B.
Option B

C.
Option C

D.
Option D