UiPath Certification UiPath Data Manipulation and Variables 1 — Questions and Answers
Question 1: Which UiPath data type is used to store tabular data with rows and columns, similar to a spreadsheet?
- String
- Array
- DataTable (Correct answer)
- Dictionary
Correct answer: DataTable
DataTable is a .NET type that holds structured tabular data and is widely used for Excel, CSV, and database operations in UiPath.
Question 2: What VB.NET expression converts the string '42' to an integer in UiPath?
- Int32.Parse('42')
- CInt('42')
- Convert.ToInt32('42')
- All of the above (Correct answer)
Correct answer: All of the above
All three expressions — Int32.Parse, CInt, and Convert.ToInt32 — correctly parse a numeric string into an integer in VB.NET within UiPath.
Question 3: How do you access the third element of a UiPath array variable named 'myArray'?
- myArray(3)
- myArray[2]
- myArray(2) (Correct answer)
- myArray.Get(3)
Correct answer: myArray(2)
In VB.NET syntax used by UiPath, arrays are zero-indexed and accessed with parentheses: myArray(2) returns the third element.
Question 4: Which UiPath activity adds a new row to an existing DataTable variable?
- Insert Row
- Add Data Row (Correct answer)
- Append Row
- New DataRow
Correct answer: Add Data Row
The 'Add Data Row' activity appends a new row to a DataTable, accepting either an array of values or a DataRow object.
Question 5: What does the 'Build Data Table' activity in UiPath do?
- Reads data from a database
- Creates a new DataTable with defined columns and optionally adds rows (Correct answer)
- Exports a DataTable to Excel
- Filters rows in an existing DataTable
Correct answer: Creates a new DataTable with defined columns and optionally adds rows
Build Data Table opens a wizard to define column names and data types, generating a new DataTable variable you can populate programmatically.
Question 6: Which expression returns the number of rows in a DataTable variable named 'dt' in UiPath?
- dt.Count
- dt.Rows.Count (Correct answer)
- dt.Length
- dt.RowCount
Correct answer: dt.Rows.Count
The .Rows.Count property on a DataTable returns the number of data rows currently in the table.
Which UiPath data type is used to store tabular data with rows and columns, similar to a spreadsheet?