Microsoft
70-432 · Question #145
You are managing a SQL Server 2008 computer called SQLTEST1. You should configure the SQL Server service and the SQL Server Agent service to start automatically, and set SQLTEST1 to audit all user…
The correct answer is B. You should create a SQL Server Agent job to run the SQL Trace stored procedure. See the full explanation below for the reasoning.
Question
You are managing a SQL Server 2008 computer called SQLTEST1. You should configure the SQL Server service and the SQL Server Agent service to start automatically, and set SQLTEST1 to audit all user names and application names that plan to get information from SQLTEST1. SQLTEST1 must operate auditing always, and you should keep the results for 10 years. Which is the correct answer?
Options
- AYou should disable the C2 Audit Tracing setting on the server properties.
- BYou should create a SQL Server Agent job to run the SQL Trace stored procedure.
- CYou should set the Login auditing setting to both failed and successful logins
- DYou should configure the server authentication mode as SQL Server and Windows
How the community answered
(29 responses)- A17% (5)
- B72% (21)
- C7% (2)
- D3% (1)
Community Discussion
No community discussion yet for this question.