Alteryx full mock exam

How do you see the data mid-workflow?

1. Run and export
2. Click the connection between two tools
3. Open the source file
4. Add a Browse tool only

Answer: Click the connection between two tools — Any connection shows a preview and record count.

Which is the most important thing to check after a Join?

1. Field order
2. The record count
3. Colours
4. Tool position

Answer: The record count — A changed record count is the usual sign of a fan-out or lost rows.

Your workflow duplicated all its data on the second run. Cause?

1. A Join issue
2. Output set to Append to existing
3. Wrong delimiter
4. A Browse tool

Answer: Output set to Append to existing — Use delete-and-append or overwrite when reruns are possible.

Which type should hold a currency amount?

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

Answer: Fixed Decimal — Floating point accumulates rounding error across many rows.

[Revenue] - [Discount] returns null on some rows because:

1. Wrong type
2. Discount is null on those rows
3. The field is too small
4. Formula order

Answer: Discount is null on those rows — Guard with IsNull or use Data Cleansing.

Why attach a Browse to the Filter F output?

1. To improve speed
2. To see what was excluded and verify the condition
3. It is required
4. To sort the data

Answer: To see what was excluded and verify the condition — Silent over-filtering is a common defect.

Which anchor holds rows that matched on both sides?

1. L
2. J
3. R
4. All three

Answer: J — J is the inner join result.

Union set to "by position" with differently ordered columns:

1. Errors
2. Silently puts values in the wrong fields
3. Matches by name anyway
4. Drops the file

Answer: Silently puts values in the wrong fields — Use by name unless you have a specific reason.

Your Cross Tab columns are in the wrong order because:

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

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

How do you test a workflow without running one branch?

1. Delete the tools
2. Disable the container holding them
3. Add a Filter
4. Comment them out

Answer: Disable the container holding them — Disabling skips everything inside on the next run.

A field holds "widget, bolt, nut" and you need one row each. Use:

1. RegEx Match
2. Text to Columns, split to rows
3. Cross Tab
4. Append Fields

Answer: Text to Columns, split to rows — Splitting to rows is the option people overlook.

To produce one CSV per region in a single run:

1. One workflow per region
2. Take File/Table Name From Field on the Output tool
3. A Union tool
4. A container per region

Answer: Take File/Table Name From Field on the Output tool — The field value becomes the file name.