Which features should you identify?

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.

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.

Answer:

Explanation:

Reference:

* 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 of compliance, 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.



Leave a Reply 2

Your email address will not be published. Required fields are marked *


adityomagnet@gmail.com

[email protected]

I Think this option not consistent,
Email must be sent when user login => triggers
Email must be sent if authentication mode changes => Policy-based management

Rubin

Rubin

Downlaod nnew Madden 17 Coinn Glitch and Generator game!

Best Madden NFL 17 Coin Glitch and Generator for
unlimied Cash and Coins!
DOWNLOAD LINK : Madden NFL 17 Coin Glich and Generator