New Year Sale 2026! 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-ADPv1 Exam - 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:

0/2000 characters
Submit Cancel
Dustin
2 months ago
Definitely D! It covers both departments and the salary condition.
upvoted 0 times
...
Glen
2 months ago
I think A is right, but it looks off to me.
upvoted 0 times
...
Junita
2 months ago
Option D is the correct one!
upvoted 0 times
...
Daniel
3 months ago
Wait, can you really use AND and OR like that? Seems confusing.
upvoted 0 times
...
Cyndy
3 months ago
B is totally wrong, it doesn't filter by salary properly.
upvoted 0 times
...
Queen
3 months ago
I recall that using parentheses is important for clarity in these expressions, so I’m leaning towards option D as well.
upvoted 0 times
...
Raul
3 months ago
I feel like I mixed up the AND and OR conditions in the practice questions. Was it supposed to be both departments or just one?
upvoted 0 times
...
Cyndy
4 months ago
I think option D looks familiar; it seems to match the criteria for both departments and salary.
upvoted 0 times
...
Joanna
4 months ago
I remember we practiced filtering data tables, but I'm not sure if the AND/OR logic is applied correctly here.
upvoted 0 times
...
Thea
4 months ago
This looks like a good opportunity to apply my knowledge of data filtering. I'm confident I can work through this and select the right expression.
upvoted 0 times
...
Kanisha
4 months ago
I'm a bit confused by the different options. I'll need to review the logic and test each expression to see which one gives the desired result.
upvoted 0 times
...
Aleshia
4 months ago
Okay, I think I've got this. The key is to use the AND and OR operators correctly to filter for the Finance and IT departments with a salary under 30,000.
upvoted 0 times
...
Dacia
5 months ago
Hmm, the wording of the question is a bit tricky. I'll need to think through the logic carefully to make sure I select the correct expression.
upvoted 0 times
...
Merilyn
5 months ago
This looks like a straightforward filtering problem, but I need to be careful with the logical operators to get the right combination of department and salary criteria.
upvoted 0 times
...
Tammara
9 months ago
I'm not sure, but I think D makes sense because it uses the correct logical operators.
upvoted 0 times
...
Jesus
9 months ago
I agree with Henriette, option D seems right.
upvoted 0 times
...
Henriette
9 months ago
I think the correct answer is D.
upvoted 0 times
...
Nana
9 months ago
I'm not sure, but I think D makes sense because it uses the correct logical operators.
upvoted 0 times
...
Hortencia
9 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
8 months ago
C) dtEmployee.Select(\'[Department]='IT' OR [Department]= 'Finance' AND [Salary] < 30000\')
upvoted 0 times
...
Blossom
8 months ago
You're right, option D is the one that filters the data correctly.
upvoted 0 times
...
Pedro
8 months ago
B) dtEmployee.Select(\'[Department]='IT OR [Department]='Finance' OR [Salary] < 30000\')
upvoted 0 times
...
Blossom
9 months ago
I think option D is the correct one.
upvoted 0 times
...
Alesia
9 months ago
A) dtEmployee.Select(\'([Department]='IT' AND [Department]='Finance') AND [Salary] < 30000\')
upvoted 0 times
...
...
Herman
9 months ago
I agree with Lenna, option D seems right.
upvoted 0 times
...
Rolland
9 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
8 months ago
C) dtEmployee.Select(\'[Department]='IT' OR [Department]= 'Finance' AND [Salary] < 30000\')
upvoted 0 times
...
Boris
9 months ago
I agree, option B doesn't make sense. It would mix up the departments and not filter correctly.
upvoted 0 times
...
Kara
9 months ago
D) dtEmployee.Select(\'([Department]='IT' OR [Department]='Finance') AND [Salary] < 30000\')
upvoted 0 times
...
Ardella
9 months ago
A) dtEmployee.Select(\'([Department]='IT' AND [Department]='Finance') AND [Salary] < 30000\')
upvoted 0 times
...
...
Donette
10 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
8 months ago
Great, let's go with option D then.
upvoted 0 times
...
Nadine
8 months ago
Yes, option D filters the data table correctly.
upvoted 0 times
...
Gennie
8 months ago
I think option D is the right choice.
upvoted 0 times
...
...
Lenna
10 months ago
I think the correct answer is D.
upvoted 0 times
...

Save Cancel