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?
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.
Why this answer
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.
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.