Microsoft DP-300 Administering Microsoft Azure SQL Solutions Exam Practice Test

Page: 1 / 14
Total 337 questions
Question 1

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?



Answer : A


Question 2

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



Answer : B, D


Question 3

You have an Azure subscription that contains an instance of SQL Server on an Azure virtual machine named VM1 and a Microsoft Entra Domain Services domain that contains two users named User1 and User2.

On the default instance of SQL Server on VM1, you create a credential named Credentiall for User1.

You need to ensure that User2 can create a SQL Server Agent proxy that will use Credential1. The solution must use the principle of least privilege.

Which role should you assign to User2?



Answer : A


Question 4

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?



Answer : B


Question 5

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?



Answer : D


Question 6

You have a Microsoft SQL Server 2019 database named DB1 and an Azure SQL managed instance named SQLMI1. You need to move a SQL Server Agent job from DB1 to SQLMI1. Which job attribute is unsupported in SQLMI1?



Answer : D


Question 7

You need to recommend a disaster recovery solution for an on-premises Microsoft SQL Server database. The solution must meet the following requirements:

* Support real-time data replication to a different geographic region.

* Use Azure as a disaster recovery target.

* Minimize costs and administrative effort.

What should you include in the recommendation?



Answer : D


Page:    1 / 14   
Total 337 questions