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.

On Server1. set the AllowDownloadedDobsTonatehProxyName registry entry to 1.

On Server2. set the AllowDownloadedJobsToNatchProxyName registry entry to 1.

On Server2, grant the contoso\sqlproxy account the Impersonate a client after authentication user right.

On Server2, grant the contoso\sqlproxy account the Access this computer from the network user right.

On Server2. create a proxy account.

On Server1. set the AllowDownloadedDobsTonatehProxyName registry entry to 1.

On Server2. set the AllowDownloadedJobsToNatchProxyName registry entry to 1.

You have an Azure virtual machine named Server1 that runs Windows Server 2022. Server! contains an instance of Microsoft SQL Server 2022 named SQL1 and a database named DB1.You create a master key in the master database of SQL1.You need to create an encrypted backup of DB1.What should you do?

Create a certificate in the master database of SQLl.

Enable visualization-based security (VBS) on Server1.

Create a certificate in the master database of SQLl.

You have an Azure subscription that contains three instances of SQL Server on Azure Virtual Machines.You plan to implement a disaster recovery solution.You need to be able to perform disaster recovery drills regularly. The solution must meet the following requirements:* Minimize administrative effort for the recovery drills.* Isolate the recovery environment from the production environment.What should you use?

native Microsoft SQL Server backup

You have an Azure subscription that contains a SQL Server on Azure Virtual Machines instance named SQLVM1. SQLVM1 has the following configurations:* Automated patching is enabled.* The SQL Server laaS Agent extension is installed.* The Microsoft SQL Server instance on SQLVM1 is managed by using the Azuie portal.You need to automate the deployment of cumulative updates to SQLVM1 by using Azure Update Manager. The solution must ensure that the SQL Server instance on SQLVM1 can be managed by using the Azure portal.What should you do first on SQLVM1?

Uninstall the SQL Server laaS Agent extension.

Install the Azure Monitor Agent.

Uninstall the SQL Server laaS Agent extension.

Install the Log Analytics agent.

Set Automated patching to Disable

You have an Azure subscription that contains an Azure SQL database named DB1.You need to host elastic jobs by using DB1. DB1 will also be configured as a job target. The solution must support the use of location-based Conditional Access policies.What should the elastic jobs use to access DB1?

a system-assigned managed identity

a user-assigned managed identity

Microsoft DP-300 Practice Test 9 - Free Online Exam Prep & Questions

Task 12

You need to configure high availability for dbl. The solution must tolerate the loss of an Azure datacenter without data loss or the need to modify application connection strings.

Become a Premium Member for full access

Unlock Premium Member

Microsoft DP-300 Practice Test 9

Question

Microsoft DP-300 Practice Tests

Practice Tests