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

You have an Azure subscription that contains 20 Azure SQL databases.

You create a Transact-SQL statement to perform index maintenance on a database.

You need to schedule the statement to run once daily against each database by using Transact-SQL commands.

What should you use to schedule the statement?

You have two Azure virtual machines named Server 1 and Server2 that run Windows Server 2022 and are joined to an Active Directory Domain Services (AD DS) domain named contoso.com.

Both virtual machines have a default instance of Microsoft SQL Server 2019 installed. Server1 is configured as a master server, and Server2 is configured as a target server.

On Server1, you create a proxy account named contoso\sqlproxy.

You need to ensure that the SQL Server Agent job steps can be downloaded from Server1 and run on Server2.

Which two actions should you perform? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

HOTSPOT

You plan to deploy an Always On failover cluster instance (FCI) on Azure virtual machines.

You need to provision an Azure Storage account to host a cloud witness for the deployment.

How should you configure the storage account? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You have an Azure subscription that contains an Azure SQL database named db1.

You need to implement SQL insights for db1.

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

NOTE: Each correct selection is worth one point

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 laaS Agent extension (SqllaasExtension). 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?

DRAG DROP

You have an Azure subscription that contains an instance of SQL Server on Azure Virtual Machines named SQLVM1 and a virtual machine named Server! that runs Windows Server. SQLVM1 and Serverl are joined to an Active Directory Domain Services (AD DS) domain. Serverl hosts a file share named Sharel.

You need to ensure that a SQL Server Agent job step on SQLVM1 can access the files in Share1. The solution must use the principle of least privilege.

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.

HOTSPOT

You have an Azure virtual machine named Server1 that has Microsoft SQL Server installed. Server1 contains a database named DB1.

You have a logical SQL server named ASVR1 that contains an Azure SQL database named ADB1.

You plan to use SQL Data Sync to migrate DB1 from Server1 to ASVR1.

You need to prepare the environment for the migration. The solution must ensure that the connection from Server1 to ADB1 does NOT use a public endpoint.

What should you do? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You have an Azure virtual machine named VM1 that runs Windows Server 2022 and hosts a Microsoft SQL Server 2019 instance named SQL1.

You need to configure SQL1 to use mixed mode authentication.

Which procedure should you run?

You have an Azure subscription.

You need to deploy a new Azure SQL database by using Azure Command-Line Interface (CLI).

Which three parameters are required?

A)

B)

C)

D)