UiPath Certification UiPath Data Manipulation and Variables 3

Question 1

Which UiPath activity converts a DataTable to a CSV-formatted string?

Accepted Answer

Output Data Table

Answer

The 'Output Data Table' activity serializes a DataTable into a pipe or tab-delimited string representation.

Question 2

What does the 'Assign' activity do in UiPath?

Accepted Answer

Sets the value of a variable or property using an expression

Answer

The Assign activity is used to set or update a variable's value with any valid VB.NET or C# expression.

Question 3

In UiPath, what is the purpose of the 'For Each' activity when used with a DataTable?

Accepted Answer

Iterates over each row in the DataTable

Answer

When the TypeArgument is set to DataRow, 'For Each' iterates over every row in the DataTable, exposing each row as the loop variable.

Question 4

How do you access the value in the column named 'Email' from a DataRow variable called 'row' in UiPath?

Accepted Answer

row('Email').ToString

Answer

In VB.NET, DataRow column values are accessed using parentheses with the column name as a string key, then converted with .ToString.

Question 5

Which UiPath activity should you use to sort a DataTable by a specific column?

Accepted Answer

LINQ OrderBy expression with Assign

Answer

UiPath lacks a native Sort Data Table activity, so sorting is done via LINQ: dt.AsEnumerable().OrderBy(Function(r) r('ColumnName')).CopyToDataTable().

UiPath Certification Practice Test

UiPath Certification Practice Test

UiPath Certification UiPath Data Manipulation and Variables 3