DP-300 · Question #405
DP-300 Question #405: Real Exam Question with Answer & 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 (DBA-Te
Question
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 following statements, select Yes if the statement is true, otherwise select No. NOTE: Each correct selection is worth one point. Answer:
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.