You have 100 devices that write performance data to Azure Blob storage.
You plan to store and analyze the performance data in an Azure SQL database.
You need to recommend a solution to move the performance data to the SQL database.
What should you include in the recommendation?
Click on the arrows to vote for the correct answer
A. B. C. D.B
You can copy data from Azure Blob to Azure SQL Database using Azure Data Factory.
https://docs.microsoft.com/en-us/azure/data-factory/tutorial-copy-data-dot-netBased on the requirements stated in the question, we need to move performance data stored in Azure Blob Storage to an Azure SQL Database for analysis. To achieve this, we need to choose the appropriate data migration service that can effectively move data from one location to another.
Here are the explanations of the four possible answers:
A. Azure Data Box Azure Data Box is a physical appliance used to transfer large amounts of data to Azure. It is primarily designed for use cases where there is limited or no internet connectivity, or where network bandwidth is a bottleneck. While Azure Data Box can be used to transfer data to Azure Blob Storage, it is not designed to move data from Blob Storage to Azure SQL Database.
B. Azure Data Factory Azure Data Factory (ADF) is a cloud-based data integration service that allows us to create, schedule, and manage data pipelines. ADF supports various sources and destinations, including Blob Storage and Azure SQL Database. We can use ADF to move data from Blob Storage to SQL Database in a cost-effective, scalable, and reliable manner.
C. Azure Database Migration Service Azure Database Migration Service (DMS) is a fully managed service designed to migrate databases to Azure with minimal downtime. DMS supports several database migration scenarios, including SQL Server to Azure SQL Database, MySQL to Azure Database for MySQL, and MongoDB to Azure Cosmos DB. While DMS can migrate data from SQL Server to Azure SQL Database, it cannot move data from Blob Storage to SQL Database.
D. Data Migration Assistant Data Migration Assistant (DMA) is a free tool provided by Microsoft to assess compatibility issues when migrating databases to Azure. DMA can help us identify any potential issues that may arise during the migration process. However, DMA is not a data migration tool and cannot move data from Blob Storage to SQL Database.
Therefore, the correct answer is B - Azure Data Factory. ADF is a cloud-based data integration service that supports moving data from Blob Storage to Azure SQL Database, which aligns with the requirement stated in the question. ADF is a reliable and cost-effective solution that can handle large volumes of data, making it the ideal solution for this scenario.