Exam 70-764 topic 1 question 138 discussion

Actual exam question from Microsoft's 70-764

Question #: 138
Topic #: 1

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 when a user logs in.
✑ 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:

Show Suggested Answer

Suggested Answer:

by carlo0 at March 23, 2019, 1:09 a.m.

Comments

Submit Cancel

RohitM

Highly Voted 5 years, 2 months ago

trigger sql server agent alert.

upvoted 14 times

...

msamm

Highly Voted 5 years, 2 months ago

The correct answers are : Trigger SQL Server Agent Alert Reference : https://docs.microsoft.com/en-us/sql/relational-databases/triggers/logon-triggers?view=sql-server-2017 It is mentioned in above link that Logon Triggers help in Tracking Login Activity.

upvoted 5 times

...

TheSwedishGuy

Most Recent 4 years, 10 months ago

Logon = Trigger High CPU utilization = SQL Server Database Email Alert. Configure the alert via Object: Resource Pool Stats and Counter: CPU usage %. https://stackoverflow.com/questions/33497645/alert-when-cpu-usage-more-than-in-sql-server

upvoted 2 times

...

cian

5 years, 4 months ago

Policy Based Management SQL Server Agent Alert

upvoted 2 times

...

carlo0

5 years, 8 months ago

there is no choices from the sample and it shows the answers on the answer area.

upvoted 1 times

...

Exam 70-764 All Questions

View all questions & answers for the 70-764 exam