Knowledge check

1.

You're writing a script that uses the Azure CLI to create and configure an Azure Database for MySQL service. You need to allow access to the service for other Azure services. Which IP address range should you specify in the az mysql server firewall-rule create command?

Set the start-ip-address parameter to 0.0.0.0, and the end-ip-address parameter to 255.255.255.255.

Set the start-ip-address and end-ip-address parameters to 0.0.0.0.

Set the start-ip-address and end-ip-address parameters to the range defined by the subnet that contains your resources.

2.

How do you change the server parameters for Azure Database for MySQL?

Use the Server parameters page for the server in the Azure portal.

You can't change server parameters. The server is managed entirely by Azure.

Connect to the server using MySQL Workbench and use the System Variables page to modify the server settings.

3.

You're using Query Performance Insight to track the performance of queries running on your server. You notice that the wait statistics for one query show a significant number of lengthy IO waits. What might cause this?

This could be due to a poorly designed query, an inefficient join operation, or a full table scan incurred because of a missing index.

This could be caused by a high volume of network activity.

This might be the result of connection throttling, if the server is attempting to handle a large number of concurrent requests.

Feedback