Migrating Performance Data to Azure SQL Database
Question
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?
Answers
Explanations
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-netThe recommended solution to move the performance data from Azure Blob storage to Azure SQL database is Azure Data Factory (option B).
Azure Data Factory is a cloud-based data integration service that allows you to create, schedule, and manage data pipelines that move and transform data from various sources to various destinations. It supports a wide range of data sources, including Azure Blob storage and Azure SQL database, and provides built-in connectors and transformations to easily move data between them.
To move the performance data from Azure Blob storage to Azure SQL database, you can create a data pipeline in Azure Data Factory that reads the data from Azure Blob storage and writes it to Azure SQL database. You can configure the pipeline to run on a schedule or trigger it manually whenever you need to move the data.
Azure Data Factory also provides monitoring and logging capabilities to help you track the progress and performance of your data pipelines, and troubleshoot any issues that may arise.
Azure Database Migration Service (option A) is another Azure service that can be used to migrate data from various sources to Azure SQL database. However, it is more suitable for larger-scale migrations that require minimal downtime and data loss. It may be overkill for a smaller-scale migration like the one described in the question.
Azure Data Box (option C) is a physical device that can be used to transfer large amounts of data to Azure data centers using secure and reliable network connections. However, it is more suitable for offline data transfers or scenarios where there is limited network bandwidth or high latency.
Data Migration Assistant (option D) is a tool that can be used to assess the compatibility of your databases with Azure SQL database and provide recommendations for migration. It does not provide data migration capabilities like Azure Data Factory or Azure Database Migration Service.
