A company has the requirement to have an automated process in place which would upload logs to an Azure SQL database every week. Reports would then be generated from the SQL database. Which of the fol

The correct answer is B. Azure Data Factory. You can use the Azure Data Factory to create a pipeline that can be used to copy data. Below is an excerpt from the Microsoft documentation on the connector for SQL server. https://docs.microsoft.com/en-us/azure/data-factory/connector-sql-server

Submitted by layla.eg· Mar 5, 2026Describe Azure Architecture and Services

Question

A company has the requirement to have an automated process in place which would upload logs to an Azure SQL database every week. Reports would then be generated from the SQL database. Which of the following would you use for this requirement?

Options

AThe AzCopy tool
BAzure Data Factory
CAzure HDInsight
DData Migration Assistant

How the community answered

(31 responses)

A
3% (1)
B
81% (25)
C
3% (1)
D
13% (4)

Explanation

You can use the Azure Data Factory to create a pipeline that can be used to copy data. Below is an excerpt from the Microsoft documentation on the connector for SQL server. https://docs.microsoft.com/en-us/azure/data-factory/connector-sql-server

Community Discussion

No community discussion yet for this question.

Full AZ-900 Practice