nerdexam
Microsoft

DP-300 · Question #308

Drag and Drop Question 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…

The correct answer is UserAssigned; zoneRedundant. UserAssigned is correct for the identity type because it assigns a specific, pre-created managed identity to the SQL Managed Instance, giving it a unique, persistent identity that exists independently of the resource lifecycle. zoneRedundant is correct because setting this…

Submitted by carter_n· Mar 6, 2026Deploy and manage Azure compute resources / Implement high availability and disaster recovery for Azure SQL services

Question

Drag and Drop Question 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. Answer:

Exhibit

DP-300 question #308 exhibit

Answer Area

Drag items

dnzOnePartnerstorageAccountTypeUserAssignedzoneRedundant

Correct arrangement

  • UserAssigned
  • zoneRedundant

Explanation

UserAssigned is correct for the identity type because it assigns a specific, pre-created managed identity to the SQL Managed Instance, giving it a unique, persistent identity that exists independently of the resource lifecycle. zoneRedundant is correct because setting this property to true ensures the SQL Managed Instance is replicated across multiple availability zones within a region, providing resilience against a single datacenter (zone) outage. Together, these two properties satisfy both requirements: a unique assigned identity and high availability against datacenter failures.

Topics

#Azure SQL Managed Instance#ARM Templates#Managed Identity#High Availability / Zone Redundancy

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full DP-300 Practice