Home / Microsoft / DP-300

Microsoft DP-300 Practice Test - Questions Answers, Page 25

Question list

List of questions

Question 241

(0)

You have an Azure subscription that contains a SQL Server on Azure Virtual Machines instance named SQLVMI. SQLVMI hosts a database named OBI. You need to retrieve query plans from the Query Store on

Question 242

(0)

DRAG DROP You have a burstable Azure virtual machine named VMI that hosts an instance of Microsoft SQL Server. You need to attach an Azure ultra disk to VMI. The solution must minimize downtime on

Question 243

(0)

DRAG DROP You have an Azure subscription. You need to deploy an Azure SQL managed instance by using an Azure Resource Manager (ARM) template. The solution must meet the following requirements: Th

Question 244

(0)

HOTSPOT You have an Azure SQL database. You need to identify whether a delayed query execution is associated to a RESOURCE wait. How should you complete the Transact –SQL statement? To answer, se

Question 245

(0)

You have an Azure subscription that contains two Azure SQL managed instances named SQLMI1 and SQLMI2 . SQLM2 contains a database named DB1 and a user named User1. User1 drops DB1. You need to perfo

Question 246

(0)

You have an Azure subscription that contain an Azure SQL managed instance named SQLMI1 and a Log Analytics workspace named Workspace1. You need to collect performance metrics for SQLMI1 and stream t

Question 247

(0)

DRAG DROP You create a new Azure SQL managed instance named SQL1 and enable Database Mail extended stored procedures. You need to ensure that SOL Server Agent jobs running on SQL 1 can notify admin

Question 248

(0)

You have An Azure SQL managed instance. You need to configure the SQL Server Agent service to email job notifications. Which statement should you execute?

Question 249

(0)

HOTSPOT You have an Azure SQL database named D61. You need to identify how much unused space in megabytes was allocated to DB1. How should you complete the Transact-SQL query? To answer select th

Question 250

(0)

HOTSPOT You configure backup for an Azure SQL database as shown in the following exhibit. Use the drop-down menus to select the answer choice the completes each statement based on the informati

Related questions

Task 5 You need to configure a disaster recovery solution for db1. When a failover occurs, the connection strings to the database must remain the same. The secondary server must be in the West US 3 Azure region.

Task 10 You need to protect all the databases on sql37006S95 from SQL injection attacks.

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 have an Azure subscription. You create a logical SQL server that hosts four databases Each database will be used by a separate customer. You need to ensure that each customer can access only its own database. The solution must minimize administrative effort Which two actions should you perform? Each correct answer presents part of the solution NOTE: Each correct selection is worth one point.

HOTSPOT You have an Azure SQL database named DB1 that contains two tables named Table1 and Table2. Both tables contain a column named a Column1. Column1 is used for joins by an application named App1. You need to protect the contents of Column1 at rest, in transit, and in use. How should you protect the contents of Column1? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

DRAG DROP You have an Azure SQL database that contains a table named Employees. Employees contains a column named Salary. You need to encrypt the Salary column. The solution must prevent database administrators from reading the data in the Salary column and must provide the most secure encryption. 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.

You have SQL Server on Azure virtual machines in an availability group. You have a database named DB1 that is NOT in the availability group. You create a full database backup of DB1. You need to add DB1 to the availability group. Which restore option should you use on the secondary replica?

HOTSPOT You have an Azure SQL database that contains a table named Customer. Customer has the columns shown in the following table. You plan to implement a dynamic data mask for the Customer_Phone column. The mask must meet the following requirements: ▪ The first six numerals of each customer’s phone number must be masked. ▪ The first six numerals of each customer’s phone number must be masked. ▪ The last four digits of each customer’s phone number must be visible. Hyphens must be preserved and displayed. How should you configure the dynamic data mask? To answer, select the appropriate options in the answer area.

You have a database on a SQL Server on Azure Virtual Machines instance. The current state of Query Store for the database is shown in the following exhibit.

Which counter should you monitor for real-time processing to meet the technical requirements?

Question 241

You have an Azure subscription that contains a SQL Server on Azure Virtual Machines instance named SQLVMI. SQLVMI hosts a database named OBI. You need to retrieve query plans from the Query Store on DBI.

What should you do first?

On SQLVM1, install the SQL Server laaS Agent extension.

From Microsoft SQL Server Management Studio, modify the properties of the SQL Server instance.

From Microsoft SQL Server Management Studio, modify the properties of DB 1.

On SQLVM1, install the Azure Monitor agent for Windows.

Show Answer Comment (0)

Question 242

DRAG DROP

You have a burstable Azure virtual machine named VMI that hosts an instance of Microsoft SQL Server. You need to attach an Azure ultra disk to VMI. The solution must minimize downtime on VMI.

In which order should you perform the actions? To answer, move all actions from the list of actions to the answer area and arrange them in the correct order.

Show Answer Comment (0)

Question 243

DRAG DROP

You have an Azure subscription.

You need to deploy an Azure SQL managed instance by using an Azure Resource Manager (ARM) template. The solution must meet the following requirements:

The SQL managed instance must be assigned a unique identity.

The SQL managed instance must be available in the event of an Azure datacenter outage.

How should you complete the template? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point.

Show Answer Comment (0)

Question 244

HOTSPOT

You have an Azure SQL database.

You need to identify whether a delayed query execution is associated to a RESOURCE wait.

How should you complete the Transact –SQL statement? To answer, select the appropriate option in

the answer area.

NOTE: Each correct selection is worth one point.

Show Answer Comment (0)

Question 245

You have an Azure subscription that contains two Azure SQL managed instances named SQLMI1 and SQLMI2 . SQLM2 contains a database named DB1 and a user named User1. User1 drops DB1.

You need to perform a point-in-time restore of DB1 to SQLMI2.

Azure CLI

Transact-SQL

The Azure portal

Azure PowerShell

Show Answer Comment (0)

Question 246

You have an Azure subscription that contain an Azure SQL managed instance named SQLMI1 and a Log Analytics workspace named Workspace1. You need to collect performance metrics for SQLMI1 and stream the metrics to Workspace1.

Create the private endpoint connection on SQLMI1.

Configure Azure SQL Analytics to use Workspace1.

Modify the Computer + storage settings for SQLMI1.

Modify the diagnostic settings for SQLMI1.

Show Answer Comment (0)

Question 247

DRAG DROP

You create a new Azure SQL managed instance named SQL1 and enable Database Mail extended stored procedures. You need to ensure that SOL Server Agent jobs running on SQL 1 can notify administrators when a failure occurs. 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.