nerdexam
Microsoft

DP-300 · Question #443

You have an Azure subscription that contains an Azure SQL managed instance named SQLMl1. You need to configure SQLMl1 to use the Business Critical service tier. Which PowerShell cmdlet should you run?

The correct answer is D. Set-AzSqlInstance. To configure an Azure SQL Managed Instance to use the Business Critical service tier with PowerShell, you'll use the Set-AzSqlInstance cmdlet. This cmdlet allows you to modify various properties of an existing managed instance, including its service tier. You'll need to specify t

Submitted by jian89· Mar 6, 2026Plan and implement data platform resources

Question

You have an Azure subscription that contains an Azure SQL managed instance named SQLMl1. You need to configure SQLMl1 to use the Business Critical service tier. Which PowerShell cmdlet should you run?

Options

  • AUpdate-SqlVM
  • BSet-AzSqlServerConfigurationOption
  • CSet-AzSqlDatabase
  • DSet-AzSqlInstance

How the community answered

(45 responses)
  • A
    2% (1)
  • B
    4% (2)
  • C
    2% (1)
  • D
    91% (41)

Explanation

To configure an Azure SQL Managed Instance to use the Business Critical service tier with PowerShell, you'll use the Set-AzSqlInstance cmdlet. This cmdlet allows you to modify various properties of an existing managed instance, including its service tier. You'll need to specify the resource group, instance name, and the desired service tier as "BusinessCritical". $resourceGroupName = "YourResourceGroupName" $managedInstanceName = "YourManagedInstanceName" $serviceTier = "BusinessCritical" Set-AzSqlInstance -ResourceGroupName $resourceGroupName -Name $managedInstanceName -ServiceTier $serviceTier https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/scripts/create-configure- managed-instance-powershell

Community Discussion

No community discussion yet for this question.

Full DP-300 Practice