azure data engineer interview questions | adf real time interview questions | BIG 4 Companies

how to use wildcard in getmeta data in adf?
#Azure #AzureDataFactory #ADF #adfinterviewquestionandanswer

In this video, I discussed about how to use wildcard characters in get metadata activity using azure data factory

1.
get metadata activity in azure data factory | get metadata activity in adf | adf tutorial part 30:
2.
foreach activity in azure data factory | foreach activity in adf | adf tutorial part 32:
3.
if condition activity in adf | If Condition Activity in Azure Data Factory | adf tutorial part 28:
4.
Delete Activity in Azure Data Factory | ADF tutorial part 19:
5.
Azure blob storage tutorial | Block Blob, Append blob and Page Blob explained with demo:

adf tutorial:

[niranjanraaj]

I recently attended an interview and they asked an scenario based questions

scenario 1: In the blob storage we have a zip file, that contains 10 files inside it, how to extract the zip file and store it as separate file and filename should be in the format of filename_dd/mm/yy.


scenario 2: Continuation of above scenario but the sink will be database table and the each files should be stored in the appropriate tables (A file to A table, B file to B table) and some times filename will be random, so we can't store the filename information in config table.

[prabhudarshnal]

Nice video sir keep posting more videos

[VasiSultan]

Hi,
Could you please also make a video on the following scenario.

There is adls gen 2 container.every day two files test1.csv and test2.csv are created in the container. The order of creation is not fixed. But the pipeline should be triggered when both the files are available in the container and copy the data into different adls gen 2 container