070-462 Free Dumps Study Materials
Question 16: 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.)
Correct Answer: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.
The general process for creating and using an audit is as follows.
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