Home » Microsoft » 70-537 » Which three types of objects should you delete before you run the deployment script?
You have an Azure Stack integrated system that has a SQL Server resource provider.
You need to remove the resource provider.
Which three types of objects should you delete before you run the deployment script? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
A. user databases
B. subscriptions
C. storage accounts
D. hosting servers
E. plans
Correct Answer: ADE
Explanation/Reference:
To remove the SQL resource provider, it is essential to first remove any dependencies:
1.Ensure that you have the original deployment package that you downloaded for this version of the SQL resource provider adapter.
2.All user databases must be deleted from the resource provider. (Deleting the user databases doesn’t delete the data.) This task should be performed by theusers themselves.
3.The administrator must delete the hosting servers from the SQL resource provider adapter.
4.The administrator must delete any plans that reference the SQL resource provider adapter.
5.The administrator must delete any SKUs and quotas that are associated with the SQL resource provider adapter.
6.Rerun the deployment script with the following elements:
The -Uninstall parameter
The Azure Resource Manager endpoints
The DirectoryTenantID
The credentials for the service administrator account
References: https://docs.microsoft.com/en-us/azure/azure-stack/azure-stack-sql-resource-provider-remove
