DP-300 · Question #405
Hotspot Question You have an Azure subscription that contains a SQL Server instance on a virtual machine named Server1. You execute the following T-SQL statement on Server1. For each of the…
The correct answer is An alert will be generated when a fatal error occurs. = Yes; A SQL Server Agent job will run when an alert is generated. = No; An email will be sent to [email protected] when an alert is generated. = Yes. The T-SQL statement creates a SQL Server Agent alert using sp_add_alert with a severity level of 20 (fatal errors affecting all connections), which means an alert is triggered on fatal errors. The alert is configured with a notification operator linked to an email address…
Question
Exhibits
Answer Area
- An alert will be generated when a fatal error occurs.Yes
- A SQL Server Agent job will run when an alert is generated.No
- An email will be sent to [email protected] when an alert is generated.Yes
Explanation
The T-SQL statement creates a SQL Server Agent alert using sp_add_alert with a severity level of 20 (fatal errors affecting all connections), which means an alert is triggered on fatal errors. The alert is configured with a notification operator linked to an email address ([email protected]) via sp_add_notification, so an email is sent when the alert fires. However, no job_id or job_name parameter is specified in the alert definition, meaning no SQL Server Agent job is associated with or executed when the alert is generated - only the operator notification (email) is configured.
Topics
Community Discussion
No community discussion yet for this question.