UiPath-ADPv1 Advanced Data Manipulation Practice Question
A developer needs to filter a DataTable named 'dt_Orders' to include only rows where the 'Priority' is 'High'. Which THREE methods can be used to achieve this in UiPath?
⚠ Common exam trap
A common mistake is confusing the DataTable.Select method with LINQ. While they look similar, the Select method uses a string-based filter expression (DataView syntax), whereas LINQ uses lambda functions. Candidates also often forget that the Select method returns an array of DataRows, not a new 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
✓
Using the 'Filter Data Table' activity
UiPath offers multiple ways to filter data, ranging from visual activities to programmatic methods. The Filter Data Table activity is the most accessible for beginners, while the Select method and LINQ offer more control for complex logic. Understanding when to use each method allows developers to balance ease of maintenance with execution performance in professional automation projects.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Using the 'Filter Data Table' activity
Why this is correct
The Filter Data Table activity is a built-in UiPath activity specifically designed for this purpose. It provides a wizard-based interface to define filter criteria and allows the developer to output the results to either the original DataTable or a new one. It is the recommended approach for simple filtering tasks due to its readability.
- ✓
dt_Orders.Select("[Priority] = 'High'").CopyToDataTable()
Why this is correct
The Select method of the DataTable class accepts a filter expression string. It returns an array of DataRows that match the specified criteria. By calling CopyToDataTable on this array, the developer creates a new DataTable containing only the high-priority orders. This method is highly flexible and commonly used in legacy workflows.
- ✓
dt_Orders.AsEnumerable().Where(Function(row) row("Priority").ToString = "High").CopyToDataTable()
Why this is correct
This is a LINQ expression that converts the DataTable into an enumerable collection of rows. The Where clause applies a predicate function to filter the rows based on the Priority column. Using LINQ is the most powerful and performant way to filter data, especially when the criteria involve complex logic or external variables.
- ✗
Using the 'Lookup Data Table' activity
Why it's wrong here
The Lookup Data Table activity is designed to find a single value or row index based on a key, similar to a VLOOKUP in Excel. It cannot be used to filter an entire table or return a collection of multiple matching rows. Using it for filtering would require an inefficient loop and manual row collection.
- ✗
dt_Orders.Rows.Find("High")
Why it's wrong here
The Rows.Find method is used to locate a specific row based on the DataTable's Primary Key. It does not perform a filter operation and will fail if no Primary Key is defined for the table. It also only returns a single DataRow object rather than the filtered collection of rows required in this scenario.
About these practice questions
Courseiva writes every UiPath-ADPv1 question from scratch — 276 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-ADPv1 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-ADPv1 exam.