WITHIN YOUR APPLICATION, YOU NEED TO LOG ALL CHANGES TO ONE TABLE....

16. Within your application, you need to log all changes to one table. DDL and

DML changes must be logged. What’s the best approach to solve this problem?

A. Use the built-in auditing capability

B. Create a DDL trigger

C. Create a DML trigger

D. This cannot be accomplished

A is the correct answer. SQL Server 2008 has built-in auditing capability.

Answers B and C are incorrect as they are not a complete solution. Answer D

is incorrect, as this can be accomplished with Answer A.