What is Azure Data Factory?
A cloud-based ETL/ELT and data orchestration service.
What is the main purpose of ADF?
To move, transform, and orchestrate data across systems
Does ADF store data?
No - it only orchestrates and moves data
What is a pipeline?
A logical container that groups activities into a workflow.
What is an activity?
A single step inside a pipeline.
What is a dataset?
A metadata reference pointing to actual data.
What is a linked service?
The connection information to a data source or compute service.
What is an Integration Runtime (IR)?
The compute engine ADF uses to run activities.
What are the 3 types of IR?
Azure IR, Self-hosted IR, Azure SSIS IR.
What is the ADF Studio?
The UI used to build, monitor, and manage ADF
What is Author mode?
The workspace where you design pipelines.
What is Monitor mode?
The area where you view pipeline runs, triggers, and logs.
What is Git integration for ADF?
Allows version control and collaborative development
What is Live mode?
The published version of your data factory.
Do you edit directly in Live mode?
The published version of your data factory.
Do you edit directly in Live mode?
No - you edit in Git mode and publish
What is publishing in ADF?
Moving code from Git workspace > Live data factory
What is an ARM template?
An infrastructure-as-code definition for ADF components.
Can ADF work with on-prem data?
Yes - via Self-hosted IR.
What is a trigger?
A scheduler that runs pipelines automatically.
Does ADF support manual pipeline execution?
Yes - “Debug” and “Add Trigger > Now”
Can ADF call APIs?
Yes - via Web Activity.
Can ADF run SQL stored procedures?
Yes - via Stored Procedure Activity.
Can ADF process files?
Yes - copy, delete, validate, metadata.