This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
With the increasing risk of cyber attacks, you're concerned your database servers don't have the latest bug fixes. How can you ensure your Azure Database for MySQL servers have the latest bug fix updates applied?
Set an alert for bug fix updates and create a runbook to apply the updates automatically.
Bug fix updates are automatically applied. You don't need to take any action.
Use the Advanced Threat Protection (ATP) feature to ensure bug fixes are applied.
You want to keep your writeable on-premises version of a MySQL database, but create replica read-only copies for users in another region. What's the most straightforward method to achieve this with Azure Database for MySQL?
Create an Azure Database for MySQL instance in the region closest to your users and configure Data-In Replication.
Create a read replica copy of your database that is located in the region closest to your users.
Create a writeable Azure Database for MySQL instance in the region closest to your users, and create a read-only replica in your on-premises MySQL server.
In MySQL, you have a database that includes large tables of data for employees and customers. In Azure Database for MySQL, you only want customer data. What's the easiest way to migrate the required data to Azure Database for MySQL?
Delete the unnecessary tables before doing a dump and restore.
Complete a mysqldump, and then edit the sql file to omit the tables that aren't required.
Perform a Data Export from MySQL Workbench, and select the required objects.
You have many user accounts in MySQL. How are these accounts migrated to Azure Database for MySQL when using the Azure Database Migration Service?
The accounts are automatically migrated by the Azure Database Migration Service.
The accounts are automatically migrated by a dump and restore migration.
You must manually create the accounts post-migration.
You have many applications, using various programming languages, that must be redirected to your migrated database. Where do you find the database connection settings to use in your client applications?
In the INFORMATION_SCHEMA.CONNECTION_STRINGS table in Azure Database for MySQL.
In the Connection strings page for Azure Database for MySQL.
In the Connection settings page for your Azure portal.
You must answer all questions before checking your work.
Was this page helpful?