You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance that contains a database named CK_DB1. The Domain.com management would
like the database to conform to the following security requirements:
Only successful and failed logon attempts in log files.
The SQL Server 2008 instance must close if the records are not written to the log files.
You need to set the SQL Server sample to conform to the security requirements.
What should you do?
A.
You should consider using the following:
sp_configure ‘show advanced options’, 1;
GO
RECONFIGURE;
GO
sp_configure ‘common criteria compliance enabled’, 1;
GO
RECONFIGURE
GO
B.
You should consider using the following:
(STATE=ON);
GO
ALTER SERVER AUDIT Srv_Audit WITH (STATE=ON);
GO
C.
You should consider using the following:
sp_configure ‘default trace enabled’, 0;
GO
RECONFIGURE
GO
D.
You should consider using the following:
sp_configure ‘show advanced options’, 1;
GO
RECONFIGURE;
GO
sp_configure ‘common criteria compliance enabled’, 0;
GO
RECONFIGURE
GO
E.
You should consider adding the following:
CREATE SERVER AUDIT Srv_Audit TO FILE ( FILEPATH =’SQL_SERVERAudit’ ) WITH
(ON_FAILURE = SHUTDOWN);
GO
CREATE SERVER
F.
You should consider using the following:
sp_configure ‘show advanced options’, 0;
GO
RECONFIGURE;
GO