Question 301 · 354 in bank
DRAG DROP - 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 the following requirements: • The SQL managed instance must be assigned a unique identity. • The SQL managed instance must be available in the event of an Azure datacenter outage. How should you complete the template? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point.
This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.
Show the answer figure
Answer: See figure below
Explanation
1. SQL MI must be assigned a unique identity: system-assigned identities can only be assigned to one resource, so that naturally makes it a unique ID 2. SQL MI must be available if datacenter goes down: datacenter = availability zone So answer should be SystemAssigned, zoneRedundant
Source: Adapted from community discussion — igorclapa
