Microsoft Exam Questions

What should you do?

You create an application by using Microsoft Visual Studio .NET 2008 and the .NET Framework 3.5.
The application stores human resources data in a Microsoft SQL Server 2008 database. A partial database schema is as shown in the exhibit.
(Click the Exhibit button.) Each time a row is added, modified, or deleted from the Employee table, a corresponding entry must be recorded
in the EmployeeChangeLog table. You need to implement the data change logging.
What should you do?

A.
Create a trigger on the Employee table.

B.
Add a user-defined function to the database.

C.
Add a CHECK constraint to the Employee table.

D.
Create a foreign key on the EmployeeChangeLog table that references the Employee table.