Microsoft
70-432 · Question #165
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…
The correct answer is C. Create a server audit specification. See the full explanation below for the reasoning.
Question
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?
Options
- AEnable C2 auditing.
- BEnable common criteria compliance.
- CCreate a server audit specification.
- DConfigure Change Data Capture.
How the community answered
(30 responses)- A3% (1)
- B10% (3)
- C83% (25)
- D3% (1)
Community Discussion
No community discussion yet for this question.