pbPassingBI
/
knime/exams/knime-exam-full

KNIME full mock exam

12 questions sampled across all 4 modules. Timed like the real thing: answer everything, then review the explanations.

  1. What does a black triangle port carry?

    1. A database connection
    2. A data table
    3. A model
    4. A flow variable

    Answer: A data table — The standard data table port.

  2. A previously working node has turned red. Most likely cause?

    1. KNIME crashed
    2. An upstream column was renamed or removed
    3. Out of memory
    4. The file moved

    Answer: An upstream column was renamed or removed — Hover for the specific message.

  3. Postcodes lose their leading zeros. Fix:

    1. Change the delimiter
    2. Set the column type to String in the reader
    3. Use Excel Reader
    4. Increase memory

    Answer: Set the column type to String in the reader — Type guessing reads it as a number.

  4. 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.

  5. 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.

  6. 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.

  7. To build a LEFT JOIN in the Joiner, include:

    1. Matching rows only
    2. Matching rows and left unmatched
    3. All three outputs
    4. Right unmatched only

    Answer: Matching rows and left unmatched — Left unmatched are the rows with no partner.

  8. Concatenating two tables fails on duplicate row keys. Fix:

    1. Rename columns
    2. Let the node append a suffix or generate new RowIDs
    3. Use the Joiner
    4. Sort first

    Answer: Let the node append a suffix or generate new RowIDs — KNIME requires unique RowIDs.

  9. Which node gives a running total?

    1. GroupBy
    2. Moving Aggregation after a Sorter
    3. Pivoting
    4. Column Appender

    Answer: Moving Aggregation after a Sorter — It depends on row order, so sort first.

  10. Which is reusable across workflows and can expose its own settings?

    1. Metanode
    2. Component
    3. Annotation
    4. Workflow group

    Answer: Component — Metanodes are purely organisational.

  11. Which node gives a per-column profile with missing counts and distributions?

    1. Statistics only
    2. Data Explorer
    3. Table View
    4. GroupBy

    Answer: Data Explorer — The equivalent of df.info() plus df.describe().

  12. Why reset a workflow before exporting?

    1. It is required
    2. It strips cached data, shrinking the file and avoiding sending data
    3. It fixes errors
    4. It updates nodes

    Answer: It strips cached data, shrinking the file and avoiding sending data — Exported workflows otherwise carry their cached tables.