What is Data Factory? Explain the steps for creating a Data Factory

Answer:

Data Factory is a cloud-based data integration service that orchestrates and automates the movement and transformation of data. In order for this to happen, we need to follow the below steps

a)Create a Data Factory in Azure Portal from click Intelligence + Analytics followed by Data Factory.

b)Create an Azure SQL linked service 

c)Create dataset 

d)Create a pipeline activity 

e)Monitor the pipeline