Hotspot Question You have an Azure subscription. You need to deploy an Azure SQL resource that will support cross database queries by using an Azure Resource Manager (ARM) template. How should you…

Question

Exhibit

Answer Area

• "type":Microsoft.Sql/managedInstances
  Microsoft.Sql/serversMicrosoft.Sql/servers/databasesMicrosoft.Sql/managedInstances
• dependsOn:"[parameters('virtualNetworkName')]"
  "[parameters('targetName')]""[parameters('virtualNetworkName')]""[variables('networkSecurityGroupName')]"

Explanation

This question tests knowledge of ARM template structure for deploying Azure SQL resources that support cross-database queries using Elastic Query, which requires a specific server type and database edition.

Approach. To support cross-database queries in Azure SQL, you must deploy an Azure SQL Database with Elastic Query capability. In the ARM template, the 'kind' property should be set to 'v12.0,user' and the 'sku' name should be set to a tier that supports Elastic Query (Standard or Premium, e.g., 'S3'). The resource type must be 'Microsoft.Sql/servers/databases', and the 'elasticPoolId' or appropriate edition must be configured. Specifically, the template needs 'type': 'Microsoft.Sql/servers/databases' with edition set to 'Standard' or higher (not Basic, as Basic does not support Elastic Query), and the server must be SQL Server version 12 (v12). The key fields typically tested are: the resource type (Microsoft.Sql/servers/databases), the kind (v12.0,user), and the SKU/edition (Standard or Premium to enable cross-database/elastic query support).

Concept tested. ARM template authoring for Azure SQL Database with Elastic Query support for cross-database queries, including correct resource type, API version, SKU/edition selection, and server version requirements.

Reference. https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-query-overview

No community discussion yet for this question.