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.
MICROSOFT.SQL/MANAGEDINSTANCES and [parameters('virtualNetworkName')] are the right picks. Managed Instances are the only Azure SQL option with native cross-database query support without elastic query workarounds. Regular servers just can't do it directly in ARM. Pretty sure that's what exam wants, but open to a second opinion.
MICROSOFT.SQL/MANAGEDINSTANCES and [parameters('virtualNetworkName')]. Managed Instance is the only one that supports native cross-database queries via T-SQL, not just with Elastic Query. Seen similar on Microsoft docs and practice exams, but let me know if you disagree.
I'd still add labs and official docs to your study, these ARM template subtleties are easy to miss.
Hmm, I'd say SQLAgentOperatorRole in msdb. It handles creating and managing jobs, which should cover the requirements, though maybe it's a bit more access than strictly needed. Saw something similar in an old exam dump so that's what I'd go with. Not 100% certain if that's the tightest privilege though, open to correction!
