UiPath Exam UiPath-ADPv1 Topic 4 Question 40 Discussion

Actual exam question for UiPath's UiPath-ADPv1 exam

Question #: 40
Topic #: 4

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?

AdtEmployee.Select('([Department]='IT' AND [Department]='Finance') AND [Salary] < 30000')

BdtEmployee.Select('[Department]='IT OR [Department]='Finance' OR [Salary] < 30000')

CdtEmployee.Select('[Department]='IT' OR [Department]= 'Finance' AND [Salary] < 30000')

DdtEmployee.Select('([Department]='IT' OR [Department]='Finance') AND [Salary] < 30000')

Show Suggested 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

14 days ago

I'm not sure, but I think D makes sense because it uses the correct logical operators.

upvoted 0 times

...

Jesus

15 days ago

I agree with Henriette, option D seems right.

upvoted 0 times

...

Henriette

15 days ago

I think the correct answer is D.

upvoted 0 times

...

Nana

17 days ago

I'm not sure, but I think D makes sense because it uses the correct logical operators.

upvoted 0 times

...

Hortencia

20 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

Pedro

5 days ago

B) dtEmployee.Select(\'[Department]='IT OR [Department]='Finance' OR [Salary] < 30000\')

upvoted 0 times

...

Blossom

11 days ago

I think option D is the correct one.

upvoted 0 times

...

Alesia

13 days ago

A) dtEmployee.Select(\'([Department]='IT' AND [Department]='Finance') AND [Salary] < 30000\')

upvoted 0 times

...

Herman

30 days ago

I agree with Lenna, option D seems right.

upvoted 0 times

...

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

Boris

11 days ago

I agree, option B doesn't make sense. It would mix up the departments and not filter correctly.

upvoted 0 times

...

Kara

14 days ago

D) dtEmployee.Select(\'([Department]='IT' OR [Department]='Finance') AND [Salary] < 30000\')

upvoted 0 times

...

Ardella

18 days ago

A) dtEmployee.Select(\'([Department]='IT' AND [Department]='Finance') AND [Salary] < 30000\')

upvoted 0 times

...

Donette

1 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

...

Lenna

2 months ago

I think the correct answer is D.

upvoted 0 times

...

UiPath Exam UiPath-ADPv1 Topic 4 Question 40 Discussion

Contribute your Thoughts:

Tammara

Jesus

Henriette

Nana

Hortencia

Pedro

Blossom

Alesia

Herman

Rolland

Boris

Kara

Ardella

Donette

Lenna