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 13 )

Updated On: 17-Feb-2026
Page 13 of 85
PDF with 430 Questions

You have an Azure subscription.

You plan to provision a single Azure SQL database.

You need to ensure that the database supports the autoscaling of compute resources.

Which service tier should you choose?

  1. Premium
  2. General Purpose
  3. Business Critical
  4. Standard

Answer(s): B

Explanation:

The General Purpose service tier in Azure SQL Database is designed to provide balanced and scalable compute and storage options. It supports the vCore-based purchasing model, which allows for autoscaling of compute resources. This model enables you to dynamically adjust the number of vCores allocated to your database, thereby allowing for autoscaling based on workload demands.



HOTSPOT (Drag and Drop is not supported)

You plan to deploy an instance of SQL Server on Linux Azure Virtual Machines. The instance will run Microsoft SQL Server 2022 and use the SQL Server IaaS Agent extension for Linux.

Which Linux operating system should you deploy, and which benefit will the SQL Server IaaS Agent extension provide? 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:






While SQL Server is supported on multiple Linux distributions, RHEL is a commonly recommended choice for enterprise environments due to its stability, support, and compatibility with SQL Server.

The SQL Server IaaS Agent extension for Linux provides the capability to register a SQL Server virtual machine with Azure, allowing you to manage it as a first-class resource in Azure. This registration enables integration with Azure services and management features, such as automated backup and patching, but the primary benefit of the extension itself is the registration capability.



DRAG DROP (Drag and Drop is not supported)

You have a burstable Azure virtual machine named VM1 that hosts an instance of Microsoft SQL Server.

You need to attach an Azure ultra disk to VM1. The solution must minimize downtime on VM1.

In which order should you perform the actions? To answer, move all actions from the list of actions to the answer area and arrange them in the correct order.

Select and Place:

  1. See Explanation section for answer.

Answer(s): A

Explanation:






Stop and deallocate VM1: This step is necessary because you need to modify the VM's configuration, which requires it to be in a stopped and deallocated state.
Resize VM1: If resizing is required to support ultra disks, this should be done while the VM is deallocated. Set Enable Ultra disk compatibility to Yes: This setting must be enabled to allow the VM to use ultra disks. Attach the ultra disk: With the VM deallocated and configured for ultra disk compatibility, you can now attach the ultra disk.
Start VM1: Finally, start the VM to bring it back online with the ultra disk attached.

The VM must be stopped and deallocated to change its configuration settings, such as enabling ultra disk compatibility and resizing if necessary. Once these changes are made, you can attach the ultra disk and then start the VM to minimize downtime.



HOTSPOT (Drag and Drop is not supported)

You have an Azure subscription.

You need to deploy an Azure SQL database. The solution must meet the following requirements:

Support at least 36 cores.

Minimize costs.

How should you complete the PowerShell script? 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: "Gen5"

Box 2: Serverless

Purchasing model and service tier
The following table describes serverless support based on purchasing model, service tiers, and hardware:



The vCore purchasing model compute size is 2 to 128 vCores.

Incorrect:
* Free

* Provisioned

* Standard


Reference:

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



Your on-premises network contains a server that hosts a 60-TB database named DB1. The network has a 10- Mbps internet connection.

You need to migrate DB1 to Azure. The solution must minimize how long it takes to migrate the database.

What should you use?

  1. Data Migration Assistant (DMA)
  2. Azure Migrate
  3. Azure Data Studio
  4. Azure Data Box

Answer(s): D

Explanation:

Correct:
* Azure Data Box
Incorrect:

* Azure Data Studio
* Azure Database Migration Service
* Azure Migrate
* Data Migration Assistant (DMA)
Note:
Microsoft Azure Data Box is a hardware appliance designed to allow customers to import or export large amounts of data -- more than 40TB -- into and out of Azure offline. It is especially helpful when there is zero or limited network connectivity. Microsoft ships customers a proprietary Data Box storage device with a rugged casing to protect and secure data during the transit. A customer may choose Data Box for a one-time or the occasional cloud migration or an initial bulk data transfer followed by periodic transfers.
Considerations for Cloud Migrations Using Azure Data Box
Azure Data Box is a good solution to consider if online data transfer is not possible either because the network bandwidth is limited or because it can take too long.
There are three different types of physical Data Box solutions based on data size:
Data Box: This device has 100TB capacity and uses standard NAS protocols and common copy tools. It features AES 256-bit encryption for safer transit.
Data Box Heavy: This larger device is designed to lift 1PB of data to the cloud.
Data Box Discs: Discs have capacity of 8TB SSD with a USB/SATA interface featuring 128-bit encryption.
Customers can buy in packs of up to five for a total of 40TB.


Reference:

https://www.komprise.com/glossary_terms/azure-data-box/






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

Join the DP-300 Discussion