pbPassingBI
/
knime/quizzes/knime-quiz-manipulate
6 questions

Data manipulation — quiz

6 questions covering this module. Filtering columns and rows, rule logic, and handling missing values.

  1. Which node lets you see the rows a filter excluded?

    1. Row Filter
    2. Row Splitter
    3. Column Filter
    4. Rule Engine

    Answer: Row Splitter — Non-matching rows come out of the second port.

  2. A new column appears in the source each month. Which selection mode survives?

    1. Manual
    2. Wildcard or type-based
    3. Neither
    4. Reference

    Answer: Wildcard or type-based — A manual list breaks when the schema changes.

  3. Which rule ordering is correct?

    1. > 100 then > 1000
    2. > 1000 then > 100
    3. Order does not matter
    4. Alphabetical

    Answer: > 1000 then > 100 — The most specific condition must be evaluated first.

  4. Rows matching no rule receive:

    1. Zero
    2. A missing value
    3. The last rule's result
    4. An error

    Answer: A missing value — Add a TRUE catch-all unless missing is intended.

  5. In KNIME, a missing value is:

    1. An empty string
    2. A distinct state, not empty or zero
    3. Always zero
    4. A null string

    Answer: A distinct state, not empty or zero — Use MISSING $col$ in a Rule Engine to test for it.

  6. Filling revenue with the mean rather than zero:

    1. Is always better
    2. Asserts the value was typical rather than zero
    3. Is faster
    4. Removes the row

    Answer: Asserts the value was typical rather than zero — The two produce different totals.