Exam UiADPv1 topic 1 question 11 discussion

Actual exam question from UiPath 's UiADPv1

Question #: 11
Topic #: 1

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?

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

Show Suggested Answer

Suggested Answer: D 🗳️

by Ingvarn at Dec. 2, 2023, 1:04 p.m.

Comments

Submit Cancel

Ingvarn

Highly Voted 1 year, 5 months ago

Selected Answer: D

D - D. dtEmployee.Select("([Department]='IT' OR [Department]='Finance') AND [Salary] < 30000"). Checked in Studio.

upvoted 5 times

...

AlbinL

Most Recent 1 week, 1 day ago

Selected Answer: D

D is correct, selecting IT and Finance as in alternative A will not work, as only rows where Department is IT and Finance simultaneously will be selected in that case. Having the OR as in D means that people either in IT or Finance are selected.

upvoted 1 times

...