nerdexam
Microsoft

AZ-305 · Question #109

Drag and Drop Question You plan to import data from your on-premises environment to Azure. The data is shown in the following table. What should you recommend using to migrate the data? To answer, dra

The correct answer is Data Migration Assistant; Azure Cosmos DB Data Migration Tool. The correct arrangement matches each data source to its appropriate migration tool: Data Migration Assistant (DMA) is specifically designed to migrate on-premises SQL Server databases to Azure SQL Database or Azure SQL Managed Instance, assessing compatibility and recommending fi

Submitted by deeparc· Mar 6, 2026Design and Implement Data Storage and Migration Solutions - specifically selecting the appropriate Azure migration tools for relational and NoSQL data sources (commonly tested in Azure Data Engineer Associate DP-203 or Azure Solutions Architect Expert AZ-305 certifications)

Question

Drag and Drop Question You plan to import data from your on-premises environment to Azure. The data is shown in the following table. What should you recommend using to migrate the data? To answer, drag the appropriate tools to the correct data sources. Each tool may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point. Answer:

Exhibits

AZ-305 question #109 exhibit 1
AZ-305 question #109 exhibit 2
AZ-305 question #109 exhibit 3
AZ-305 question #109 exhibit 4

Answer Area

Drag items

AzcopyAzure Cosmos DB Data Migration ToolData Management GatewayData Migration Assistant

Correct arrangement

  • Data Migration Assistant
  • Azure Cosmos DB Data Migration Tool

Explanation

The correct arrangement matches each data source to its appropriate migration tool: Data Migration Assistant (DMA) is specifically designed to migrate on-premises SQL Server databases to Azure SQL Database or Azure SQL Managed Instance, assessing compatibility and recommending fixes before migration. The Azure Cosmos DB Data Migration Tool is purpose-built to import data into Azure Cosmos DB from various sources such as MongoDB, SQL, CSV, JSON, and other formats commonly found in on-premises environments. These tools are the Microsoft-recommended solutions for their respective target services.

Topics

#Azure Data Migration#Azure Cosmos DB#Azure SQL Database#Data Migration Tools

Community Discussion

No community discussion yet for this question.

Full AZ-305 Practice