nerdexam
Microsoft

AZ-305 · Question #262

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 cop

The correct answer is A. Azure Data Factory. Azure Data Factory - using Data Factory pipelines. Data Factory pipelines can copy data from Azure Blob Storage to an Azure SQL Database. The configuration pattern applies to copying from a file- based data store to a relational data store. https://learn.microsoft.com/en-us/azure

Submitted by amina.ke· 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. What should you include in the recommendation?

Options

  • AAzure Data Factory
  • BData Migration Assistant (DMA)
  • CAzure Data Box
  • DAzure Database Migration Service

How the community answered

(42 responses)
  • A
    76% (32)
  • B
    2% (1)
  • C
    12% (5)
  • D
    10% (4)

Explanation

Azure Data Factory - using Data Factory pipelines. Data Factory pipelines can copy data from Azure Blob Storage to an Azure SQL Database. The configuration pattern applies to copying from a file- based data store to a relational data store. https://learn.microsoft.com/en-us/azure/data-factory/tutorial-copy-data-dot-net

Topics

#Azure Data Factory#data pipeline#Blob Storage#Azure SQL

Community Discussion

No community discussion yet for this question.

Full AZ-305 Practice