In your data cleansing project, you need to identify and remove duplicate entries from a dataset using the Aggregate transformation. Which function should you use within the Aggregate transformation…

The correct answer is C. count(). The count() function is used to count occurrences of values within a dataset. When applied within the Aggregate transformation, it can count how many times each unique entry appears, thus aiding in the identification of duplicate entries by indicating those with a count greater…

Submitted by lukas.cz· Apr 18, 2026Prepare data

Question

In your data cleansing project, you need to identify and remove duplicate entries from a dataset using the Aggregate transformation. Which function should you use within the Aggregate transformation to aid in identifying duplicate entries?

Options

Asum()
Bmax()
Ccount()
Daverage()

How the community answered

(50 responses)

A
2% (1)
B
4% (2)
C
92% (46)
D
2% (1)

Explanation

The count() function is used to count occurrences of values within a dataset. When applied within the Aggregate transformation, it can count how many times each unique entry appears, thus aiding in the identification of duplicate entries by indicating those with a count greater than one. https://learn.microsoft.com/en-us/azure/data-factory/data-flow-aggregate#reconnect-rows-and-

Topics

#Data Cleansing#Aggregate Transformation#Duplicate Detection#Data Preparation

Community Discussion

No community discussion yet for this question.

Full DP-600 Practice