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

Question 1

Which ADF feature enables incremental data loading by tracking the last loaded watermark value?

Accepted Answer

Delta Copy with watermark

Answer

Full load Copy activity

Answer

ForEach with parallelism

Answer

Lookup with cache sink

Question 2

When should you use Azure Data Factory's 'ForEach' activity?

Accepted Answer

To iterate over a collection of items and execute child activities for each

Answer

To merge multiple data streams into one

Answer

To execute an external REST API call

Answer

To branch pipeline execution based on a condition

Question 3

Which ADF activity allows you to execute a stored procedure on an Azure SQL Database or Azure Synapse Analytics?

Accepted Answer

Stored Procedure activity

Answer

Script activity

Answer

Lookup activity

Answer

Web activity

Question 4

In Azure Data Factory Mapping Data Flows, which transformation reduces the number of rows by computing summary statistics per group?

Accepted Answer

Aggregate

Answer

Filter

Answer

Derived Column

Answer

Sort

Question 5

What is the purpose of ADF's 'Validate' feature before publishing a pipeline?

Accepted Answer

To check for configuration errors in pipelines, datasets, and linked services

Answer

To trigger a test pipeline run with sample data

Answer

To deploy the pipeline to a production environment

Answer

To generate documentation for the pipeline

Question 6

Which Azure service can Azure Data Factory use as a source to trigger pipelines based on blob creation events?

Accepted Answer

Azure Event Grid

Answer

Azure Service Bus

Answer

Azure Logic Apps

Answer

Azure Monitor