DP-203 Azure Data Engineer Associate DP-203 Azure Data Engineer Associate Data Integration and Pipelines 1 — Questions and Answers
Question 1: Which Azure Data Factory component is used to define the sequence of activities to perform a data transformation task?
- Pipeline (Correct answer)
- Dataset
- Linked Service
- Trigger
Correct answer: Pipeline
A Pipeline in Azure Data Factory is a logical grouping of activities that defines the sequence and dependencies for performing a data transformation task.
Question 2: In Azure Data Factory, what is a Linked Service used for?
- Defining the data structure
- Storing connection information to external resources (Correct answer)
- Scheduling pipeline runs
- Monitoring data flows
Correct answer: Storing connection information to external resources
A Linked Service in ADF stores the connection string and configuration details needed to connect to external data sources and compute environments.
Question 3: Which ADF activity type is used to copy data from one data store to another?
- Execute Pipeline
- Copy Data (Correct answer)
- Lookup
- Web
Correct answer: Copy Data
The Copy Data activity in Azure Data Factory is the primary activity used to move data between supported source and sink data stores.
Question 4: What is the purpose of an Integration Runtime (IR) in Azure Data Factory?
- To schedule pipeline triggers
- To provide compute infrastructure for data movement and transformation (Correct answer)
- To define the schema of datasets
- To monitor pipeline execution history
Correct answer: To provide compute infrastructure for data movement and transformation
The Integration Runtime provides the compute infrastructure used by ADF to perform data movement, activity dispatch, and SSIS package execution.
Question 5: In Azure Synapse Analytics, which feature allows you to orchestrate pipelines similarly to Azure Data Factory?
- Synapse Spark
- Synapse Pipelines (Correct answer)
- Synapse Link
- Synapse Studio SQL
Correct answer: Synapse Pipelines
Synapse Pipelines is the built-in orchestration capability within Azure Synapse Analytics that provides the same pipeline authoring experience as Azure Data Factory.
Question 6: Which trigger type in Azure Data Factory runs a pipeline on a wall-clock schedule (e.g., every hour)?
- Tumbling Window Trigger
- Event-Based Trigger
- Schedule Trigger (Correct answer)
- Manual Trigger
Correct answer: Schedule Trigger
The Schedule Trigger fires pipeline runs at a defined wall-clock time interval, such as daily at midnight or every hour.
DP-203 Azure Data Engineer Associate DP-203 Azure Data Engineer Associate Data Integration and Pipelines 1
Which Azure Data Factory component is used to define the sequence of activities to perform a data transformation task?