Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets the stated goals.

You have a database that contains a table named Employees.

The table stored information about the employees of your company.

You need to implement the following auditing rules for the Employees table:

Record any changes that are made to the data in the Employees table.

Customize the data recorded by the audit ope

rations.

Solution: You implement a stored procedure on the Employees table.

Does the solution meet the goal?

A. Yes

B. No

Explanation:

We should use table-valued functions, not procedures, to customize the recorded change data.

References:

https://msdn.microsoft.com/en-us/library/cc645858.aspx