Cisco
CompTIA
ISC
EC-Council
EXIN
Fortinet
ITIL
Juniper
Microsoft
VMware
Avaya
SAP
Google
NVIDIA
Salesforce
Amazon
Palo Alto Networks
ISC2
Splunk
ServiceNow
All Vendors
  2. Home
  3. Exams
  4. Microsoft
  5. DP-300

Microsoft DP-300 Exam Questions
Administering Microsoft Azure SQL Solutions (Page 4 )

Updated On: 21-Feb-2026
Page 4 of 85
PDF with 430 Questions

HOTSPOT (Drag and Drop is not supported)

You are provisioning an Azure SQL database in the Azure portal as shown in the following exhibit.



Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.

Note: Each correct selection is worth one point.

Hot Area:

  1. See Explanation section for answer.

Answer(s): A

Explanation:





Box 1: no extra time
Auto Pause is not checked in the exhibit.

Note: If Auto Pause is checked the correct answer is: up to one minute

Box 2: intermittent and unpredictable


Reference:

https://docs.microsoft.com/en-us/azure/azure-sql/database/serverless-tier-overview



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 a specific virtual network.

You need to recommend a solution that meets the requirements.

What should you include in the recommendation?

  1. Azure Private Link
  2. a network security group (NSG)
  3. a database-level firewall
  4. a server-level firewall

Answer(s): A

Explanation:

Private Link allows you to connect to various PaaS services in Azure via a private endpoint.
A private endpoint is a private IP address within a specific VNet and subnet.


Reference:

https://docs.microsoft.com/en-us/azure/azure-sql/database/private-endpoint-overview



You are planning a solution that will use Azure SQL Database. Usage of the solution will peak from October 1 to January 1 each year.

During peak usage, the database will require the following:

24 cores

500 GB of storage

124 GB of memory

More than 50,000 IOPS

During periods of off-peak usage, the service tier of Azure SQL Database will be set to Standard.

Which service tier should you use during peak usage?

  1. Business Critical
  2. Premium
  3. Hyperscale

Answer(s): A


Reference:

https://docs.microsoft.com/en-us/azure/azure-sql/database/resource-limits-vcore-single-databases#business- critical---provisioned-compute---gen4



HOTSPOT (Drag and Drop is not supported)

You have an Azure subscription.

You need to deploy an Azure SQL resource that will support cross database queries by using an Azure Resource Manager (ARM) template.

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

Note: Each correct selection is worth one point.

Hot Area:

  1. See Explanation section for answer.

Answer(s): A

Explanation:





Box 1: Microsoft.Sql/managedInstances
The Managed Instance depends on the Virtual Network.


Reference:

https://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/create-template-quickstart?tabs=azure- powershell



HOTSPOT (Drag and Drop is not supported)

You have the following Azure Resource Manager template.



For each of the following statements, select Yes if the statement is true. Otherwise, select No.

Note: Each correct selection is worth one point.

Hot Area:

  1. See Explanation section for answer.

Answer(s): A

Explanation:


Reference:

https://docs.microsoft.com/en-us/azure/azure-sql/database/purchasing-models https://docs.microsoft.com/en-us/azure/azure-sql/database/single-database-create-arm-template-quickstart






Post your Comments and Discuss Microsoft DP-300 exam dumps with other Community members:

Join the DP-300 Discussion