You are the administrator of your company network. You are reviewing and configuring the security of a SQL Server 2008 instance. The instance includes database DB1.The security audit policy requires that only successful and failed logon attempts are recorded in log files, besides this, if records cannot be written to the log files, the SQL Server instance must be shut down. You have to configure the SQL Server instance to be coordinated with the security audit policy. Which Transact-SQL statements should you run?

A.
sp_configure ‘show advanced options’, 1;GO RECONFIGURE;GO sp_configure ‘default trace enabled’, 1;GO RECONFIGURE GO

B.
sp_configure ‘show advanced options’, 1;GO RECONFIGURE;GO sp_configure ‘common criteria compliance enabled’, 1;GO RECONFIGURE GO

C.
CREATE SERVER AUDIT Srv_Audit TO FILE ( FILEPATH =’\\MAIN_SERVER\Audit\’ ) WITH
(ON_FAILURE = SHUTDOWN);GO CREATE SERVER AUDIT SPECIFICATION Audit_Specification
FOR SERVER AUDIT Srv_Audit ADD (SUCCESSFUL_LOGIN_GROUP),ADD (FAILED_LOGIN_GROUP) WITH (STATE=ON);GO ALTER SERVER AUDIT Srv_Audit WITH (STATE=ON);GO

D.
CREATE SERVER AUDIT Srv_Audit TO FILE ( FILEPATH =’\\MAIN_SERVER\Audit\’ ) WITH
(ON_FAILURE = SHUTDOWN);GO CREATE DATABASE AUDIT SPECIFICATION Audit_Specification FOR SERVER AUDIT Srv_Audit ADD (SUCCESSFUL_LOGIN_GROUP),ADD
(FAILED_LOGIN_GROUP) WITH (STATE=ON);GO ALTER SERVER AUDIT Srv_Audit WITH (STATE=ON);GO