Microsoft
70-432 · Question #110
You are the administrator of a SQL Server 2008 instance with a database named DB1. According to the requirements of the security audit policy only successful and failed logon attempts are recorded…
The correct answer is D. CREATE SERVER AUDIT Srv_Audit TO FILE ( FILEPATH ='\\MAIN_SERVER\Audit\' ) WITH (ON_FAILURE =. See the full explanation below for the reasoning.
Question
You are the administrator of a SQL Server 2008 instance with a database named DB1. According to the requirements of the security audit policy only successful and failed logon attempts are recorded in log files. if records cannot be written to the log files, the SQL Server instance is shut down. You have to make the SQL Server instance comply with the security audit policy by performing the configuration. Which Transact-SQL statements should you run?
Options
- Asp_configure 'show advanced options', 1;
- Bsp_configure 'show advanced options', 1;
- CCREATE SERVER AUDIT Srv_Audit TO FILE ( FILEPATH ='\MAIN_SERVER\Audit' ) WITH (ON_FAILURE =
- DCREATE SERVER AUDIT Srv_Audit TO FILE ( FILEPATH ='\MAIN_SERVER\Audit' ) WITH (ON_FAILURE =
How the community answered
(24 responses)- A4% (1)
- B8% (2)
- C13% (3)
- D75% (18)
Community Discussion
No community discussion yet for this question.