DP-203 Azure Data Engineer Associate DP-203 Azure Data Engineer Associate Data Integration and Pipelines 2

Question 1

What is the key difference between a Tumbling Window Trigger and a Schedule Trigger in Azure Data Factory?

Accepted Answer

Tumbling Window Triggers maintain state and support retry; Schedule Triggers do not

Answer

Schedule Triggers are free; Tumbling Window Triggers cost extra

Answer

Tumbling Window Triggers only work with Blob Storage events

Answer

Schedule Triggers support dependency chains; Tumbling Window Triggers do not

Question 2

Which ADF Mapping Data Flow transformation is used to combine rows from two datasets based on a matching condition?

Accepted Answer

Join

Answer

Union

Answer

Aggregate

Answer

Pivot

Question 3

In ADF, which parameter scope allows you to pass dynamic values into a pipeline at runtime?

Accepted Answer

Pipeline parameters

Answer

Dataset parameters

Answer

Global parameters

Answer

Activity parameters

Question 4

What does the 'Self-hosted Integration Runtime' enable in Azure Data Factory?

Accepted Answer

Connecting to on-premises or private network data sources

Answer

Running SSIS packages on Azure-SSIS IR

Answer

Scaling out Spark execution across cloud nodes

Answer

Automating dataset schema detection

Question 5

Which ADF feature allows you to visually debug a Mapping Data Flow without running the full pipeline?

Accepted Answer

Data preview in debug mode

Answer

Activity run history

Answer

Validate pipeline

Answer

Publish all

Question 6

In Azure Data Factory, what is the role of a Dataset?

Accepted Answer

Describes a named view of the data that refers to a Linked Service

Answer

Defines compute resources for activity execution

Answer

Schedules recurring pipeline runs

Answer

Stores pipeline execution logs