Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

UiPath-ARDv1 Exam - Topic 1 Question 124 Discussion

Actual exam question for UiPath's UiPath-ARDv1 exam
Question #: 124
Topic #: 1
[All UiPath-ARDv1 Questions]

A developer extracts data about employees from an Excel workbook. The developer uses the following expression to filter the extracted datatable.

extractedDataTable.Select("[Age]>=21 AND ([Education]='Master' OR [Salary]>100000) AND [Education]='Bachelor'")

How many rows will be returned as the result of the filtering?

Please find below the worksheet with data.

Show Suggested Answer Hide Answer
Suggested Answer: D

The expression[Education]='Master' OR [Salary]>100000would return all rows except for 4 and 9.

Next,[Age]>=21would also eliminate rows 8 and 10.

Out of the remaining rows, only row 3 has a Bachelor degree, so[Education]='Bachelor'would leave only that 1 row.

UiPath forum

Exam Topic:Describe how to initialize variables such as lists and datatables, and how to filter datatables


Contribute your Thoughts:

0/2000 characters
Ciara
17 days ago
I vaguely recall that if both education conditions can't be true at the same time, it might lead to zero results. I need to double-check that.
upvoted 0 times
...
Armando
22 days ago
I think the expression is a bit confusing because it combines both education levels. I feel like it might return fewer rows than expected.
upvoted 0 times
...
Shantay
27 days ago
I remember we practiced a similar question where we had to filter based on multiple conditions, but I’m not sure how the AND/OR logic works here.
upvoted 0 times
...

Save Cancel