Exam DP-300 topic 1 question 48 discussion

Actual exam question from Microsoft's DP-300

Question #: 48
Topic #: 1

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?

A. From the SQL Server Installation Center on SQLVM1, run the Edition Upgrade wizard.
B. From SQLVM1, uninstall the SQL Server instance.
C. From the SQL Server Installation Center on SQLVM1, run the Repair wizard.
D. From the Azure portal, reconfigure SQLVM1.

Show Suggested Answer

Suggested Answer: B 🗳️

by U_C at April 4, 2023, 1:50 a.m.

Comments

Submit Cancel

U_C

Highly Voted 1 year, 8 months ago

The answer looks right. No, you cannot use the Edition Upgrade wizard to change from the Enterprise edition to the Standard edition of SQL Server. The Edition Upgrade wizard is used to upgrade to a higher edition of SQL Server, not to downgrade to a lower edition. In this case, since you want to change from the Enterprise edition (a higher edition) to the Standard edition (a lower edition), you need to uninstall the Enterprise edition of SQL Server from the virtual machine and then install the Standard edition.

upvoted 10 times

bingomutant

2 months, 1 week ago

good call , you cannot downgrade using edition upgrade wizard to must uninstall

upvoted 1 times

...

OCP

Most Recent 1 year, 5 months ago

B is correct https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/change-sql-server-edition?view=azuresql&tabs=azure-portal

upvoted 1 times

...