pbPassingBI
/
tableau prep/quizzes/tableau-prep-quiz-clean
6 questions

Cleaning & transforming — quiz

6 questions covering this module. Clean steps, grouping values, splitting fields and calculations.

  1. Where does Prep record what a clean step does?

    1. The flow pane
    2. The Changes panel
    3. The data grid
    4. The output step

    Answer: The Changes panel — Each entry can be edited or removed individually.

  2. A join finds no matches on values that look identical. Likely fix:

    1. Change join type
    2. Trim spaces and normalise case on the key
    3. Add a pivot
    4. Increase the sample

    Answer: Trim spaces and normalise case on the key — Whitespace is invisible in the data grid.

  3. Which method best groups "Houston, TX" with "TX Houston"?

    1. Pronunciation
    2. Common Characters
    3. Spelling
    4. Manual

    Answer: Common Characters — It ignores order and punctuation.

  4. The risk of automatic grouping is:

    1. It is slow
    2. It merges values that are genuinely different
    3. It cannot be undone
    4. It only works on text

    Answer: It merges values that are genuinely different — An incorrect merge disappears silently; a missed one stays visible.

  5. Splitting full names where middle names sometimes appear — split from:

    1. The left
    2. The right
    3. Either
    4. Use automatic split

    Answer: The right — The last token is reliably the surname.

  6. Which is NOT supported in Prep?

    1. FIXED LOD expressions
    2. Table calculations
    3. IF/THEN logic
    4. DATEDIFF

    Answer: Table calculations — Table calculations need view context, so they belong in Desktop.