Microsoft
70-450 · Question #125
70-450 Question #125: Real Exam Question with Answer & Explanation
Sign in or unlock 70-450 to reveal the answer and full explanation for question #125. The question stem and answer options stay visible for context.
Question
Your SQL Server 2008 server has only the SQL Server service running. All other SQL Services are disabled. You have a user named DBReportsUser. You need to restrict DBReportsUser to login only between 17:00 hours and 22:00 hours. You want to achieve this goal by using the minimum amount of administrative effort and the least impact on the Server security. What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
Options
- AUse SQL Profiler.
- BUse a logon trigger.
- CEnable login auditing.
- DCreate a SQL Server Agent job.
Unlock 70-450 to see the answer
You've previewed enough free 70-450 questions. Unlock 70-450 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.