Microsoft
70-432 · Question #110
70-432 Question #110: Real Exam Question with Answer & Explanation
Sign in or unlock 70-432 to reveal the answer and full explanation for question #110. The question stem and answer options stay visible for context.
Question
You are the administrator of a SQL Server 2008 instance with a database named DB1. According to the requirements of the security audit policy only successful and failed logon attempts are recorded in log files. if records cannot be written to the log files, the SQL Server instance is shut down. You have to make the SQL Server instance comply with the security audit policy by performing the configuration. Which Transact-SQL statements should you run?
Options
- Asp_configure 'show advanced options', 1;
- Bsp_configure 'show advanced options', 1;
- CCREATE SERVER AUDIT Srv_Audit TO FILE ( FILEPATH ='\MAIN_SERVER\Audit' ) WITH (ON_FAILURE =
- DCREATE SERVER AUDIT Srv_Audit TO FILE ( FILEPATH ='\MAIN_SERVER\Audit' ) WITH (ON_FAILURE =
Unlock 70-432 to see the answer
You've previewed enough free 70-432 questions. Unlock 70-432 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.