Which four Transact-SQL statements should you use to develop the solution?

DRAG DROP

You are a database administrator for an organization.

Members of the human resources department can add new employee records to the HR.Employees table. All members of the human resources department are assigned the Human Resources database role.

You need to audit inserts to the table.

Which four Transact-SQL statements should you use to develop the solution? To answer, move the appropriate Transact-SQL statements from the list of Transact-SQL statements to the answer area and arrange them in the correct order.

View Answer

Answer:

Explanation:

Box 1: Use MASTER;

Box 2: CREATE SERVER AUDIT … Only specify the file path.

Box 3: Use DB1;

Box 4: CREATE DATABASE AUDIT..

Specify the table etc.

References: https://docs.microsoft.com/en-us/sql/t-sql/statements/create-database-audit­specification-transact-sql?view=sql-server-2017