70-465 · Question #21
Drag and Drop Question You are designing an authentication strategy for a new server that has SQL Server 2014 installed. The strategy must meet the following business requirements: - The account used
The correct answer is logon triggers; login auditing. Logon triggers are the correct solution for restricting connections to certain hours because they fire in response to a LOGON event and can contain T-SQL logic to evaluate the time of day, rolling back the connection if it falls outside permitted hours - giving precise, programma
Question
Exhibit
Answer Area
Drag items
Correct arrangement
- logon triggers
- login auditing
Explanation
Logon triggers are the correct solution for restricting connections to certain hours because they fire in response to a LOGON event and can contain T-SQL logic to evaluate the time of day, rolling back the connection if it falls outside permitted hours - giving precise, programmable access control. Login auditing is the correct solution for logging failed authentication requests because it is specifically designed to capture failed (and/or successful) login attempts with minimal overhead, satisfying the requirement to minimize the number of events logged compared to broader auditing tools.
Topics
Community Discussion
No community discussion yet for this question.