Which technologies should you recommend?

DRAG DROP
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 to generate reports must be allowed to make a connection during
certain hours only.
• Failed authentication requests must be logged.
You need to recommend a technology that meets each business requirement. The solution
must minimize the amount of events that are logged.
Which technologies should you recommend?
To answer, drag the appropriate solution to the correct business requirement in the answer area.

Answer:

Explanation:

Reference:
* Logon triggers fire stored procedures in response to a LOGON event. This event is raised
when a user session is established with an instance of SQL Server. Logon triggers fire after
the authentication phase of logging in finishes, but before the user session is actually
established.
You can use logon triggers to audit and control server sessions, such as by tracking login
activity, restricting logins to SQL Server, or limiting the number of sessions for a specific
login.
* Login auditing can be configured to write to the error log on the following events.
Failed logins
Successful logins
Both failed and successful logins
Incorrect:
* C2 audit mode can be configured through SQL Server Management Studio or with the c2
audit mode option in sp_configure. Selecting this option will configure the server to record
both failed and successful attempts to access statements and objects.