QuestionQ88

VerifiedPlan and configure a high availability and disaster recovery (HA/DR) environment

You have an Azure subscription.

You need to deploy an Azure SQL managed instance by using an Azure Resource Manager (ARM) template. The solution must meet these requirements:

  • The SQL managed instance must receive a unique identity.
  • The SQL managed instance must remain available if an Azure datacenter has an outage.

Complete the template by dragging the appropriate values to the targets. A value may be used once, more than once, or not at all.

Drag & Drop
{
  "type": "Microsoft.Sql/managedInstances",
  "identity": {
    "type": 
  },
  "dependsOn": [
    "[parameters('virtualNetworkName')]"
  ],
  "properties": {
    "administratorLogin": "[parameters('administratorLogin')]",
    "administratorLoginPassword": "[parameters('administratorLoginPassword')]",
    "subnetId": "[resourceId('Microsoft.Network/virtualNetworks/subnets', parameters('virtualNetworkName'), parameters('subnetName'))]",
    "storageSizeInGB": 8192,
    "vCores": 80,
    "licenseType": "BasePrice",
    : "True"
  }
}
Explanation

A system-assigned managed identity is automatically created and assigned to the managed-instance resource, giving that resource its own identity. The zoneRedundant managed-instance property enables multi-availability-zone deployment, which provides resiliency against a datacenter outage.

Learn more

Community Discussion

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