Azure Data Factory Interview Questions and Answers

Updated 26 Jul 2025

Asked in LTIMindtree

5d ago

Q. What are the layers in Azure Data Factory for pipelining data from on-premise to Azure Cloud?

Ans.

The 7 layers in Azure Data Factory for pipelining data from on-premises to Azure Cloud

1. Ingestion Layer: Collects data from various sources such as on-premises databases, cloud storage, or IoT devices.
2. Storage Layer: Stores the ingested data in a ...read more

Asked in PwC

4d ago

Q. How do we perform a delta load using ADF?

Ans.

Delta load in ADF is achieved by comparing source and target data and only loading the changed data.

Use a Lookup activity to retrieve the latest watermark or timestamp from the target table
Use a Source activity to extract data from the source system ...read more

Asked in TCS

3d ago

Q. What is the get metadata activity and what parameters do we have to pass?

Ans.

Get metadata activity is used to retrieve metadata of a specified data store or dataset in Azure Data Factory.

Get metadata activity is used in Azure Data Factory to retrieve metadata of a specified data store or dataset.
Parameters to pass include dat...read more

Asked in Hexaware Technologies

5d ago

Q. How do you perform performance tuning in ADF?

Ans.

Performance tuning in Azure Data Factory involves optimizing data flows and activities to improve efficiency and reduce processing time.

Identify bottlenecks in data flows and activities
Optimize data partitioning and distribution
Use appropriate data i...read more

Are these interview questions helpful?

Asked in Hoonartek

1d ago

Q. How many types of triggers are there in ADF?

Ans.

There are two types of triggers in Azure Data Factory: Schedule-based triggers and Event-based triggers.

Schedule-based triggers are based on a time schedule and can be set to run at specific intervals.
Event-based triggers are triggered by events such...read more

Asked in CapGrid Solutions

3d ago

Q. How do you copy recent files in ADF?

Ans.

Use GetMetadata activity to get recent files and then copy them using Copy Data activity in ADF.

Use GetMetadata activity in Azure Data Factory to retrieve information about recent files.
Filter the files based on their last modified date to get the mo...read more

Share interview questions and help millions of jobseekers 🌟

Asked in Wipro

2d ago

Q. What is a self-hosted Integration Runtime in Azure Data Factory (ADF)?

Ans.

Self-hosted Integration Runtime (IR) in Azure Data Factory enables data integration across on-premises and cloud environments.

Self-hosted IR allows data movement between on-premises data sources and cloud services.
It can connect to various data store...read more

Asked in Accenture

3d ago

Q. How many types of integration runtimes are there?

Ans.

There are three types of integration runtime: Self-hosted, Azure, and SSIS

Self-hosted integration runtime is installed on a local machine or a virtual machine within an on-premises network
Azure integration runtime is managed by Azure Data Factory and...read more

Asked in TCS

6d ago

Q. What are integration runtimes?

Ans.

Integration runtimes are compute infrastructure used by Azure Data Factory to provide data integration capabilities across different network environments.