You work as a database administrator at ABC.com.ABC.com is making use of a SQL Server 2008
R2 instance.
ABC.com has introduced a new security to allow members of a Windows group, called ABC_Prod,
to build new links to the SQL Server instance. The ABC_Prod group should only be able to build
these links from 10 AM to 10 PM. The new policy will be hosted by a table, called
RestrictedTester.
You are then informed that the implementation of the security policy should also allow for other
ABC.com users to access the instance at any time.
You realize that to achieve this, you have to create a logon trigger that prevents the ABC_Prod
group from accessing the instance outside of the allotted hours.
Which of the following options are TRUE with regards to logon triggers? (Choose all that apply.)
A.
If authentication fails, logon triggers do not fire.
B.
Logon triggers fire whether authentication fails, or not.
C.
Logon triggers can be used to track login activity, restrict logins to SQL Server, or limit the
number of sessions for a specific login.
D.
Logon triggers can be used to track login activity, restrict logins to SQL Server, but not to limit
the number of sessions for a specific login.
Explanation: