Summer Special - Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: top65certs

Microsoft DP-300 Questions Answers

Page: 6 / 13
Total 311 questions

Administering Microsoft Azure SQL Solutions Questions and Answers

Question 21

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You have SQL Server 2019 on an Azure virtual machine.

You are troubleshooting performance issues for a query in a SQL Server instance.

To gather more information, you query sys.dm_exec_requests and discover that the wait type is PAGELATCH_UP and the wait_resource is 2:3:905856.

You need to improve system performance.

Solution: You change the data file for the master database to autogrow by 10 percent.

Does this meet the goal?

Options:

A.

Yes

B.

No

Question 22

You have an Azure virtual machine named VM1 on a virtual network named VNet1. Outbound traffic from VM1

to the internet is blocked.

You have an Azure SQL database named SqlDb1 on a logical server named SqlSrv1.

You need to implement connectivity between VM1 and SqlDb1 to meet the following requirements:

  • Ensure that VM1 cannot connect to any Azure SQL Server other than SqlSrv1.
  • Restrict network connectivity to SqlSrv1.

What should you create on VNet1?

Options:

A.

a VPN gateway

B.

a service endpoint

C.

a private endpoint

D.

an ExpressRoute gateway

Question 23

You have an instance of SQL Server on Azure Virtual Machines named SQL1.

SQL1 contains an Extended Events session named session! that captures Microsoft SQL Server events.

You need to correlate the session events with events captured by Event Tracing for Windows (ETW).

What should you do for session1?

Options:

A.

Modify the Set Session Event Filters settings.

B.

Add a target.

C.

Add an action.

D.

Modify the Specify Session Data Storage settings.

Question 24

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

You need to create a read-only replica of DB1 and configure the App1 instances to use the replica.

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

NOTE: Each correct selection is worth one point.

Options:

Page: 6 / 13
Total 311 questions