Microsoft Azure Architect Design (AZ-301) Practice Exam

Disable ads (and more) with a membership for a one time $2.99 payment

Prepare for the Microsoft Azure Architect Design (AZ-301) Exam with interactive quizzes featuring flashcards and multiple-choice questions, each packed with hints and explanations to ace your certification test!

Each practice test/flash card set has 50 randomly selected questions from a bank of over 500. You'll get a new set of questions each time!

Practice this question and more.

Which is the proper method for migrating data from an on-premises SQL Server 2012 database to Azure SQL Database?

AzCopy
Azure Cosmos DB Data Migration Tool
Data Migration Assistant
Data Management Gateway

The correct answer is: Data Migration Assistant

The correct method for migrating data from an on-premises SQL Server 2012 database to Azure SQL Database is the Data Migration Assistant. This tool is specifically designed to assist with the migration of databases. It assesses your on-premises environment and provides insights on compatibility issues, helping you to identify any concerns that may arise during migration. Moreover, the Data Migration Assistant allows you to not only assess but also to migrate your data seamlessly. It provides a straightforward process for the transfer of schema and data, making it an ideal choice when dealing with SQL Server databases. In contrast, AzCopy is primarily a command-line utility for copying data to and from Azure storage accounts and is not tailored for SQL database migration. The Azure Cosmos DB Data Migration Tool is focused on migrating data into Azure Cosmos DB, rather than Azure SQL Database, making it unsuitable for this specific scenario. Data Management Gateway connects on-premises data sources to cloud services for data movement; however, it does not perform the migration itself. Thus, the Data Migration Assistant is uniquely equipped for the task of migrating SQL Server databases to Azure SQL Database.