Microsoft
70-450 · Question #125
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…
The correct answer is B. Use a logon trigger. See the full explanation below for the reasoning.
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.
How the community answered
(50 responses)- A12% (6)
- B80% (40)
- C6% (3)
- D2% (1)
Community Discussion
No community discussion yet for this question.