MENU
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?
Suggested Answer: D
Get Premium UiPath-ADPv1 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
35 comments · newest first
DU
Dustin
10 months ago
Definitely D! It covers both departments and the salary condition.
GL
Glen
10 months ago
I think A is right, but it looks off to me.
JU
Junita
10 months ago
Option D is the correct one!
DA
Daniel
10 months ago
Wait, can you really use AND and OR like that? Seems confusing.
CY
Cyndy
10 months ago
B is totally wrong, it doesn't filter by salary properly.
QU
Queen
11 months ago
I recall that using parentheses is important for clarity in these expressions, so I’m leaning towards option D as well.
RA
Raul
11 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?
CY
Cyndy
11 months ago
I think option D looks familiar; it seems to match the criteria for both departments and salary.
JO
Joanna
11 months ago
I remember we practiced filtering data tables, but I'm not sure if the AND/OR logic is applied correctly here.
TH
Thea
12 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.
KA
Kanisha
12 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.
AL
Aleshia
12 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.
DA
Dacia
1 year 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.
ME
Merilyn
1 year 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.
TA
Tammara
1 year ago
I'm not sure, but I think D makes sense because it uses the correct logical operators.
JE
Jesus
1 year ago
I agree with Henriette, option D seems right.
HE
Henriette
1 year ago
I think the correct answer is D.
NA
Nana
1 year ago
I'm not sure, but I think D makes sense because it uses the correct logical operators.
HO
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!
ME
Melynda
1 year ago
C) dtEmployee.Select(\'[Department]='IT' OR [Department]= 'Finance' AND [Salary] < 30000\')
BL
Blossom
1 year ago
You're right, option D is the one that filters the data correctly.
PE
Pedro
1 year ago
B) dtEmployee.Select(\'[Department]='IT OR [Department]='Finance' OR [Salary] < 30000\')
BL
Blossom
1 year ago
I think option D is the correct one.
AL
Alesia
1 year ago
A) dtEmployee.Select(\'([Department]='IT' AND [Department]='Finance') AND [Salary] < 30000\')
HE
Herman
1 year ago
I agree with Lenna, option D seems right.
RO
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.
CE
Celeste
1 year ago
C) dtEmployee.Select(\'[Department]='IT' OR [Department]= 'Finance' AND [Salary] < 30000\')
BO
Boris
1 year ago
I agree, option B doesn't make sense. It would mix up the departments and not filter correctly.
KA
Kara
1 year ago
D) dtEmployee.Select(\'([Department]='IT' OR [Department]='Finance') AND [Salary] < 30000\')
AR
Ardella
1 year ago
A) dtEmployee.Select(\'([Department]='IT' AND [Department]='Finance') AND [Salary] < 30000\')
DO
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.
RO
Rosendo
1 year ago
Great, let's go with option D then.
NA
Nadine
1 year ago
Yes, option D filters the data table correctly.
GE
Gennie
1 year ago
I think option D is the right choice.
LE
Lenna
1 year ago
I think the correct answer is D.