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

Free Access Microsoft DP-300 New Release

Page: 8 / 13
Total 311 questions

Administering Microsoft Azure SQL Solutions Questions and Answers

Question 29

You have a resource group named App1Dev that contains an Azure SQL Database server named DevServer1. DevServer1 contains an Azure SQL database named DB1. The schema and permissions for DB1 are saved in a Microsoft SQL Server Data Tools (SSDT) database project.

You need to populate a new resource group named App1Test with the DB1 database and an Azure SQL Server named TestServer1. The resources in App1Test must have the same configurations as the resources in App1Dev.

Which four 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.

Options:

Question 30

You deploy a database to an Azure SQL Database managed instance.

You need to prevent read queries from blocking queries that are trying to write to the database.

Which database option should set?

Options:

A.

PARAMETERIZATION to FORCED

B.

PARAMETERIZATION to SIMPLE

C.

Delayed Durability to Forced

D.

READ_COMMITTED_SNAPSHOT to ON

Question 31

You plan to deploy an app that includes an Azure SQL database and an Azure web app. The app has the following requirements:

  • The web app must be hosted on an Azure virtual network.
  • The Azure SQL database must be assigned a private IP address.
  • The Azure SQL database must allow connections only from the virtual network.

You need to recommend a solution that meets the requirements.

What should you include in the recommendation?

Options:

A.

Azure Private Link

B.

a network security group (NSG)

C.

a database-level firewall

D.

a server-level firewall

Question 32

You have an Azure subscription that contains a storage account named databasebackups.

You have an Azure SQL managed instance named DB1.

You need to back up DB1 to databasebackups.

How should you complete the commands? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Options:

Page: 8 / 13
Total 311 questions