Systems, Architecture and Systems Architecture

According to the my experience in projects involving Azure Data Factories, the five most commonly used activities in Azure Data Factory are:

Copy Activity

This activity is used to copy data from a source to a destination data store, and is often used to transfer data from on-premises systems to the cloud. (Source: https://docs.microsoft.com/en-us/azure/data-factory/copy-activity-overview)

Lookup Activity

This activity is used to retrieve a single value from a specified dataset, which can be used in subsequent pipeline activities. (Source: https://docs.microsoft.com/en-us/azure/data-factory/lookup-activity)

If Condition Activity

This activity is used to conditionally execute pipeline activities based on a specified condition. (Source: https://docs.microsoft.com/en-us/azure/data-factory/control-flow-if-condition-activity)

For Each Activity

This activity is used to iterate over a collection of values and execute pipeline activities for each value in the collection. (Source: https://docs.microsoft.com/en-us/azure/data-factory/control-flow-for-each-activity)

Web Activity

This activity is used to call a REST endpoint and retrieve data from a web service, or to send data to a web service. (Source: https://docs.microsoft.com/en-us/azure/data-factory/control-flow-web-activity)

These activities are widely used in Azure Data Factory because they provide the core functionality needed to build data integration and transformation pipelines.