ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DP-300 All Questions

View all questions & answers for the DP-300 exam
Go to Exam

Exam DP-300 topic 1 question 48 discussion

Actual exam question from Microsoft's DP-300
Question #: 48
Topic #: 1
[All DP-300 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?

  • 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 Hide Answer
Suggested Answer: B 🗳️
by U_C at April 4, 2023, 1:50 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
U_C
Highly Voted 2 years, 1 month 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
7 months, 1 week ago
good call , you cannot downgrade using edition upgrade wizard to must uninstall
upvoted 1 times
...
...
voodoo_sh
Most Recent 4 months, 4 weeks ago
Selected Answer: B
When trying to change edition on Azure portal for the SQL virtual machine, it says: Note that, before changing the edition type here, you must change the SQL Server edition type on virtual machine manually. The edition type selected here must match the edition on virtual machine. Changes made to the edition type here, are just applicable to the billing rates. Based on this link: https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/change-sql-server-edition?view=azuresql&tabs=azure-portal#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.
upvoted 2 times
...
OCP
1 year, 10 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
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago