Azure Database for MySQL - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create an Azure Database for MySQL server using Azure CLI.

Azure

az mysql server create --resource-group myResourceGroup --name mydemoserver --location eastus --admin-user myadmin [1] --sku-name GP_Gen5_2

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

A--admin-password MyP@ssword123

B--admin-password

C--admin-user-password

D--password-admin

Attempts:

3 left

💡 Hint

Common Mistakes

Using incorrect flag names for the password.

Omitting the password flag entirely.

The --admin-password flag is used to specify the administrator password when creating an Azure Database for MySQL server.

2fill in blank

medium

Complete the code to configure the firewall rule to allow access from a specific IP address.

Azure

az mysql server firewall-rule create --resource-group myResourceGroup --server mydemoserver --name AllowMyIP --start-ip-address [1] --end-ip-address [1]

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

A0.0.0.0

B255.255.255.255

C192.168.1.100

D127.0.0.1

Attempts:

3 left

💡 Hint

Common Mistakes

Using invalid IP addresses.

Setting different start and end IPs when only one IP should be allowed.

The --start-ip-address and --end-ip-address flags specify the IP range allowed to access the MySQL server. To allow a single IP, both should be the same.

3fill in blank

hard

Fix the error in the command to update the MySQL server's backup retention period.

Azure

az mysql server update --resource-group myResourceGroup --name mydemoserver --backup-retention [1]

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

A30

B7

C30days

Dseven

Attempts:

3 left

💡 Hint

Common Mistakes

Adding units like 'days' to the number.

Using words instead of numbers.

The --backup-retention flag expects an integer number of days, such as 30. Text or units like 'days' are invalid.

4fill in blank

hard

Fill both blanks to create a new database on the MySQL server with the correct charset and collation.

Azure

az mysql db create --resource-group myResourceGroup --server-name mydemoserver --name mydatabase --charset [1] --collation [2]

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

Autf8

Butf8mb4

Cutf8_general_ci

Dutf8mb4_unicode_ci

Attempts:

3 left

💡 Hint

Common Mistakes

Using utf8 charset which is limited.

Mismatching charset and collation.

For best compatibility and support of emojis and special characters, use utf8mb4 charset and utf8mb4_unicode_ci collation.

5fill in blank

hard

Fill all three blanks to configure the MySQL server's performance tier, storage size, and backup retention.

Azure

az mysql server update --resource-group myResourceGroup --name mydemoserver --sku-name [1] --storage-size [2] --backup-retention [3]

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

AGP_Gen5_4

B5120

C14

DBasic

E10240

F7

Attempts:

3 left

💡 Hint

Common Mistakes

Using storage size in GB instead of MB.

Setting backup retention with invalid values.

Choosing incorrect SKU names.

The --sku-name sets the performance tier and compute size, --storage-size is in MB (5120 MB = 5 GB), and --backup-retention is the number of days backups are kept.