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

Page: 1 / 14
Total 311 questions
Question 1

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.



Answer : D, E


Question 2

You have an Azure subscription.

You need to deploy an Instance of SQL Server on Azure Virtual Machines. The solution must meet the following 'requirements:

* Custom performance configuration. such as lCPS. capacity, and throughout, must be supported.

* Costs must be minimized

Which type of disk should you include in the solution?



Answer : A


Question 3

You have an Azure subscription that contains the resources shown in the following table.

You plan louse SQLDB11 as an elastic job database to run jobs on SQlDb11 andSOtDB22. What is the minimum number of database scoped credentials required tor the elastic jobs?



Answer : A


Question 4

You have an Azure SQL database named SOL1.

You need to implement a disaster recovery solution for SQL1. The solution must minimize the following:

* The recovery point objective JRPO)

* The recovery time objective (RTO)

* Administrative effort

What should you include in the solution?



Answer : A


Question 5

You have SQL Server 2019 or an Azure virtual machine that runs Windows Server 2019. The virtual machine has 4 vCPUs and 28 GB of memory.

Vou scale up the virtual machine to 8 vCPUs and 64 GB of memory.

You need to reduce tempdb contention without regatively affecting server performance.

What is the number of secondary data files that you should configure for tempdb?



Answer : C


Question 6

You have a single availability set that contains two SQL Server on Azure Virtual Machines instances.

The instances were deployed by using an Azure Marketplace SQL Server 2019 Enterprise image that has the latest cumulative updates applied. The instances are configured as the nodes of a failover cluster instance (FCI) named FCI1.

You need to ensure that client applications can connect to FCI1. The solution must meet the following requirements:

* Provide an availability SLA

* Minimize costs.

What should you create?



Answer : C


Question 7

You have an Azure SQL database named DB1. DB1 has a table named Table1 that contains the following columns.

You plan to enable Always Encrypted for Table1.

Which two columns support encryption? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point



Answer : A, D


Page:    1 / 14   
Total 311 questions