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 Exam UiPath-ADPv1 Topic 4 Question 40 Discussion

Actual exam question for UiPath's UiPath-ADPv1 exam
Question #: 40
Topic #: 4
[All UiPath-ADPv1 Questions]

Data from an Excel file is read into a data table named "dtEmployee", as displayed in the following graphic:

A developer needs to filter the data table to obtain all rows representing employees from the Finance and IT departments with a Salary under 30,000. Which expression yields the desired outcomes?

Show Suggested Answer Hide Answer
Suggested Answer: D

Contribute your Thoughts:

Nana
1 days ago
I'm not sure, but I think D makes sense because it uses the correct logical operators.
upvoted 0 times
...
Hortencia
3 days ago
Option C is close, but the AND condition should be on the whole department part, not just the second part. Gotta be careful with those logical operators!
upvoted 0 times
...
Herman
13 days ago
I agree with Lenna, option D seems right.
upvoted 0 times
...
Rolland
16 days ago
I'm not sure why option B is even there. You can't filter for both department and salary in a single OR condition. That would just give you all employees with a salary under 30,000, regardless of department.
upvoted 0 times
Ardella
1 days ago
A) dtEmployee.Select(\'([Department]='IT' AND [Department]='Finance') AND [Salary] < 30000\')
upvoted 0 times
...
...
Donette
22 days ago
Option D seems to be the correct answer. It filters the data table to include only rows where the department is either IT or Finance, and the salary is less than 30,000.
upvoted 0 times
...
Lenna
29 days ago
I think the correct answer is D.
upvoted 0 times
...

Save Cancel