C is correct.
https://learn.microsoft.com/en-us/sql/ssms/agent/configure-sql-server-agent?source=recommendations&view=sql-server-ver16
On Sql Server Managed Instance SqlAgent is always running so B is not possible.
in SQL MI, user doesnot have control to stop OR start SQL Agent and SQL agent in MI always is in running state so, next step in the process of job alert notification is to enable DB mail by running Sp_configure so, C is correct answer, configure DB mail using Exec Sp_configure
in SQL MI, user doesnot have control to stop OR start SQL Agent and SQL agent in MI always is in running state so, next step in the process of job alert notification is to enable DB mail by running exec Sp_configure so, C is correct answer, configure DB mail using Exec Sp_configure
If it isn't already enabled, first you would need to configure the Database Mail feature on SQL Managed Instance:
SQL
Copy
GO
EXEC sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
EXEC sp_configure 'Database Mail XPs', 1;
GO
RECONFIGURE
https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/job-automation-managed-instance?view=azuresql
ChatGPT doesn't provide the correct answer on this question. The Database Mail feature is independent of the SQL Server Agent and can be configured and used without enabling the SQL Server Agent. Usually we enable Database Mail feature first before enabling SQL Agent.
B. Enable the SQL Server Agent.
Explanation:
To enable SQL Agent Job email notifications, you need to enable the SQL Server Agent. The SQL Server Agent is a component of the SQL Server Database Engine that can execute scheduled administrative tasks, such as executing SQL Agent jobs. SQL Agent jobs can be configured to send email notifications based on job status. To enable the SQL Server Agent, you can use SQL Server Management Studio or Transact-SQL commands. Once the SQL Server Agent is enabled, you can configure email notifications for SQL Agent jobs in the SQL Server Agent properties.
In this page:
https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/job-automation-managed-instance?view=azuresql
they use sp_configure option.
This section is not available anymore. Please use the main Exam Page.DP-300 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
sca88
6 months, 1 week agobsk1983
1 year, 1 month agobsk1983
1 year, 1 month agoOBIJUAN88
1 year, 6 months agoamazonalex
1 year, 6 months agoU_C
1 year, 6 months agoU_C
1 year, 6 months agoDalamain
6 months, 1 week agoTheMCT
1 year, 7 months agoPranava_GCP
1 year, 6 months agoPranava_GCP
1 year, 6 months agosca88
6 months, 1 week agoKIET2131
1 year, 7 months agoCiupaz
2 years agoBigdicktome
2 years, 1 month ago