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

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

You have a SQL Server on Azure Virtual Machines instance named SQLVM1 that was deployed by using an Azure Marketplace SQL Server 2019 Enterprise image.

You need to change the Microsoft SQL Server instance on SQLVM1 to the Standard edition. The solution must ensure licensing compliance.

What should you do first?

  1. From the SQL Server Installation Center on SQLVM1, run the Edition Upgrade wizard.
  2. From SQLVM1, uninstall the SQL Server instance.
  3. From the SQL Server Installation Center on SQLVM1, run the Repair wizard.
  4. From the Azure portal, reconfigure SQLVM1.

Answer(s): B

Explanation:

In-place change of SQL Server edition on Azure VM
The edition of SQL Server is determined by the product key, and is specified during the installation process using the installation media. The edition dictates what features are available in the SQL Server product. You can change the SQL Server edition with the installation media and either downgrade to reduce cost or upgrade to enable more features.
Downgrade an edition
To downgrade the edition of SQL Server, you need to completely uninstall SQL Server, and reinstall it again with the desired edition setup media.
1. Back up all databases, including the system databases.
2. Move system databases (master, model, and msdb) to a new location.
3. Completely uninstall SQL Server and all associated services.
4. Restart the virtual machine.
5. Install SQL Server by using the media with the desired edition of SQL Server.
6. Install the latest service packs and cumulative updates.
7. Replace the new system databases that were created during installation with the system databases that you previously moved to a different location.
8. After the SQL Server edition is downgraded, modify the edition property of the SQL Server virtual machine in the Azure portal. This will update the metadata and billing associated with this VM.


Reference:

https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/change-sql-server-edition



Your on-premises network contains a Microsoft SQL Server 2016 server that hosts a database named db1.

You have an Azure subscription.

You plan to migrate db1 to an Azure SQL managed instance.

You need to create the SQL managed instance. The solution must minimize the disk latency of the instance.

Which service tier should you use?

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

Answer(s): A

Explanation:

Service tier characteristics
SQL Managed Instance has two service tiers: General Purpose and Business Critical.
Storage IO latency (approximate)
General Purpose: 5-10 ms
Business Critical: 1-2 ms
Incorrect:
Not B: The Hyperscale service tier is currently only available for Azure SQL Database, and not Azure SQL Managed Instance.


Reference:

https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/resource-limits https://learn.microsoft.com/en-us/azure/azure-sql/database/service-tier-hyperscale



You have an Azure subscription.

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

Dynamically scale CPU resources.

Ensure that the database can be paused to reduce costs.

What should you use?

  1. the Business Critical service tier
  2. the serverless compute tier
  3. an elastic pool
  4. the General Purpose service tier

Answer(s): B

Explanation:

Serverless is a compute tier for single databases in Azure SQL Database that automatically scales compute based on workload demand and bills for the amount of compute used per second. The serverless compute tier also automatically pauses databases during inactive periods when only storage is billed and automatically resumes databases when activity returns. The serverless compute tier is available in the General Purpose service tier and currently in preview in the Hyperscale service tier.


Reference:

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



HOTSPOT (Drag and Drop is not supported)

You have an Azure subscription.

You need to deploy an Azure SQL managed instance that meets the following requirements:

Optimize latency.

Maximize the memory-to-vCore ratio.

Which service tier and hardware generation should you use? 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: Business Critical
Optimize latency.

Service tier characteristics
SQL Managed Instance has two service tiers: General Purpose and Business Critical.

Storage IO latency (approximate)
General Purpose: 5-10 ms
Business Critical: 1-2 ms

Incorrect:
* Hyperscale: The Hyperscale service tier is currently only available for Azure SQL Database, and not Azure SQL Managed Instance.

Box 2: Memory optimized premium-series
Maximize the memory-to-vCore ratio.

Hardware configurations have different characteristics, as described in the following table:


Reference:

https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/resource-limits https://learn.microsoft.com/en-us/azure/azure-sql/database/service-tier-hyperscale



You have a Microsoft SQL Server 2017 server.

You need to migrate the server to Azure. The solution must meet the following requirements:

Ensure that the latest version of SQL Server is used.

Support the SQL Server Agent service.

Minimize administrative effort.

What should you use?

  1. an Azure SQL Database elastic pool
  2. Azure SQL Database
  3. SQL Server on Azure Virtual Machines
  4. Azure SQL Managed Instance

Answer(s): D






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

Join the DP-300 Discussion