Creating Azure SQL Database - Interactive Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a resource group in Azure CLI.

Azure

az group create --name [1] --location eastus

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

AsqlServer

BmyResourceGroup

Ceastus

DmyDatabase

Attempts:

3 left

💡 Hint

Common Mistakes

Using location name instead of resource group name

Using server or database names in place of resource group

The resource group name is specified with --name. Here, myResourceGroup is a common example name.

2fill in blank

medium

Complete the code to create an Azure SQL server with admin user.

Azure

az sql server create --name [1] --resource-group myResourceGroup --location eastus --admin-user adminuser --admin-password MyP@ssw0rd

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

AmySqlServer

BmyResourceGroup

Ceastus

DmyDatabase

Attempts:

3 left

💡 Hint

Common Mistakes

Using database name instead of server name

Using resource group name instead of server name

The server name is specified with --name. mySqlServer is a typical example server name.

3fill in blank

hard

Fix the error in the command to create an Azure SQL database.

Azure

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

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

AmyDatabase

BS0

CmySqlServer

DmyResourceGroup

Attempts:

3 left

💡 Hint

Common Mistakes

Using server or resource group names instead of database name

Confusing service objective with database name

The database name is specified with --name. myDatabase is the correct database name here.

4fill in blank

hard

Fill both blanks to set the firewall rule allowing Azure services and specify the start IP.

Azure

az sql server firewall-rule create --resource-group myResourceGroup --server mySqlServer --name AllowAzureServices --start-ip-address [1] --end-ip-address [2]

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

A0.0.0.0

B255.255.255.255

D192.168.1.1

Attempts:

3 left

💡 Hint

Common Mistakes

Using different IP addresses for start and end

Using private IP addresses instead of 0.0.0.0

To allow Azure services, both start and end IP addresses should be 0.0.0.0.

5fill in blank

hard

Fill all three blanks to create a database with a specific edition and max size.

Azure

az sql db create --resource-group myResourceGroup --server mySqlServer --name [1] --edition [2] --max-size [3]

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

AmyDatabase

BStandard

C5GB

DBasic

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing up edition and max size values

Using server or resource group names instead of database name

The database name is myDatabase, edition is Standard, and max size is 5GB.