DRAG DROP
You plan to deploy SQL Server 2014.
Your company identifies the following monitoring requirements for the database:
An e-mail message must be sent if the SQL Server Authentication mode changes.
An e-mail message must be sent if CPU utilization exceeds 90 percent.
You need to identify which feature meets each monitoring requirement.
Which features should you identify?
To answer, drag the appropriate feature to the correct monitoring requirement in the answer area.
Select and Place:
Explanation:
* Policy-Based Management is helpful in resolving the issues presented in the following scenario:
A company policy prohibits enabling Database Mail or SQL Mail. A policy is created to check the server state of
those two features. An administrator compares the server state to the policy. If the server state is out ofcompliance, the administrator chooses the Configure mode and the policy brings the server state into
compliance.
* Events are generated by SQL Server and entered into the Microsoft Windows application log. SQL Server
Agent reads the application log and compares events written there to alerts that you have defined. When SQL
Server Agent finds a match, it fires an alert, which is an automated response to an event. In addition to
monitoring SQL Server events, SQL Server Agent can also monitor performance conditions and Windows
Management Instrumentation (WMI) events.
To define an alert, you specify:
The name of the alert.
The event or performance condition that triggers the alert.
The action that SQL Server Agent takes in response to the event or performance condition.Configure Alerts to Notify Policy Administrators of Policy Failures
SQL Server Agent
1. triggers (a logon trigger) Policys can’t do this kind of things.
2. is okay
Note that Description and picture are a bit different:
>> An e-mail message must be sent if the SQL Server Authentication mode changes.
So it’s not clear what the answer is correct for 1.