Module assessment

1.

You need to create a user with access to the Sales database on your Azure Database for MySQL flexible server. The user should only have access to Sales database. What should you do?

In Access control (IAM), select a Role and then assign that Role to the user.

Use the CREATE USER keywords to create a user account and assign privileges.

Use Azure RBAC to assign a role to the user.

2.

You need to create a user with access to the Azure Database for MySQL server. What should you do?

In Access control (IAM), select a Role and then assign that Role to the user.

Use the CREATE USER keywords to create a user account and assign privileges.

Use the GRANT keyword to assign privileges the user.

3.

Which statement best describes the admin user that is created when the Azure Database for MySQL server is created?

Use the server admin account to create more users and grant admin access to them.

Use the server admin account to create more privileged users.

Use the server admin account to create azure_superuser users.

4.

You've been asked to explore how best to secure sensitive data being held in Azure Database for MySQL. Which statement best describes your options?

Consider moving data to another database because Azure Database for MySQL doesn't support data encryption.

Azure Database for MySQL supports data encryption in transit and data at rest. When you create a table, you must configure the table to use encryption.

Azure Database for MySQL runs the Community Edition of MySQL. Only the Enterprise edition supports data at rest encryption.

Check your knowledge

Feedback