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.

Practice

1. What is the main purpose of Azure Database for MySQL?

easy

A. To provide a managed MySQL database service in the cloud

B. To create virtual machines for running MySQL manually

C. To store files and documents in the cloud

D. To host websites without databases

Solution

1. Step 1: Understand Azure Database for MySQL service

   It is a managed service that runs MySQL databases in the cloud, handling maintenance tasks.

2. Step 2: Compare options with service purpose

   Only To provide a managed MySQL database service in the cloud describes a managed MySQL database service, others describe unrelated services.

3. Final Answer:

   To provide a managed MySQL database service in the cloud -> Option A

4. Quick Check:

   Managed MySQL service = To provide a managed MySQL database service in the cloud [OK]

Hint: Managed means Azure handles database tasks for you [OK]

Common Mistakes:

• Confusing database service with virtual machines
• Thinking it stores files like blob storage
• Assuming it hosts websites directly

2. Which of the following is the correct way to create a new Azure Database for MySQL server using Azure CLI?

easy

A. az mysql server new --resource-group MyGroup --name MyServer --location eastus --admin-user admin --admin-password MyPass123

B. az sql server create --resource-group MyGroup --name MyServer --location eastus --admin-user admin --admin-password MyPass123

C. az mysql server create --resource-group MyGroup --name MyServer --location eastus --admin-user admin --admin-password MyPass123

D. az mysql create server --resource-group MyGroup --name MyServer --location eastus --admin-user admin --admin-password MyPass123

Solution

1. Step 1: Identify correct Azure CLI command syntax

   The correct command to create a MySQL server is az mysql server create.

2. Step 2: Check options for correct command and parameters

   az mysql server create --resource-group MyGroup --name MyServer --location eastus --admin-user admin --admin-password MyPass123 uses the correct command and parameters. Options A, B, and C use incorrect commands or syntax.

3. Final Answer:

   az mysql server create --resource-group MyGroup --name MyServer --location eastus --admin-user admin --admin-password MyPass123 -> Option C

4. Quick Check:

   Correct CLI command = az mysql server create --resource-group MyGroup --name MyServer --location eastus --admin-user admin --admin-password MyPass123 [OK]

Hint: Use 'az mysql server create' to create MySQL server [OK]

Common Mistakes:

• Using 'az sql' instead of 'az mysql'
• Incorrect command order or missing 'server'
• Using 'new' or 'create server' incorrectly

3. Given this Azure CLI command output snippet after creating a MySQL server:

{
  "name": "myserver",
  "location": "eastus",
  "userVisibleState": "Ready",
  "version": "5.7"
}

What does the userVisibleState value indicate?

medium

A. The server is currently being deleted

B. The server is ready to use

C. The server is paused

D. The server is in an error state

Solution

1. Step 1: Understand 'userVisibleState' meaning

   This field shows the current status of the MySQL server as seen by the user.

2. Step 2: Interpret the value 'Ready'

   'Ready' means the server is fully set up and available for connections.

3. Final Answer:

   The server is ready to use -> Option B

4. Quick Check:

   'Ready' means usable server = The server is ready to use [OK]

Hint: 'Ready' means server is active and usable [OK]

Common Mistakes:

• Confusing 'Ready' with 'Paused' or 'Deleting'
• Assuming 'Ready' means error or maintenance
• Ignoring the status field meaning

4. You tried to connect to your Azure Database for MySQL server but got a connection error. Which of the following is the most likely cause?

medium

A. The MySQL version is outdated

B. The database name is missing in the connection string

C. The server is located in a different Azure region

D. The server firewall rules do not allow your client IP

Solution

1. Step 1: Identify common connection error causes

   Firewall rules blocking client IP is a frequent cause of connection failures.

2. Step 2: Evaluate other options

   MySQL version or region mismatch usually do not cause connection errors. Missing database name causes different errors.

3. Final Answer:

   The server firewall rules do not allow your client IP -> Option D

4. Quick Check:

   Firewall blocking IP = The server firewall rules do not allow your client IP [OK]

Hint: Check firewall rules to allow your IP address [OK]

Common Mistakes:

• Ignoring firewall settings
• Blaming MySQL version for connection issues
• Assuming region affects connectivity directly

5. You want to ensure your Azure Database for MySQL server automatically scales compute resources during peak hours and reduces them at night to save cost. Which Azure feature should you use?

hard

A. Use the 'Flexible Server' deployment option with auto-scaling enabled

B. Enable the 'Auto-scaling' feature in the server configuration

C. Configure the server with the 'Burstable' pricing tier

D. Manually change the server SKU daily using Azure CLI scripts

Solution

1. Step 1: Understand scaling options in Azure Database for MySQL

   The Flexible Server deployment supports auto-scaling features for compute resources.

2. Step 2: Evaluate options for auto-scaling support

   Use the 'Flexible Server' deployment option with auto-scaling enabled correctly identifies Flexible Server with auto-scaling. Burstable tier does not auto-scale. Manual scripts are not automatic. 'Auto-scaling' feature is not a direct setting in standard server.

3. Final Answer:

   Use the 'Flexible Server' deployment option with auto-scaling enabled -> Option A

4. Quick Check:

   Flexible Server supports auto-scaling = Use the 'Flexible Server' deployment option with auto-scaling enabled [OK]

Hint: Use Flexible Server for built-in auto-scaling [OK]

Common Mistakes:

• Confusing Burstable tier with auto-scaling
• Thinking manual scripts are automatic
• Assuming 'Auto-scaling' is a simple toggle in all servers