AZURE DATA FACTORY TRAINING WITH REAL TIME SCENARIOS

Learn Azure Data Factory with real time scenarios, some of the sample scenarios mentioned below.

I  had covered the basics and Intermediate level , real time scenario based questions asked in interviews.

It has covered the below scenarios and many more.

1 Copy All the available files from the landing container to the sink container in the same Azure Datalake storage Gen2 accounts

2 Copy all the tables available from Azure SQL database to Azure data lake storage container environment in csv format with data

3 Copy only selected files from the container to another container - use of filter activity.

4 Multiple Filter Activity scenarios.

5 Copy data from the ADLS container into the snowflake table

6 Onpremise SQL Server to ADLS data migration

7 Onpremise SQL Server to Azure SQL Data Migration

8 Azure SQL to ADLS Container --- tables migration with required columns only

9 Migrate required tables and required columns from on premise sql server to azure sql tables

10 Migrate data from the ADLS containers all the files into a single table on azure sql side.

11 Migrate data from the ADLS containers all the files into a multiple tables as per the file on azure sql side.

12 BLOB CONTAINER SERVERAL FILES COPY ONE FILE FROM THAT CONTAINER TO THE ADLS GEN2 CONTAINER

13 MOVE ALL THE CSV FILES FROM THE BLOB CONTAINER TO THE ADLS GEN2 CONTAINER

14 BEFORE .JSON , IT SHOULD BE HAVING A FIVE CHARACTERS AS FILENAME , I WANT TO COPY THAT FILES ONLY

15 All files starting with Em (Any format) copy all the files from the input container to the output container

16 COPY ONLY REQUIRED FILES - PATTERN MATCHING SCENARIO

17 COPY BEHAVIOR - FLATTEN - MERGE AND PRESERVE Hierarchy SCENARIO

18 Fault tolerance_LOG_ERROR_INFO_COPY_DATA_ACTIVITY

19 How to perform merge operation in ADF

20 Load_Nested_JSON_AS_CSV_File

21 How Precedent constraints works

22 Parameterization in ADF

23 Implementation of Slowly Changing Dimension TYPE-1---MUCH NEEDED

24  Implementation of Slowly Changing Dimension TYPE-2_VERY_IMPORTANT_SCENARIO

and many more.

Preparing for these questions and scenarios will help you demonstrate your knowledge and practical skills in Azure Data Factory. I suggest to create Azure account which is free for one month and do practice along with me and let me know if you have any doubt while performing this tasks.