MCQ IN COMPUTER SCIENCE & ENGINEERING

COMPUTER SCIENCE AND ENGINEERING

SQL

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

How might you migrate an on-premises MySQL database to Azure SQL Database?

A	Use the SQL Server Migration Assistant.
B	Do an online migration using the Azure Database Migration Service.
C	Upload the data to Azure Storage, and configure Azure SQL Database to read the data from the storage account.
D	None of the above

Explanation:

Detailed explanation-1: -Open the Azure SQL Migration extension for Azure Data Studio. Connect to your source SQL Server instance. Click the Migrate to Azure SQL button, in the Azure SQL Migration wizard in Azure Data Studio. Select databases for assessment, then click on next.

Detailed explanation-2: -Open SSMA for MySQL. On the File menu, select New Project. Enter the project name and a location to save your project and the migration target. Then select SQL Server in the Migrate To option.

There is 1 question to complete.