Microsoft Exam Questions

Which four Transact-SQL statements should you use?

You administer a Microsoft SQL Server 2012 server that has a database named Contoso. The Contoso
database has a table named ProductPrices in a schema named Sales.
You need to create a script that writes audit events into the application log whenever data in the ProductPrices
table is updated.
Which four Transact-SQL statements should you use? (To answer, move the appropriate statements from the
list of statements to the answer area and arrange them in the correct order.)
Select and Place:

Answer:

Explanation: