Provisioning SQL Databases — Question 39

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets stated goals.
Your company plans to use Microsoft Azure Resource Manager templates for all future deployments of SQL Server on Azure virtual machines.
You need to create the templates.
Solution: You create the desired SQL Server configuration in an Azure Resource Group, then export the Resource Group template and save it to the Templates
Library.
Does the solution meet the goal?

Answer options

• A. Yes
• B. No

Correct answer: B

Explanation

The solution does not meet the goal because simply exporting the Resource Group template does not ensure that it will function correctly for future deployments of SQL Server on Azure virtual machines. The template needs to be thoroughly validated and should include all necessary parameters and configurations specific to SQL Server deployments, which this solution does not guarantee.