- Home
- Microsoft
- Administering Relational Databases on Microsoft Azure
- Microsoft.DP-300.v2024-06-24.q127
- Question 106
Valid DP-300 Dumps shared by ExamDiscuss.com for Helping Passing DP-300 Exam! ExamDiscuss.com now offer the newest DP-300 exam dumps, the ExamDiscuss.com DP-300 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com DP-300 dumps with Test Engine here:
Access DP-300 Dumps Premium Version
(464 Q&As Dumps, 35%OFF Special Discount Code: freecram)
<< Prev Question Next Question >>
Question 106/127
You have an Azure SQL Database managed instance named SQLMI1. A Microsoft SQL Server Agent job runs on SQLMI1.
You need to ensure that an automatic email notification is sent once the job completes.
What should you include in the solution?
You need to ensure that an automatic email notification is sent once the job completes.
What should you include in the solution?
Correct Answer: C
To send a notification in response to an alert, you must first configure SQL Server Agent to send mail.
Using SQL Server Management Studio; to configure SQL Server Agent to use Database Mail:
In Object Explorer, expand a SQL Server instance.
Right-click SQL Server Agent, and then click Properties.
Click Alert System.
Select Enable Mail Profile.
In the Mail system list, select Database Mail.
In the Mail profile list, select a mail profile for Database Mail.
Restart SQL Server Agent.
Note: Prerequisites include:
Enable Database Mail.
Create a Database Mail account for the SQL Server Agent service account to use.
Create a Database Mail profile for the SQL Server Agent service account to use and add the user to the DatabaseMailUserRole in the msdb database.
Set the profile as the default profile for the msdb database.
Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/database-mail/configure-sql-server-agent-mail-to-use-database-mail
Using SQL Server Management Studio; to configure SQL Server Agent to use Database Mail:
In Object Explorer, expand a SQL Server instance.
Right-click SQL Server Agent, and then click Properties.
Click Alert System.
Select Enable Mail Profile.
In the Mail system list, select Database Mail.
In the Mail profile list, select a mail profile for Database Mail.
Restart SQL Server Agent.
Note: Prerequisites include:
Enable Database Mail.
Create a Database Mail account for the SQL Server Agent service account to use.
Create a Database Mail profile for the SQL Server Agent service account to use and add the user to the DatabaseMailUserRole in the msdb database.
Set the profile as the default profile for the msdb database.
Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/database-mail/configure-sql-server-agent-mail-to-use-database-mail
- Question List (127q)
- Question 1: You have two instances of SQL Server on Azure virtual Machin...
- Question 2: You are designing an enterprise data warehouse in Azure Syna...
- Question 3: You have a Microsoft SQL Server 2017 server. You need to mig...
- Question 4: You have an Azure subscription that contains a logical SQL s...
- Question 5: You need to design an analytical storage solution for the tr...
- Question 6: You have an Azure subscription that contains the resources s...
- Question 7: You have an Azure SQL database named DB3. You need to provid...
- Question 8: You create all of the tables and views for ResearchDB1. You ...
- Question 9: You have SQL Server on an Azure virtual machine. You need to...
- Question 10: You have an Azure subscription. You need to deploy an Azure ...
- Question 11: You have an on-premises Microsoft SQL Server 2019 instance n...
- Question 12: You have SQL Server on an Azure virtual machine that contain...
- Question 13: You have the following Transact-SQL query. (Exhibit) Which c...
- Question 14: You have a SQL Server on Azure Virtual Machines instance nam...
- Question 15: You have an Azure subscription that contains an instance of ...
- Question 16: You have two on-premises Microsoft SQL Server 2019 instances...
- Question 17: You have an Azure Synapse Analytics workspace named WS1 that...
- Question 18: You have a new Azure subscription. You create an Azure SQL D...
- Question 19: You configure a long-term retention policy for an Azure SQL ...
- Question 20: What should you use to migrate the PostgreSQL database?...
- Question 21: You have an Azure subscription that uses a domain named cont...
- Question 22: You are designing an anomaly detection solution for streamin...
- Question 23: You are creating a new notebook in Azure Databricks that wil...
- Question 24: You need to recommend a solution to ensure that the customer...
- Question 25: You have an Azure virtual machine named VM1 on a virtual net...
- Question 26: You have an Azure subscription. You need to deploy a logical...
- Question 27: Note: This question is part of a series of questions that pr...
- Question 28: You have 20 Azure SQL databases provisioned by using the vCo...
- Question 29: You are designing a date dimension table in an Azure Synapse...
- Question 30: You have an Azure subscription that contains the resources s...
- Question 31: You are evaluating the role assignments. For each of the fol...
- Question 32: You need to migrate an on-premises Microsoft SQL Server data...
- Question 33: You have SQL Server on an Azure virtual machine that contain...
- Question 34: You have two on-premises servers that run Windows Server 201...
- Question 35: You have an instance of SQL Server on Azure Virtual Machines...
- Question 36: You are monitoring an Azure Stream Analytics job. You discov...
- Question 37: You have an on-premises Microsoft SQL Server 2019 server tha...
- Question 38: You have a Microsoft SQL Server 2019 database named DB1 that...
- Question 39: You have an Azure subscription. You plan to deploy an Azure ...
- Question 40: You have an Azure SQL logical server. You run the following ...
- Question 41: You have a on-premises Microsoft SQL Server named SQL1 that ...
- Question 42: You have an on-premises Microsoft SQL Server 2019 instance t...
- Question 43: Task 12 You need to configure high availability for dbl. The...
- Question 44: You are planning disaster recovery for the failover group of...
- Question 45: You have a Microsoft SQL Server 2019 instance in an on-premi...
- Question 46: You have an instance of SQL Server on Azure Virtual Machines...
- Question 47: Your company analyzes images from security cameras and sends...
- Question 48: You have SQL Server 2019 or an Azure virtual machine that ru...
- Question 49: You have an on-premises datacenter that contains a 2-TB Micr...
- Question 50: A company plans to use Apache Spark analytics to analyze int...
- Question 51: You have an Azure virtual machine named VM1 on a virtual net...
- Question 52: What should you implement to meet the disaster recovery requ...
- Question 53: You need to configure user authentication for the SERVER1 da...
- Question 54: You have an Azure subscription that contains a group named G...
- Question 55: Task 11 You have a legacy application written for Microsoft ...
- Question 56: You are designing a star schema for a dataset that contains ...
- Question 57: You plan to deploy an app that includes an Azure SQL databas...
- Question 58: You have an Azure subscription. Vou need to deploy two insta...
- Question 59: You have an Azure subscription that contains an Azure SQL da...
- Question 60: Task 4 You need to enable change data capture (CDC) for db1....
- Question 61: You have an Azure virtual machine named VM1 on a virtual net...
- Question 62: Your on-premises network contains a Microsoft SQL Server 201...
- Question 63: You have an Azure SQL database named DB1. You need to ensure...
- Question 64: You have a Microsoft SQL Server 2019 database named DB1 and ...
- Question 65: You have an instance of SQL Server on Azure Virtual Machine ...
- Question 66: You have a SQL pool in Azure Synapse that contains a table n...
- Question 67: You have a resource group named App1Dev that contains an Azu...
- Question 68: You manage 100 Azure SQL managed instances located across 10...
- Question 69: You have an Azure Databricks workspace named workspace1 in t...
- Question 70: You have an on-premises Microsoft SQL Server 2016 instance t...
- Question 71: You have a SQL Server on Azure Virtual Machines instance tha...
- Question 72: You have an Azure subscription that contains 20 Azure SQL da...
- Question 73: You manage an enterprise data warehouse in Azure Synapse Ana...
- Question 74: You have a data warehouse in Azure Synapse Analytics. You ne...
- Question 75: You need to recommend the appropriate purchasing model and d...
- Question 76: You create five Azure SQL Database instances on the same log...
- Question 77: Note: This question is part of a series of questions that pr...
- Question 78: You have an Azure SQL managed instance named SQL1 and two Az...
- Question 79: You have an Azure subscription that is linked to a hybrid Az...
- Question 80: You have SQL Server on an Azure virtual machine that contain...
- Question 81: You have an Azure SQL database named db1 on a server named s...
- Question 82: You are designing an enterprise data warehouse in Azure Syna...
- Question 83: You have an Azure SQL managed instance. You need to restore ...
- Question 84: You have a 50-TB Microsoft SQL Server database named DB1. Yo...
- Question 85: You have an Azure subscription that contains the following r...
- Question 86: Your on-premises network contains a server that hosts a 60-T...
- Question 87: Note: This question is part of a series of questions that pr...
- Question 88: You are evaluating the business goals. Which feature should ...
- Question 89: You need to implement the surrogate key for the retail store...
- Question 90: You have an Azure AD tenant and a logical Microsoft SQL serv...
- Question 91: Task 2 You need to configure your user account as the Azure ...
- Question 92: You have an Azure subscription. You need to deploy a logical...
- Question 93: You Save an Azure SCX database named DB1. You need to query ...
- Question 94: You have an on-premises Microsoft SQL server that uses the F...
- Question 95: You have an Azure SQL database that contains a table named E...
- Question 96: You need to trigger an Azure Data Factory pipeline when a fi...
- Question 97: You have four Azure subscriptions. Each subscription contain...
- Question 98: You have an Azure subscription that contains the resources s...
- Question 99: You are planning a solution that will use Azure SQL Database...
- Question 100: You have an on-premises datacenter that contains a 14-TB Mic...
- Question 101: You have the following Azure Data Factory pipelines: Ingest ...
- Question 102: You have an on-premises Microsoft SQL Server 2016 server nam...
- Question 103: You need to provide an implementation plan to configure data...
- Question 104: You have an Azure SQL database named D61. You need to identi...
- Question 105: You have SQL Server on an Azure virtual machine that contain...
- Question 106: You have an Azure SQL Database managed instance named SQLMI1...
- Question 107: You have SQL Server on an Azure virtual machine. You review ...
- Question 108: You have an Azure virtual machine named VM1 that runs Window...
- Question 109: You have an Azure SQL Database server named sqlsrv1 that hos...
- Question 110: You have an Azure SQL database named DB1. You have a table n...
- Question 111: You have an Azure subscription that contains an Azure SQL da...
- Question 112: You have an on-premises Microsoft SQL Server 2019 instance t...
- Question 113: You have a single availability set that contains two SQL Ser...
- Question 114: You have an Azure subscription. You need to deploy an Azure ...
- Question 115: You have an Azure Data Factory instance named ADF1 and two A...
- Question 116: You have an Azure SQL database named DB1 that contains a tab...
- Question 117: A data engineer creates a table to store employee informatio...
- Question 118: You have an Azure SQL database named db1 on a server named s...
- Question 119: You have an Azure Data Factory pipeline that is triggered ho...
- Question 120: You are provisioning an Azure SQL database in the Azure port...
- Question 121: You plan to migrate on-premises Microsoft SQL Server databas...
- Question 122: You have an Azure SQL database named DB1. DB1 has a table na...
- Question 123: You have a SQL Server on Azure Virtual Machines instance nam...
- Question 124: Note: This question is part of a series of questions that pr...
- Question 125: You plan to deploy two instances of SQL Server on Azure virt...
- Question 126: You have an Azure SQL database named DB1 in the General Purp...
- Question 127: You have an Azure Active Directory (Azure AD) tenant named c...
