Microsoft
70-432 · Question #145
70-432 Question #145: Real Exam Question with Answer & Explanation
Sign in or unlock 70-432 to reveal the answer and full explanation for question #145. The question stem and answer options stay visible for context.
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
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.