QUESTION: 215 Exam Topic: Perform Automation of Tasks Questions

DRAG DROP (Drag and Drop is not supported)
You have SQL Server on an Azure virtual machine named SQL1. SQL1 has an agent job to back up all databases.

You add a user named dbadmin1 as a SQL Server Agent operator. You need to ensure that dbadmin1 receives an email alert if a job fails.

Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Select and Place:

See Explanation section for answer.

Answer(s): A

Explanation:

Step 1: Enable the email settings for the SQL Server Agent.
To send a notification in response to an alert, you must first configure SQL Server Agent to send mail. Step 2: Create a job alert
Step 3: Create a job notification Example:
-- adds an e-mail notification for the specified alert (Test Alert)
-- This example assumes that Test Alert already exists
-- and that François Ajenstat is a valid operator name. USE msdb ;
GO

EXEC dbo.sp_add_notification @alert_name = N'Test Alert', @operator_name = N'François Ajenstat', @notification_method = 1 ;
GO

Reference:

https://docs.microsoft.com/en-us/sql/ssms/agent/notify-an-operator-of-job-status https://docs.microsoft.com/en-us/sql/ssms/agent/assign-alerts-to-an-operator

Reveal Solution Next Question

QUESTION: 216 Exam Topic: Perform Automation of Tasks Questions

DRAG DROP (Drag and Drop is not supported)
You need to apply 20 built-in Azure Policy definitions to all new and existing Azure SQL Database deployments in an Azure subscription. The solution must minimize administrative effort.

Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Select and Place:

See Explanation section for answer.

Answer(s): A

Explanation:

Step 1: Create an Azure Policy Initiative
The first step in enforcing compliance with Azure Policy is to assign a policy definition. A policy definition defines under what condition a policy is enforced and what effect to take.

With an initiative definition, you can group several policy definitions to achieve one overarching goal. An initiative evaluates resources within scope of the assignment for compliance to the included policies.

Step 2: Create an Azure Policy Initiative assignment
Assign the initiative definition you created in the previous step.

Step 3: Run Azure Policy remediation tasks
To apply the Policy Initiative to the existing SQL databases.

Reference:

https://docs.microsoft.com/en-us/azure/governance/policy/tutorials/create-and-manage

Reveal Solution Next Question

QUESTION: 217 Exam Topic: Perform Automation of Tasks Questions

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?

From SQL Server Configuration Manager (SSMS), enable SQL Server Agent
From SQL Server Management Studio (SSMS), run sp_set_sqlagent_properties
From SQL Server Management Studio (SSMS), create a Database Mail profile
From the Azure portal, create an Azure Monitor action group that has an Email/SMS/Push/Voice action

Answer(s): C

Explanation:

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:
1. In Object Explorer, expand a SQL Server instance.
2. Right-click SQL Server Agent, and then click Properties.
3. Click Alert System.
4. Select Enable Mail Profile.
5. In the Mail system list, select Database Mail.
6. In the Mail profile list, select a mail profile for Database Mail.
7. 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

Reveal Solution Next Question

QUESTION: 218 Exam Topic: Perform Automation of Tasks Questions

You need to trigger an Azure Data Factory pipeline when a file arrives in an Azure Data Lake Storage Gen2 container.

Which resource provider should you enable?

Microsoft.EventHub
Microsoft.EventGrid
Microsoft.Sql
Microsoft.Automation

Answer(s): B

Explanation:

Event-driven architecture (EDA) is a common data integration pattern that involves production, detection, consumption, and reaction to events. Data integration scenarios often require Data Factory customers to trigger pipelines based on events happening in storage account, such as the arrival or deletion of a file in Azure Blob Storage account. Data Factory natively integrates with Azure Event Grid, which lets you trigger pipelines on such events.

Reference:

https://docs.microsoft.com/en-us/azure/data-factory/how-to-create-event-trigger

Reveal Solution Next Question

Free DP-300 Exam Braindumps (page: 18)

QUESTION: 215 Exam Topic: Perform Automation of Tasks Questions

Explanation:

Reference:

QUESTION: 216 Exam Topic: Perform Automation of Tasks Questions

Explanation:

Reference:

QUESTION: 217 Exam Topic: Perform Automation of Tasks Questions

Explanation:

Reference:

QUESTION: 218 Exam Topic: Perform Automation of Tasks Questions

Explanation:

Reference: