nerdexam
MicrosoftMicrosoft

DP-300 · Question #308

DP-300 Question #308: Real Exam Question with Answer & 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 proper

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:

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.

Full DP-300 PracticeBrowse All DP-300 Questions