COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which of the following is not a target for SQL Server Audit?
|
|
File
|
|
|
Windows Application Log
|
|
|
Ring Buffer
|
|
|
None of the above
|
Explanation:
Detailed explanation-1: -The results of an audit are sent to a target, which can be a file, the Windows Security event log, or the Windows Application event log.
Detailed explanation-2: -The ring buffers are created during SQL Server startup, and record alerts within the SQL Server system for internal diagnostics.
Detailed explanation-3: -SQL Server Audit consists of several object components, including SQL Server Audit, SQL Server Audit Specification, Database Audit Specification, and a target.
Detailed explanation-4: -Explanation: ON State enables the audit.
There is 1 question to complete.