Home » Microsoft » 70-764 v.2 » How should you complete the Transact-SQL statement?
HOTSPOT
You are a database administrator for an organization. You manage a mission-critical database named DB1 that is hosted on a server named LON-SQL1.
An audit record for transactions that occur in DB1 are written to a file every five seconds. If an audit record cannot be recorded, the transaction must be terminated. You create a shared folder named Audits on a server named LON-SVR1.
You need to implement the process for recording audit records.
How should you complete the Transact-SQL statement? To answer, select the appropriate Transact-SQL segment in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Correct Answer:
Explanation/Reference:
Explanation:
Box 1: Server Audit
The CREATE SERVER AUDIT command creates a server audit object using SQL Server Audit.
Box 2: FILE(FILEPATH=’\LON-SVR1Audits’)
An audit record for transactions that occur in DB1 are written to a file every five seconds. You create a shared folder named Audits on a server named LONSVR1.
Box 3: QUEUE_DELAY=5000
QUEUE_DELAY =integer Determines the time, in milliseconds, that can elapse before audit actions are forced to be processed. A value of 0 indicates synchronous delivery. The minimum settable query delay value is 1000 (1 second), which is the default.
Box 4: ON_FAILURE= FAIL_OPERATION
FAIL_OPERATION
Database actions fail if they cause audited events. Actions, which do not cause audited events can continue, but no audited events can occur. The audit continues to attempt to log events and resumes if the failure condition is resolved. Use this option when maintaining a complete audit is more important than full access to the Database Engine.
References: https://docs.microsoft.com/en-us/sql/t-sql/statements/create-server-audit-transact-sql