UiPath-ADAv1 Files, Folders, and Data Manipulation Practice Question
A developer is building an automation that reads a large CSV file into a DataTable and then needs to keep only rows where the 'Status' column equals 'Active' and the 'Region' column equals 'EMEA'. The developer wants to avoid iterating through every row. Which method should be used to produce the filtered DataTable?
⚠ Common exam trap
Many candidates confuse the DataTable.Select method, which returns an array, with Filter Data Table, which returns a filtered DataTable.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Use the Filter Data Table activity with two conditions joined by the AND operator.
Filter Data Table evaluates column conditions and returns only matching rows, supporting AND/OR combinations natively. This satisfies the requirement to avoid row-by-row iteration and produces a DataTable directly. The other options either iterate, return a different data structure, or do not filter at all, making them unsuitable for this scenario.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Use a For Each Row activity and an If activity to remove non-matching rows with Remove Data Row.
Why it's wrong here
For Each Row iterates every record, and removing rows during iteration can cause index issues and performance degradation on large files. The scenario explicitly asks to avoid iterating through every row, so this approach is both slower and riskier than using a dedicated filtering activity.
- ✗
Use the Sort Data Table activity with the 'Status' column and then delete rows from the top.
Why it's wrong here
Sorting rearranges rows but does not remove any. Deleting rows based on position after sorting is fragile and still requires iteration, so it fails to meet the requirement of filtering by two column values without looping. Sort Data Table is not a filtering mechanism.
- ✓
Use the Filter Data Table activity with two conditions joined by the AND operator.
Why this is correct
Filter Data Table is designed to filter rows based on one or more column conditions and can combine them with AND or OR. Setting Status = 'Active' AND Region = 'EMEA' produces the required subset without any explicit loop, which is the most efficient and maintainable approach for this scenario.
- ✗
Use the Select method on the DataTable with a filter expression and assign the result to a DataRow array.
Why it's wrong here
Select returns a DataRow array, not a DataTable. While it can filter, converting the array back into a DataTable requires additional steps such as CopyToDataTable, and it does not directly produce the filtered DataTable the scenario requires. Filter Data Table is the purpose-built activity for this outcome.
About these practice questions
Courseiva writes every UiPath-ADAv1 question from scratch — 285 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official UiPath exam blueprint
This UiPath-ADAv1 practice question is part of Courseiva's free UiPath certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the UiPath-ADAv1 exam.