DP-300 Practice Questions — Page 20

Question 191

You have SQL Server on an Azure virtual machine.

You need to use Policy-Based Management in Microsoft SQL Server to identify stored procedures that do not comply with your naming conventions.

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:

Question 192

Open question ↗

You have an Azure SQL managed instance named SQLMI1 that hosts 10 databases.

You need to implement alerts by using Azure Monitor. The solution must meet the following requirements:

✑ Minimize costs.

✑ Aggregate Intelligent Insights telemetry from each database.

What should you do?

A.From the Diagnostic settings of each database, select Send to Log Analytics.
B.From the Diagnostic settings of each database, select Stream to an event hub.
C.From the Diagnostic settings of SQLMI1, select Send to Log Analytics.
D.From the Diagnostic settings of SQLMI1, select Stream to an event hub.

Question 193

Open question ↗

You have an Azure SQL managed instance that hosts multiple databases.

You need to configure alerts for each database based on the diagnostics telemetry of the database.

What should you use?

A.Azure SQL Analytics alerts based on metrics
B.SQL Health Check alerts based on diagnostics logs
C.SQL Health Check alerts based on metrics
D.Azure SQL Analytics alerts based on diagnostics logs ✓

Question 194

Open question ↗

You have four Azure subscriptions. Each subscription contains multiple Azure SQL databases.

You need to update the column and index statistics for the databases.

What should you use?

A.an Azure Automation runbook
B.a SQL Agent job
C.Azure SQL Analytics
D.automatic tuning in Azure SQL Database

Question 195

Open question ↗

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:

Question 196

Open question ↗

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:

Question 197

Open question ↗

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?

A.Microsoft.EventHub
B.Microsoft.EventGrid
C.Microsoft.Sql
D.Microsoft.Automation

Question 198

Open question ↗

You need to deploy an Azure SQL Database elastic pool by using a Bicep template.

How should you complete the template? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Question 199

Open question ↗

You have an Azure AD tenant and a logical Microsoft SQL server named SQL1 that hosts several Azure SQL databases.

You plan to assign Azure AD users permissions to the databases automatically by using Azure Automation.

You need to create the required Automation accounts.

Which two accounts should you create? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

A.From the Azure Active Directory admin center create a service principal.
B.From the Azure Active Directory admin center, create a user-assigned managed identity for SQL1.
C.On SQL1, create a SQL user in the databases.
D.On SQL1, create a SQL login.
E.From the Azure Active Directory admin center, create an external identity.

Question 200

Open question ↗

You have an Azure subscription.

You plan to deploy an instance of SQL Server on Azure Virtual Machines by using an Azure Marketplace image.

You need to register the SQL Server IaaS Agent extension (SqlIaasExtension). The solution must meet the following requirements:

• Install critical updates for SQL Server automatically.

• Minimize performance impact on the virtual machine.

Which management mode should you select?

A.full
B.lightweight
C.NoAgent