Exam DP-300 topic 1 question 31 discussion

Actual exam question from Microsoft's DP-300

Question #: 31
Topic #: 1

HOTSPOT -
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 complete the ARM template? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Show Suggested Answer

Suggested Answer:

Box 1: Microsoft.Sql/managedInstances
The Managed Instance depends on the Virtual Network.
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/create-template-quickstart?tabs=azure-powershell

by Aggie0702 at Sept. 16, 2021, 5:50 a.m.

Comments

Submit Cancel

polinoma

Highly Voted 9 months ago

The answer is correct. { "type": "Microsoft.Sql/managedInstances", "apiVersion": "2020-02-02-preview", "name": "[parameters('managedInstanceName')]", "location": "[parameters('location')]", "dependsOn": [ "[resourceId('Microsoft.Network/virtualNetworks', parameters('virtualNetworkName'))]" ] }

upvoted 6 times

...

reachmymind

Most Recent 9 months ago

Box 1: Microsoft.Sql/managedInstances Box 2: "[variables('networkSecurityGroupName')], Box 1 is Microsoft.Sql/managedInstances because there is a need to support cross database queries Bix 2 has two options based on what follows: "dependsOn": [ "[resourceId('Microsoft.Network/networkSecurityGroups', variables('networkSecurityGroupName'))]", "[resourceId('Microsoft.Network/routeTables', variables('routeTableName'))]"

upvoted 2 times

reachmymind

9 months ago

I retract the statement and have a correction : Box 2: parameters('virtualNetworkName') "dependsOn": [ "[resourceId('Microsoft.Network/virtualNetworks', parameters('virtualNetworkName'))]" The key is parameters vs variables ...

upvoted 8 times

...