You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008 R2
instance that contains a database named ABC_DB1.
The ABC.com management would like the database security to be configured in such a way that
the log files exclusively contain data regarding successful and unsuccessful logon attempts.
You have decided to make use of the sp_configureTransact-SQL statement.
Which of the following actions should you take?
A.
You should consider enabling the common criteria complianceoption.
B.
You should consider enabling the c2 audit mode option.
C.
You should consider enabling the ad hoc distributed queries option.
D.
You should consider enabling the clr enabled option.
Explanation: