DP-300: Administering Microsoft Azure SQL Solutions

By Microsoft · Question Mode

QuestionQ5

Plan and implement data platform resources

You have a SQL Server on Azure Virtual Machines instance named SQLVM1 that was deployed 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 maintain licensing compliance.

What should you do first?

Explanation

Downgrading SQL Server from Enterprise to Standard requires completely uninstalling the existing SQL Server instance and reinstalling it with Standard edition setup media; the Edition Upgrade wizard is not used for downgrades. After the internal edition change, the SQL VM edition metadata must be updated in Azure so that billing matches the installed edition.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!