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

Delta Copy with a watermark pattern uses a high-watermark table to track the last successfully copied value and only copies new or changed records on subsequent runs.

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

The ForEach activity iterates over a collection (array) and executes a set of inner activities for each item, supporting both sequential and parallel execution.

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

The Stored Procedure activity in ADF directly invokes a stored procedure on Azure SQL Database, Azure Synapse, or SQL Server via a Linked Service.

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

The Aggregate transformation groups rows by one or more columns and computes summary functions like SUM, COUNT, or AVG for each group.

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

The Validate feature checks all pipeline artifacts for configuration errors, missing parameters, or invalid references before you publish changes to the ADF service.

DP-203 Azure Data Engineer Associate Practice Test

DP-203 Azure Data Engineer Associate Practice Test

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