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.
Bạn đang xem 16. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P141 DOC