pbPassingBI
/
tableau prep/exams/tableau-prep-exam-full

Tableau Prep full mock exam

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

  1. What makes the profile pane useful?

    1. It is faster
    2. It shows value distributions and nulls without writing a query
    3. It runs the flow
    4. It connects to Desktop

    Answer: It shows value distributions and nulls without writing a query — Data-quality problems are visible immediately.

  2. The cheapest place to filter rows is:

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

    Answer: The input step — Excluded rows never enter the flow at all.

  3. The join step shows fewer rows than expected. Best first action?

    1. Change join type
    2. Click the unmatched section to see which values failed
    3. Add a clean step
    4. Re-run the flow

    Answer: Click the unmatched section to see which values failed — The unmatched values are usually a formatting difference.

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

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

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

  7. A new month column appears in the source each month. Use:

    1. A manual pivot, updated monthly
    2. A wildcard pivot
    3. A union
    4. A join

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

  8. 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 rather than many measures.

  9. To prevent a join multiplying rows, add an aggregate step:

    1. After the join
    2. On the many side before the join
    3. At the output
    4. On the one side

    Answer: On the many side before the join — Grouping by the join key gives one row per key.

  10. Which output gives a team one shared refreshed source?

    1. CSV
    2. Published data source
    3. .hyper on a shared drive
    4. Excel

    Answer: Published data source — Every workbook connecting to it gets the refresh.

  11. Your output table doubled after the second run. Cause?

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

    Answer: The write option was set to Append — Use create/replace unless the flow only handles new rows.

  12. Which is needed to schedule flows on Server?

    1. Nothing extra
    2. Prep Conductor
    3. Desktop
    4. A published data source

    Answer: Prep Conductor — Or drive the command line from an external scheduler.