pbPassingBI
/
knime/exams/knime-exam-practice

KNIME practice exam

Fifteen questions across nodes, manipulation, transformation and deployment.

  1. A yellow node means:

    1. Not configured
    2. Configured but not executed
    3. Executed
    4. Failed

    Answer: Configured but not executed — Green means executed.

  2. A working node turned red. Most likely:

    1. Out of memory
    2. An upstream column was renamed
    3. A crash
    4. File moved

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

  3. Reconfiguring a node:

    1. Affects only that node
    2. Resets it and everything downstream
    3. Re-runs the workflow
    4. Does nothing until saved

    Answer: Resets it and everything downstream — Downstream inputs may differ.

  4. Leading zeros disappear from an ID column because:

    1. Bad delimiter
    2. Type guessing read it as a number
    3. Encoding
    4. Row limit

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

  5. Which node shows excluded rows?

    1. Row Filter
    2. Row Splitter
    3. Column Filter
    4. Joiner

    Answer: Row Splitter — Two output ports.

  6. Correct Rule Engine ordering is:

    1. > 100 then > 1000
    2. > 1000 then > 100
    3. Any order
    4. Alphabetical

    Answer: > 1000 then > 100 — Most specific first, or the broad rule catches everything.

  7. Rows matching no rule get:

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

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

  8. To build a LEFT JOIN, include:

    1. Matching only
    2. Matching plus left unmatched
    3. All three
    4. Right unmatched only

    Answer: Matching plus left unmatched — Left unmatched are the unpartnered rows.

  9. Joiner output exceeds the left row count because:

    1. A bug
    2. Duplicate keys on the right
    3. Missing values
    4. Wrong types

    Answer: Duplicate keys on the right — GroupBy the right branch first.

  10. Downstream nodes cannot find "Revenue" after GroupBy because:

    1. It was dropped
    2. It was renamed to Sum(Revenue)
    3. Type changed
    4. It became a RowID

    Answer: It was renamed to Sum(Revenue) — Set naming to keep original names.

  11. Concatenate fails on duplicate row keys. Fix:

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

    Answer: Append a suffix or generate new RowIDs — RowIDs must be unique.

  12. Column Appender matches rows by:

    1. A key column
    2. Row position
    3. RowID only
    4. Alphabetically

    Answer: Row position — Silent misalignment if the tables are not parallel.

  13. Which converts month columns into rows?

    1. Pivoting
    2. Unpivoting
    3. GroupBy
    4. Concatenate

    Answer: Unpivoting — Wide to long.

  14. A component differs from a metanode because it:

    1. Runs faster
    2. Has its own scope and is reusable with exposed settings
    3. Cannot be opened
    4. Only holds one node

    Answer: Has its own scope and is reusable with exposed settings — Metanodes are organisational.

  15. The free way to schedule a workflow:

    1. Business Hub
    2. The batch executor via cron or Task Scheduler
    3. Manual execution
    4. Flow variables

    Answer: The batch executor via cron or Task Scheduler — Business Hub is commercial.