您要检查和配置SQL Server 2008实例的安全性，该实例中包含数据库DB1。安全审核策略指定了以下要求：日志文件中只记录成功和失败的登录尝试。如果记录无法写入日志文件，则关闭SQL Server 实例。您需要配置SQL Server实例，使其符合安全审核策略。您应该运行哪些 Transact-SQL语句？
A.sp_configure ‘show advanced option’;1; GO RECONFIGURE; GO sp_configure ‘default trace enabled’,1;GO RECONFIGURE GO
B.sp_configure ‘show advanced option’,1; GO RECONFIGURE; GO sp_configure ‘common criteria compliance enable’,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
正确答案是C