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 operations.
Solution: You implement a check constraint on the Employees table.Does the solution meet the goal?
A.
Yes
B.
No
Explanation:
Check constraints cannot be used to track changes in a table.
https://msdn.microsoft.com/en-us/library/bb933994.aspx