You have an Azure SQL managed instance.
You need to enable SQL Agent Job email notifications.
What should you do?

• A.Run the sp_configure command.
• B.Use the Agent XPs option.
• C.Enable the SQL Server Agent.
• D.Run the sp set_agent properties command.

Comment: *

Name: *

Email: *

Verification: *

You have an on-premises app named App1 that stores data in an on-premises Microsoft SQL Server 2016 database named DB1.
You plan to deploy additional instances of App1 to separate Azure regions. Each region will have a separate instance of App1 and DB1. The separate instances of DB1 will sync by using Azure SQL Data Sync.
You need to recommend a database service for the deployment. The solution must minimize administrative effort.
What should you include in the recommendation?

• A.Azure SQL Managed instance
• B.Azure SQL Database single database
• C.Azure Database for PostgreSQL
• D.SQL Server on Azure virtual machines

Comment: *

Name: *

Email: *

Verification: *

You manage an enterprise data warehouse in Azure Synapse Analytics.
Users report slow performance when they run commonly used queries. Users do not report performance changes for infrequently used queries.
You need to monitor resource utilization to determine the source of the performance issues.
Which metric should you monitor?

• A.Local tempdb percentage
• B.DWU percentage
• C.Data Warehouse Units (DWU) used
• D.Cache hit percentage

Comment: *

Name: *

Email: *

Verification: *

HOTSPOT
You have an Azure data factory that has two pipelines named PipelineA and PipelineB.
PipelineA has four activities as shown in the following exhibit.

PipelineB has two activities as shown in the following exhibit.

You create an alert for the data factory that uses Failed pipeline runs metrics for both pipelines and all failure types. The metric has the following settings:
* Operator: Greater than
* Aggregation type: Total
* Threshold value: 2
* Aggregation granularity (Period): 5 minutes
* Frequency of evaluation: Every 5 minutes
Data Factory monitoring records the failures shown in the following table.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:

Correct Answer:

Section: [none]
Explanation:
Box 1: No
Just one failure within the 5-minute interval.
Box 2: No
Just two failures within the 5-minute interval.
Box 3: No
Just two failures within the 5-minute interval.
Reference:
https://docs.microsoft.com/en-us/azure/azure-monitor/alerts/alerts-metric-overview

Comment: *

Name: *

Email: *

Verification: *

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.

Correct Answer:

1 - Enable the email settings for the SQL Server Agent.
2 - Create a job alert
3 - Create a job notification
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

Comment: *

Name: *

Email: *

Verification: *