Administering Relational Databases on Microsoft Azure — Question 32

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?

Answer options

• 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.

Correct answer: D

Explanation

The correct answer is D because reconfiguring the SQLVM1 instance through the Azure portal is necessary to comply with licensing when switching editions. Options A, B, and C are not valid first steps in changing the SQL Server edition while ensuring licensing compliance.