nerdexam
Microsoft

AZ-305 · Question #452

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 continually…

The correct answer is B. Azure Data Factory. Azure Data Factory Azure Data Box Microsoft Azure Data Box is a hardware appliance designed to allow customers to import or export large amounts of data-more than 40TB-into and out of Azure offline. Azure Database Migration Service Azure Logic App * Data Migration Assistant…

Submitted by tunde_lagos· Mar 6, 2026Design data storage solutions

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 continually copy the performance data to the Azure SQL database. The solution should minimize administrative effort. What should you include in the recommendation?

Options

  • AAzure Database Migration Service
  • BAzure Data Factory
  • CAzure Logic App
  • DAzure Data Box

How the community answered

(22 responses)
  • A
    14% (3)
  • B
    77% (17)
  • C
    5% (1)
  • D
    5% (1)

Explanation

  • Azure Data Factory * Azure Data Box Microsoft Azure Data Box is a hardware appliance designed to allow customers to import or export large amounts of data-more than 40TB-into and out of Azure offline. * Azure Database Migration Service * Azure Logic App * Data Migration Assistant (DMA) You can use the Azure portal to create a data factory. Then you use the Copy Data tool to create a pipeline that copies data from Azure Blob storage to a SQL Database. You can create a schedule trigger, specify a schedule (start date, recurrence, end date etc.) for the trigger, and associate with a pipeline. https://docs.microsoft.com/en-us/azure/data-factory/tutorial-copy-data-tool

Community Discussion

No community discussion yet for this question.

Full AZ-305 Practice