Azure Data Engineer Interview Questions and Answers | adf real time interview questions

#Azure #AzureDataFactory #ADF #adfinterviewquestionandanswer
azure data factory interview question and answers.
In this video, I discussed about how to create table at run time and load multiple files from blob storage using azure data factory:

get metadata activity in azure data factory | get metadata activity in adf | adf tutorial part 30:

foreach activity in azure data factory | foreach activity in adf | adf tutorial part 32:

copy data activity in azure data factory | Azure Data Factory Tutorial | ADF tutorial part 7:

adf interview question and answer:

adf tutorial:

[vajaykumar]

Superb explanations sir,
Can you make a complete list of interview questions

[shyamkumardhamode]

Thanks Susheel this question was in CitiusTech interview to

[goluSingh-suxs]

Superb scenarios and very good explanation ❤️

[sravankumar]

If we multiple sheets how shd we iterate each sheet, can we use indexes?

[Durgaprasad-dvsl]

Hi,

In one of the interview i got a question like...

if we have 10 files moving to sql through adf. 3 files are failed to move.
in this case can we move remaining 7 files and skip these files without failing the pipeline.
is it possible?

[laxmikant-tegg]

this can be done with single copy activity. in source give wildcard file path.

[MohammedSaud-tq]

Sir, how to make a pipeline A dependent on the pipeline B, suppose pipeline B should be executed unless pipeline A has completed status.

[prabhatgupta]

Here instead of getmetadeta cant we use lookup??

[shyamkumardhamode]

I have four pipelines running and they are copying data in blob storage folder called output and file name is like data1, data2, data3 ... In CSV format but I want this output to be in one file with different sheets

[venkatchinta]

Hey bro actually today I witnessed some wierd scenario in ADF

And the data tranfer gets failed when it hits that row having null values

And in the error log i get the same error for entire 4k records

But my data transfer was stuck at 55th row only

error is Missing argument external id.

can you please give me suggestion on this

[satishkumar-boue]

can u write here sql code, not visible clearly