You need to configure the SQL Server instance to comply with the security audit policy

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.
What should you do?

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.
What should you do?

A.
Enable C2 auditing.

B.
Enable common criteria compliance.

C.
Create a server audit specification.

D.
Configure Change Data Capture.



Leave a Reply 0

Your email address will not be published. Required fields are marked *