DP-300: Administering Microsoft Azure SQL Solutions

By Microsoft · Question Mode

QuestionQ2

Plan and implement data platform resources

You have an Azure subscription.

You need to deploy an Azure SQL resource that supports cross-database queries by using an Azure Resource Manager (ARM) template. How should you complete the ARM template?

Select
"resources": [
  ...
  "type": "",
  "name": "[parameters('targetName')]",
  "location": "[parameters('location')]",
  "sku": {
    "name": "[parameters('skuName')]"
  },
  ...
  "dependsOn": [
    ""
  ],
  "properties": {
    "administratorLogin": "[parameters('administratorLogin')]",
    "administratorLoginPassword": "[parameters('administratorLoginPassword')]",
    "subnetId": "[resourceId('Microsoft.Network/virtualNetworks/subnets', parameters('virtualNetworkName'),
      parameters('virtualNetworkName'), parameters('subnetName'))]",
    "storageSizeInGB": "[parameters('storageSizeInGB')]", "vCores": "[parameters('vCores')]",
    "licenseType": "[parameters('licenseType')]"
  }
  ...
]
Explanation

Azure SQL Managed Instance supports cross-database queries and is deployed with the Microsoft.Sql/managedInstances resource type. Its required subnet belongs to the virtual network, so the managed-instance resource must wait for the virtual network deployment, represented by [parameters('virtualNetworkName')].

Learn more

Community Discussion

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