Home » Microsoft » 70-462 v.2 » What should you do?
DRAG DROP
You administer a Microsoft SQL Server 2012 database named Human_Resources.
You need to ensure that all read activity against any object in the Human_Resources database is audited and written to a text file.
What should you do? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)
Select and Place:
Correct Answer:
Explanation/Reference:
Explanation:
Create a new Audit. For destination, select File.
Create a new Database Audit Specification on Human_Resources. For Audit Action Type, select Select, and for Object Class, select Database.
Enable Audi and Audi Specification.
Explanation:
The general process for creating and using an audit is as follows.
1. Create an audit and define the target.
2. Create either a server audit specification or database audit specification that maps to the audit. Enable the audit specification.
3. Enable the audit.
4. Read the audit events by using the Windows Event Viewer, Log File Viewer, or the fn_get_audit_file function.
References:
https://msdn.microsoft.com/en-us/library/cc280386%28v=sql.110%29.aspx
https://msdn.microsoft.com/en-us/library/cc280663%28v=sql.110%29.aspx