George is a Cloud Data Engineer for Adatum Corporation. He’s working on the database migration activities from on-premises SQL server tables to Azure SQL database using Azure Data factory. He’s required to perform the incremental data loading activity. 
The steps for incremental data loading activities from on-premises SQL server tables to Azure SQL database through Azure Data Factory using Azure portal are as follows – 
A. Select the watermark column. 
B. Prepare the SQL data store to store the watermark value. 
C. Create a For-each activity that iterates through a list of source table names passed as a parameter to the pipeline. 
D. Create two lookup activities, one for getting the old watermark value from last time and another for getting the new watermark value from the source table. 
E. Create the Stored procedure activity in ADF to update the watermark for the delta data loading next time. 
F. Create a Copy activity in ADF to delta loading of data between the watermarks from the source table to merge data to the destination. 
Which of the following set of activities he needs to perform in sequence?

Answer options:

A.a -> b -> c -> d -> e -> f
B.a -> b -> c-> d -> f -> e
C.a -> b -> d -> c -> e -> f
D.a -> b -> d -> c -> f -> e

Correct Answer: B 
Here is the right sequence of steps for migrating on-prem SQL server tables to Azure SQL database using Azure Data factory activities and pipelines. 
a . Select the watermark column. The one column for each table in the source data store to be selected is a watermark column that can be used to identify the new or updated records for every run. 
b. Prepare the SQL data store to store the watermark value. 
c.Create a For-each activity that iterates through a list of source table names passed as a parameter to the pipeline. 
d. Create two lookup activities. The first lookup activity retrieves the last watermark value while the second lookup activity retrieves the new lookup value. These watermark values are passed to the Copy activity of the next step. 
f. Create a Copy activity that copies rows from source data store with watermark column value > old watermark value and < the new watermark value. 
e. Create a Stored Procedure activity in ADF which updates the watermark value for the pipeline runs next time. 

https://docs.microsoft.com/en-us/azure/data-factory/tutorial-incremental-copy-multiple-tables-portal