UiPath-ADAv1 Files, Folders, and Data Manipulation Practice Question
A developer stores a DataTable named dtOrders that was read from an Excel file. They need to keep only the rows where the column "Status" equals "Open" and store the result in a new DataTable variable called dtOpenOrders. Which activity should they use to accomplish this with the least configuration effort?
⚠ Common exam trap
The trap here is assuming that DataTable.Select returns a DataTable, when it actually returns a DataRow array that would need additional conversion.
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
✓
Filter Data Table activity with the condition Status = "Open" configured in the Filter Wizard
Filtering rows by a column value is a standard DataTable operation, and UiPath provides the Filter Data Table activity specifically for it. Configuring the condition Status = "Open" in the activity's wizard produces a new DataTable in one step, preserving the source table. Loop-based alternatives or DataTable.Select require more activities or type conversions that this scenario does not call for.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Remove Data Row activity executed repeatedly until only rows where Status equals "Open" remain
Why it's wrong here
Remove Data Row deletes a single specified row and would need to be invoked in a loop with careful index handling, which is error-prone and inefficient. It also mutates the original DataTable rather than producing a separate dtOpenOrders result, so it does not match the requirement of keeping the original data intact.
- ✓
Filter Data Table activity with the condition Status = "Open" configured in the Filter Wizard
Why this is correct
The Filter Data Table activity is purpose-built for this scenario: it accepts an input DataTable, applies row/column filter conditions defined in its wizard (such as Status = "Open"), and outputs a new DataTable without any loop or LINQ code. It is the native, least-effort approach for filtering a DataTable by a column value inside a UiPath Studio sequence.
- ✗
For Each Row activity with an If activity inside that adds matching rows to a second DataTable
Why it's wrong here
A For Each Row loop with an If and an Add Data Row works but requires several activities, a manually built output DataTable schema, and explicit row construction. For a simple equality filter it is unnecessarily verbose and slower, and it introduces maintainability risk because the developer must keep the target DataTable's columns synchronized with the source.
- ✗
Select method on the DataTable with a lambda expression that returns rows where Status equals "Open"
Why it's wrong here
The DataTable.Select method does return an array of DataRow objects matching a filter expression, but the result is a DataRow array, not a DataTable. The scenario explicitly requires the filtered result in a DataTable variable, so the developer would need extra conversion steps, making this less suitable than the dedicated activity.
About these practice questions
This UiPath-ADAv1 question is part of Courseiva's 285-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam 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.