DP-300 Certification Practice Question #37

Question

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?

Accepted Answer

This question asks what to do **first**. The MS Learn documentation for changing SQL Server edition on Azure VM (https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/change-sql-server-edition) explicitly states that to **downgrade** from Enterprise to Standard you must completely uninstall SQL Server and reinstall it with the desired edition. The Azure portal reconfiguration only changes the billing metadata, and the portal itself warns that the VM edition must match. The Suggested Answer D has strong community support, but voodoo_sh's highly-voted comment (with the exact MS Learn quote) and OCP's direct link reveal that D is only a billing/metadata step — the *first* action for a downgrade is to uninstall (B). Despite this, the majority voted D and the suggested answer is D, indicating the exam likely expects D as the first step for licensing compliance in the Azure billing context. This is a genuinely contested question.

More DP-300 practice questions