DP-203 Azure Data Engineer Associate Data Integration and Pipelines Flashcards
6 cards from real DP-203 Azure Data Engineer Associate practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 6 DP-203 Azure Data Engineer Associate Data Integration and Pipelines flashcards as text
What is the key difference between a Tumbling Window Trigger and a Schedule Trigger in Azure Data Factory?
Answer: Tumbling Window Triggers maintain state and support retry; Schedule Triggers do not
Tumbling Window Triggers maintain state, support backfill of historical windows, and allow dependency on other tumbling window triggers, unlike simple Schedule Triggers.
Which ADF Mapping Data Flow transformation is used to combine rows from two datasets based on a matching condition?
Answer: Join
The Join transformation in ADF Mapping Data Flows combines rows from two input streams based on a matching key condition, similar to a SQL JOIN.
In ADF, which parameter scope allows you to pass dynamic values into a pipeline at runtime?
Answer: Pipeline parameters
Pipeline parameters allow you to define dynamic values that callers must supply when triggering or invoking the pipeline, enabling reusability.
What does the 'Self-hosted Integration Runtime' enable in Azure Data Factory?
Answer: Connecting to on-premises or private network data sources
The Self-hosted Integration Runtime is installed on an on-premises machine or VM inside a private network, allowing ADF to securely access private data sources.
Which ADF feature allows you to visually debug a Mapping Data Flow without running the full pipeline?
Answer: Data preview in debug mode
Turning on Debug Mode in Mapping Data Flows spins up a small Spark cluster and allows you to preview data at each transformation step interactively.
In Azure Data Factory, what is the role of a Dataset?
Answer: Describes a named view of the data that refers to a Linked Service
A Dataset represents a named view or pointer to the data you want to use in your pipeline activities, referencing a Linked Service for connection details.
How this page was made: written with AI tools and published by Nathan Beja, founder of Practice Test Geeks, who is responsible for its content. Exam facts are checked against the official sources listed below. Not reviewed by a subject-matter expert. Editorial policy
Sources & references
Exam facts on this page (fees, format, dates, passing scores) are checked against these official sources; the date is our last check. Editorial policy
- learn.microsoft.com — Passing score, eligibility, renewal, time limit, score release, score validity, exam information · verified Nov 2026
- pearsonvue.com — Test delivery · verified Nov 2026