Azure SQL Database vs SQL Managed Instance - Interactive Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create an Azure SQL Database using the Azure CLI.

Azure

az sql db create --resource-group myResourceGroup --server myServer --name [1] --service-objective S0

Drag options to blanks, or click blank then click option'

AmyDatabase

BmyResourceGroup

CmyServer

DS0

Attempts:

3 left

💡 Hint

Common Mistakes

Using the server name instead of the database name.

Confusing resource group with database name.

The --name parameter specifies the name of the Azure SQL Database to create.

2fill in blank

medium

Complete the code to create an Azure SQL Managed Instance using the Azure CLI.

Azure

az sql mi create --name [1] --resource-group myResourceGroup --vnet-name myVnet --subnet mySubnet --admin-user adminUser --admin-password myPassword

Drag options to blanks, or click blank then click option'

AmyDatabase

BmyManagedInstance

CmyServer

DmyResourceGroup

Attempts:

3 left

💡 Hint

Common Mistakes

Using database name instead of Managed Instance name.

Confusing resource group with Managed Instance name.

The --name parameter specifies the name of the Managed Instance to create.

3fill in blank

hard

Fix the error in the command to create an Azure SQL Database with a performance tier.

Azure

az sql db create --resource-group myResourceGroup --server myServer --name myDatabase --[1] S3

Drag options to blanks, or click blank then click option'

Atier

Bperformance-tier

Cservice-objective

Dperformance-level

Attempts:

3 left

💡 Hint

Common Mistakes

Using incorrect parameter names like 'performance-tier' or 'tier'.

Misspelling the parameter name.

The correct parameter to specify the performance tier is --service-objective.

4fill in blank

hard

Fill both blanks to configure a subnet for Azure SQL Managed Instance with the required delegation and service endpoints.

Azure

az network vnet subnet update --name [1] --vnet-name myVnet --resource-group myResourceGroup --delegations [2]

Drag options to blanks, or click blank then click option'

AmySubnet

BMicrosoft.Sql/managedInstances

CMicrosoft.Sql/servers

DMicrosoft.Network/virtualNetworks

Attempts:

3 left

💡 Hint

Common Mistakes

Using server delegation instead of managed instance delegation.

Using wrong subnet name.

The subnet name is mySubnet and the delegation for Managed Instance is Microsoft.Sql/managedInstances.

5fill in blank

hard

Fill all three blanks to write a PowerShell command that creates an Azure SQL Database with a specified edition and max size.

Azure

New-AzSqlDatabase -ResourceGroupName myResourceGroup -ServerName myServer -DatabaseName [1] -Edition [2] -MaxSizeBytes [3]

Drag options to blanks, or click blank then click option'

ATestDB

BStandard

C2147483648

DBasic

Attempts:

3 left

💡 Hint

Common Mistakes

Using incorrect edition names.

Setting max size in wrong units.

The database name is TestDB, edition is Standard, and max size is 2147483648 bytes (2 GB).