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
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

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

by Scarlet at May 03, 2025, 08:32 PM

Limited Time Offer

25%

Off

Get Premium UiPath-ADPv1 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel
Tammara
1 months ago
I'm not sure, but I think D makes sense because it uses the correct logical operators.
upvoted 0 times
...
Jesus
1 months ago
I agree with Henriette, option D seems right.
upvoted 0 times
...
Henriette
1 months ago
I think the correct answer is D.
upvoted 0 times
...
Nana
2 months ago
I'm not sure, but I think D makes sense because it uses the correct logical operators.
upvoted 0 times
...
Hortencia
2 months 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
Melynda
28 days ago
C) dtEmployee.Select(\'[Department]='IT' OR [Department]= 'Finance' AND [Salary] < 30000\')
upvoted 0 times
...
Blossom
29 days ago
You're right, option D is the one that filters the data correctly.
upvoted 0 times
...
Pedro
1 months ago
B) dtEmployee.Select(\'[Department]='IT OR [Department]='Finance' OR [Salary] < 30000\')
upvoted 0 times
...
Blossom
1 months ago
I think option D is the correct one.
upvoted 0 times
...
Alesia
1 months ago
A) dtEmployee.Select(\'([Department]='IT' AND [Department]='Finance') AND [Salary] < 30000\')
upvoted 0 times
...
...
Herman
2 months ago
I agree with Lenna, option D seems right.
upvoted 0 times
...
Rolland
2 months 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
Celeste
30 days ago
C) dtEmployee.Select(\'[Department]='IT' OR [Department]= 'Finance' AND [Salary] < 30000\')
upvoted 0 times
...
Boris
1 months ago
I agree, option B doesn't make sense. It would mix up the departments and not filter correctly.
upvoted 0 times
...
Kara
1 months ago
D) dtEmployee.Select(\'([Department]='IT' OR [Department]='Finance') AND [Salary] < 30000\')
upvoted 0 times
...
Ardella
2 months ago
A) dtEmployee.Select(\'([Department]='IT' AND [Department]='Finance') AND [Salary] < 30000\')
upvoted 0 times
...
...
Donette
2 months 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
Rosendo
18 days ago
Great, let's go with option D then.
upvoted 0 times
...
Nadine
19 days ago
Yes, option D filters the data table correctly.
upvoted 0 times
...
Gennie
26 days ago
I think option D is the right choice.
upvoted 0 times
...
...
Lenna
2 months ago
I think the correct answer is D.
upvoted 0 times
...

Save Cancel