UiPath RPA Associate (UiRPA) — Question 45

A developer wants a new data table, dt_Result, that is only populated with common rows found in two data tables, dt_PreviousEmployees and dt_NewEmployees. Which activity should be used to perform this operation?

Answer options

• A. Sort Data Table
• B. Merge Data Table
• C. Join Data Table
• D. Filter Data Table

Correct answer: C

Explanation

The correct answer is C, Join Data Table, because it combines rows from both tables based on matching values, resulting in only the common rows being included in dt_Result. The other options, such as Sort and Filter, do not provide the functionality needed to create a new table based on overlapping data, while Merge is not appropriate for this specific use case.