DRAG DROP 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.

The Data Migration Assistant (DMA) is the correct tool for migrating an on-premises SQL Server database to an Azure SQL Database. DMA is designed to detect compatibility issues and feature parity problems between source and target, and it can perform the migration of the schema, data, and uncontained objects.

The Azure Cosmos DB Data Migration Tool is the appropriate choice for migrating a specific table from SQL Server to an Azure Cosmos DB account. This tool is purpose-built to import data from various sources, including relational databases like SQL Server, into Azure Cosmos DB. It efficiently handles the data transformation from a tabular format to the document model used by the Cosmos DB SQL API.

AzCopy is incorrect as it's a command-line utility for copying blobs or files to or from Azure Storage accounts. Data Management Gateway is a legacy name for the Self-hosted Integration Runtime, which is a component of Azure Data Factory used for data integration, not a standalone migration tool.

Microsoft Docs: Overview of Data Migration Assistant. This document outlines the capabilities of DMA, stating, "Data Migration Assistant (DMA) helps you upgrade to a modern data platform by detecting compatibility issues that can impact database functionality in your new version of SQL Server or Azure SQL Database." It further specifies its use for migrating "an on-premises SQL Server instance to an Azure SQL Database."

Source: Microsoft Corporation. (2023). Overview of Data Migration Assistant. SQL Server Documentation. Retrieved from https://learn.microsoft.com/en-us/sql/dma/dma-overview

Microsoft Docs: Import data into Azure Cosmos DB for NoSQL with the desktop data migration tool. This guide details the usage of the Cosmos DB Data Migration tool. In the "Supported data sources" section, it explicitly lists Microsoft SQL Server as a source from which data can be imported into Azure Cosmos DB.

Source: Microsoft Corporation. (2024). Import data into Azure Cosmos DB for NoSQL with the desktop data migration tool. Azure Cosmos DB Documentation. Retrieved from https://learn.microsoft.com/en-us/azure/cosmos-db/nosql/import-data