70-465 · Question #7
Drag and Drop Question 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…
The correct answer is Policy-Based Management; a SQL Server Agent alert. A trigger is the correct feature for sending an e-mail when a user logs in, as logon triggers fire in response to a LOGON event and can execute T-SQL code such as sending database mail. A SQL Server Agent alert is the correct feature for monitoring CPU utilization exceeding 90…
Question
Exhibit
Answer Area
Drag items
Correct arrangement
- Policy-Based Management
- a SQL Server Agent alert
Explanation
A trigger is the correct feature for sending an e-mail when a user logs in, as logon triggers fire in response to a LOGON event and can execute T-SQL code such as sending database mail. A SQL Server Agent alert is the correct feature for monitoring CPU utilization exceeding 90 percent, as Agent alerts can be configured to respond to SQL Server performance condition events (like CPU thresholds) and notify operators via e-mail. These two features are purpose-built for their respective event-driven and performance-monitoring scenarios in SQL Server.
Topics
Community Discussion
No community discussion yet for this question.