Microsoft Azure Architect Design (legacy) — Question 47

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?

Answer options

Correct answer: B

Explanation

The correct choice is Azure Data Factory because it is specifically designed for data integration and movement between different services, including from Azure Blob storage to Azure SQL database. The other options, such as Azure Data Box and Azure Database Migration Service, are not tailored for this type of direct data pipeline creation, while Data Migration Assistant focuses on assessing database migrations rather than moving data.