pbPassingBI
/
alteryx/exams/alteryx-exam-practice

Alteryx practice exam

Fifteen questions across tools, blending, reshaping and workflow design.

  1. The J anchor of the Join tool contains:

    1. Unmatched left rows
    2. Matched rows
    3. Unmatched right rows
    4. All rows

    Answer: Matched rows — J is the inner join result.

  2. To reproduce a SQL LEFT JOIN:

    1. Use J only
    2. Union J and L
    3. Union J and R
    4. Use Join Multiple

    Answer: Union J and L — L holds the unmatched left rows.

  3. J returns more rows than the left input had. Cause?

    1. Normal
    2. Duplicate keys on the right side
    3. Lost rows
    4. Wrong type

    Answer: Duplicate keys on the right side — Summarize the right input first.

  4. A field disappeared after Summarize because:

    1. It was null
    2. It was neither grouped nor aggregated
    3. Wrong data type
    4. It was truncated

    Answer: It was neither grouped nor aggregated — Use First if you need it to survive.

  5. Which unpivots month columns into rows?

    1. Cross Tab
    2. Transpose
    3. Union
    4. Summarize

    Answer: Transpose — Transpose is the unpivot.

  6. Cross Tab columns come out in the wrong order because:

    1. A bug
    2. It sorts new columns alphabetically
    3. Missing Sort tool
    4. Wrong aggregation

    Answer: It sorts new columns alphabetically — Prefix with a number before pivoting.

  7. Union "by position" with mismatched column order:

    1. Errors
    2. Silently misaligns values
    3. Matches by name
    4. Skips the file

    Answer: Silently misaligns values — Always prefer by name.

  8. Append Fields with 10 target and 5 source rows gives:

    1. 10
    2. 15
    3. 50
    4. 5

    Answer: 50 — A Cartesian product.

  9. Money should be stored as:

    1. Double
    2. Fixed Decimal
    3. Float
    4. V_String

    Answer: Fixed Decimal — Exact decimal storage avoids accumulating error.

  10. Shortening a V_String from 255 to 50 causes:

    1. An error
    2. Silent truncation
    3. Nulls
    4. Auto-resize

    Answer: Silent truncation — Check warnings after type changes.

  11. A running total requires:

    1. Summarize
    2. Multi-Row Formula after a Sort
    3. Cross Tab
    4. Join

    Answer: Multi-Row Formula after a Sort — It depends on row order.

  12. Your workflow duplicated data on the second run because:

    1. A fan-out
    2. The Output tool appends to existing
    3. Union by position
    4. A Browse tool

    Answer: The Output tool appends to existing — Use overwrite or delete-and-append.

  13. To read twelve identically structured CSVs:

    1. Twelve Input tools
    2. A wildcard in the input path
    3. Append Fields
    4. Cross Tab

    Answer: A wildcard in the input path — Output File Name as Field records the source.

  14. To skip part of a workflow while testing:

    1. Delete the tools
    2. Disable the container
    3. Add a Filter
    4. Rename them

    Answer: Disable the container — Nothing is lost, and it is one click to restore.

  15. A join fails on values that look identical. Most likely:

    1. Wrong anchor
    2. Whitespace or case differences in the key
    3. Too many rows
    4. Missing Browse

    Answer: Whitespace or case differences in the key — Run Data Cleansing on the key first.