UiPath-ADAv1 Exam Dumps : UiPath Automation Developer Associate Exam (2023.10)

To assign each User ID in dt_Users to a List variable Users_List, the Item property of the Add To Collection activity should be configured as:

CurrentRow(0).ToString

This expression accesses the value of the first column (index 0) in the current row of the dt_Users datatable using the CurrentRow variable. The CurrentRow variable is a DataRow object that represents the row that is being iterated in the For Each Row activity. The expression uses the ToString method to convert the value of the User ID column to a string type. The expression returns the User ID value as a string, which is then added to the Users_List variable by the Add To Collection activity1. For example, if the dt_Users datatable has the following values:

User ID

Name

101

John

102

Mary

103

Bob

Then the expression CurrentRow(0).ToString will return 101, 102, and 103 as the User ID values in each iteration of the For Each Row activity, and these values will be added to the Users_List variable.

The difference between "Workbook Write Range" and "Excel Application Integration Write Range" activities is that the "Excel Application Integration Write Range" (also known as "Excel Write Range") activity can execute correctly even if the Excel file is already opened by the user before running. It interacts with Excel as an application, making it visible and allowing for interaction with the Excel interface. On the other hand, the "Workbook Write Range" activity works in the background, does not require Excel to be installed, and will create the Excel file in the specified path if it does not exist. So, the correct answer is D.

The Assign activity is used to assign a value to a variable. In this case, the variable is “qty”. The value of the variable will be 80 after executing the Assign activity because the expression in the Assign activity is “dt.AsEnumerable().Where(Function(x) x(“Item”).ToString.Equals(“mango”)).Select(Function(y) y(“Quantity”)).ToString”. This expression is filtering the data table “dt” for rows where the “Item” column is equal to “mango” and then selecting the “Quantity” column from those rows. Since there is only one row in the data table where “Item” is equal to “mango”, the value of the “Quantity” column in that row is 80. (UiPath Studio documentation)