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?
UiARD Exam QuestionsBrowse all questions from this exam
UiARD Exam - Question 59
Show AnswerHide Answer
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
5 commentsEngineer24Option: C
Apr 18, 2024If 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.
MirjalolOption: C
Jul 17, 2024Answer is C, Marie, Science remains
Engineer24Option: D
Jul 4, 2024If 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."
DesingLIVOption: C
Sep 25, 2024Answer is C, Marie, Science remains
IngvarnOption: C
Nov 22, 2024Answer is C, Marie, Science remains