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

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?
D) dtEmployee.Select('([Department]='IT' OR [Department]='Finance') AND [Salary] < 30000')
A) dtEmployee.Select('([Department]='IT' AND [Department]='Finance') AND [Salary] < 30000')
B) dtEmployee.Select('[Department]='IT OR [Department]='Finance' OR [Salary] < 30000')
C) dtEmployee.Select('[Department]='IT' OR [Department]= 'Finance' AND [Salary] < 30000')

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
7 months ago
Definitely D! It covers both departments and the salary condition.
upvoted 0 times
...
Glen
7 months ago
I think A is right, but it looks off to me.
upvoted 0 times
...
Junita
7 months ago
Option D is the correct one!
upvoted 0 times
...
Daniel
7 months ago
Wait, can you really use AND and OR like that? Seems confusing.
upvoted 0 times
...
Cyndy
7 months ago
B is totally wrong, it doesn't filter by salary properly.
upvoted 0 times
...
Queen
8 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
8 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
8 months ago
I think option D looks familiar; it seems to match the criteria for both departments and salary.
upvoted 0 times
...
Joanna
8 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
9 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
9 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
9 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
9 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
9 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
1 year ago
I'm not sure, but I think D makes sense because it uses the correct logical operators.
upvoted 0 times
...
Jesus
1 year ago
I agree with Henriette, option D seems right.
upvoted 0 times
...
Henriette
1 year ago
I think the correct answer is D.
upvoted 0 times
...
Nana
1 year ago
I'm not sure, but I think D makes sense because it uses the correct logical operators.
upvoted 0 times
...
Hortencia
1 year 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
1 year ago
C) dtEmployee.Select(\'[Department]='IT' OR [Department]= 'Finance' AND [Salary] < 30000\')
upvoted 0 times
...
Blossom
1 year ago
You're right, option D is the one that filters the data correctly.
upvoted 0 times
...
Pedro
1 year ago
B) dtEmployee.Select(\'[Department]='IT OR [Department]='Finance' OR [Salary] < 30000\')
upvoted 0 times
...
Blossom
1 year ago
I think option D is the correct one.
upvoted 0 times
...
Alesia
1 year ago
A) dtEmployee.Select(\'([Department]='IT' AND [Department]='Finance') AND [Salary] < 30000\')
upvoted 0 times
...
...
Herman
1 year ago
I agree with Lenna, option D seems right.
upvoted 0 times
...
Rolland
1 year 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
1 year ago
C) dtEmployee.Select(\'[Department]='IT' OR [Department]= 'Finance' AND [Salary] < 30000\')
upvoted 0 times
...
Boris
1 year ago
I agree, option B doesn't make sense. It would mix up the departments and not filter correctly.
upvoted 0 times
...
Kara
1 year ago
D) dtEmployee.Select(\'([Department]='IT' OR [Department]='Finance') AND [Salary] < 30000\')
upvoted 0 times
...
Ardella
1 year ago
A) dtEmployee.Select(\'([Department]='IT' AND [Department]='Finance') AND [Salary] < 30000\')
upvoted 0 times
...
...
Donette
1 year 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
1 year ago
Great, let's go with option D then.
upvoted 0 times
...
Nadine
1 year ago
Yes, option D filters the data table correctly.
upvoted 0 times
...
Gennie
1 year ago
I think option D is the right choice.
upvoted 0 times
...
...
Lenna
1 year ago
I think the correct answer is D.
upvoted 0 times
...

Save Cancel