You are reviewing and configuring the security of a SQL Server 2008 instance that contains
database DB1.
The security audit policy specifies the following requirements:
Only successful and failed logon attempts are recorded in log files.
The SQL Server instance is shut down if records cannot be written to the log files.
You need to configure the SQL Server instance to comply with the security audit policy.
Which Transact-SQL statements should you run?
A.
sp_configure ‘show advanced options’, l:GORECONFIGURE:GOsp_configure ‘default
trace enabled’. 1 ;GORECONFIGUREGO
B.
sp_configure ‘show advanced options’. 1 ;GORECONFIGURE;GOsp_configure ‘common
criteria compliance enabled’. 1 ;GORECONFIGUREGO
C.
CREATE SERVER AUDIT Srv_Audit TO FILE ( FILEPATH =’\\MAIN_SERVER\AuditV )
WITH (ON_FAILURE = SHUTDOWN) ;GOCREATE DATABASE AUDIT SPECIFICATION
Audit_SpecificationFOR SERVER AUDIT Srv_Audit ADD
(SUCCESSFUL_LOGIN_GROUP).ADD (FAILED_LOGIN_GROUP) WITH (STATE=ON);GO
ALTER SERVER AUDIT SrvAucfit WITH (STATE=ON);GO
D.
CREATE SERVER AUDIT Srv_Audit TO FILE (FILEPATH =`\\MAIN_SERVER\Audit\’)
WITH (ON_FAILURE = SHUTDOWN);GOCREATE SERVER AUDIT SPECIFICATION
Audit_SpecificationFOR SERVER AUDIT Srv_Audit ADD
(SUCCESSFUL_LOGIN_GROUP),ADD (FAILED_LOGIN_GROUP) WITH
(STATE=ON);GOALTER SERVER AUDIT Srv_Audit WITH (STATE=ON);GO
Explanation: