A database, DT1, is shown in the following exhibit:
The Filter Wizard of a Filter Data Table activity is shown below:
What is the result after the activity has executed?
Exam UiARD All QuestionsBrowse all questions from this exam
Question 59
Correct Answer: D
The Filter Wizard in this example is set to remove rows based on the conditions specified: ID equals 4, or Name contains 'Patricia', or Department equals 'Account'. None of these conditions are met for the column names provided. However, there might be an issue with the column names if they do not exactly match the case or spelling in the Filter Wizard settings, leading to a runtime error. Hence, a runtime error will be thrown if the column names do not match exactly.
Discussion
MirjalolOption: C
Answer is C, Marie, Science remains
Engineer24Option: C
If you test this example in the studio, it will filter all rows that meet the condition. The end result will be: ID Name Department 2 Mary Science.
Engineer24Option: D
If the main Column is DT1 then the answer is D. The error will be: "Filter Data Table: the value for argument 'Column Name' is not set or is invalid."
IngvarnOption: C
Answer is C, Marie, Science remains
DesingLIVOption: C
Answer is C, Marie, Science remains