pbPassingBI
/
tableau prep/exams/prep-exam-practice

Tableau Prep practice exam

Fifteen questions across flows, cleaning, reshaping and outputs.

  1. The profile pane shows:

    1. The flow steps
    2. Value distributions and nulls per field
    3. The output path
    4. Run history

    Answer: Value distributions and nulls per field — Data quality at a glance.

  2. While building a flow, Prep works on:

    1. All data
    2. A sample
    3. Metadata only
    4. The first file

    Answer: A sample — Rare values may not appear until you run it.

  3. The join step row count exceeds the left input. This means:

    1. Normal
    2. A fan-out from duplicate right-side keys
    3. Rows were lost
    4. Wrong output type

    Answer: A fan-out from duplicate right-side keys — Aggregate the right branch by the key first.

  4. To see which join values failed to match:

    1. Run the flow
    2. Click the unmatched section of the join summary
    3. Check the output
    4. Add a clean step

    Answer: Click the unmatched section of the join summary — The profile pane then shows them.

  5. Best grouping method for "Smith" and "Smyth":

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

    Answer: Pronunciation — Values that sound alike.

  6. The main risk of automatic grouping is:

    1. Slowness
    2. Merging genuinely different values
    3. It cannot be undone
    4. It only handles numbers

    Answer: Merging genuinely different values — Review the proposed groups before applying.

  7. Splitting full names with optional middle names — split from:

    1. The left
    2. The right
    3. The middle
    4. Automatic only

    Answer: The right — The surname is reliably last.

  8. Which is unsupported in Prep?

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

    Answer: Table calculations — They require view context.

  9. A new month column appears each month. Use:

    1. A manual pivot
    2. A wildcard pivot
    3. A union
    4. An aggregate step

    Answer: A wildcard pivot — It matches columns that do not exist yet.

  10. For data Tableau will analyse, pivot:

    1. Rows to columns
    2. Columns to rows
    3. Neither
    4. Both

    Answer: Columns to rows — Long form gives one dimension and one measure.

  11. An aggregate step differs from a FIXED LOD because it:

    1. Is faster
    2. Changes the grain, removing detail rows
    3. Works on text only
    4. Requires a join

    Answer: Changes the grain, removing detail rows — FIXED keeps every row.

  12. The cheapest place to filter is:

    1. The output
    2. The input step
    3. A clean step
    4. An aggregate step

    Answer: The input step — Rows never enter the flow.

  13. Your output doubled on rerun because:

    1. A fan-out
    2. The write option was Append
    3. Sampling
    4. Wrong join

    Answer: The write option was Append — Use create/replace.

  14. Scheduling flows on Server requires:

    1. Nothing extra
    2. Prep Conductor or the command line
    3. Desktop
    4. A .hyper output

    Answer: Prep Conductor or the command line — Conductor is the licensed option.

  15. Incremental refresh does not capture:

    1. New rows
    2. Rows updated or deleted after loading
    3. Large files
    4. Text fields

    Answer: Rows updated or deleted after loading — Hence a periodic full refresh.