I85PREP
⌘ K
Alteryx Designer Expert study materials
Alteryx Designer Expert study resources

Alteryx Designer Expert practice questions

One question at a time. Build your Alteryx Designer Expert understanding.

First 50 of 200 questions. Each one lists the choices, the correct answer, and an explanation. The checker at the top of this page saves progress in this browser when it is available.

Continue in the practice tool above to load more questions, 50 at a time.

Question 1Data Preparation and Blending

In Alteryx Designer, which tool is used to combine two inputs that have different fields by stacking their records and matching fields by name?

  1. Append Fields tool
  2. Union tool Correct answer.
  3. Join tool
  4. Fuzzy Match tool

Explanation

The Union tool stacks records from multiple inputs and aligns fields by name or by position. The Join tool combines fields side by side based on matching key values.

Question 2Data Preparation and Blending

A user wants to add a sequential record number to a dataset. Which tool accomplishes this?

  1. Select tool
  2. Sort tool
  3. Sample tool
  4. Record ID tool Correct answer.

Explanation

The Record ID tool generates a sequential numeric identifier for each record. The Sort tool only reorders records without adding identifiers.

Question 3Data Preparation and Blending

Which tool should be used to split a single field containing full names like 'Smith, John' into separate last and first name fields?

  1. Multi-Row Formula tool
  2. Text to Columns tool Correct answer.
  3. Data Cleansing tool
  4. Formula tool

Explanation

The Text to Columns tool splits one field into multiple fields based on a delimiter such as a comma. The Formula tool cannot natively split a field into separate columns.

Question 4Data Preparation and Blending

A user wants to keep only records where the field 'Region' equals 'West'. Which tool is most appropriate?

  1. Summarize tool
  2. Sort tool
  3. Sample tool
  4. Filter tool Correct answer.

Explanation

The Filter tool routes records into True and False outputs based on an expression, keeping matching records on the True output. The Sample tool selects records by position or percentage, not by condition.

Question 5Data Preparation and Blending

Which tool is designed to identify and merge records that are similar but not exactly identical, such as 'Acme Inc.' and 'Acme Incorporated'?

  1. Join tool
  2. Fuzzy Match tool Correct answer.
  3. Find Replace tool
  4. Union tool

Explanation

The Fuzzy Match tool uses match keys and algorithms to group records that are similar rather than exactly equal. The Join tool requires exact key matches by default.

Question 6Data Preparation and Blending

What is the primary purpose of the Select tool?

  1. To join two datasets on a common key
  2. To aggregate records into summary totals
  3. To generate random sample records
  4. To change field names, types, and order and to include or exclude fields Correct answer.

Explanation

The Select tool manages field metadata, allowing renaming, type changes, reordering, and inclusion or exclusion. It does not perform joins, aggregation, or sampling.

Question 7Data Preparation and Blending

Which tool would you use to replace null values in a field with a default value?

  1. Imputation tool
  2. Tile tool
  3. Formula tool Correct answer.
  4. Data Cleansing tool

Explanation

A Formula tool expression such as IF IsNull([Field]) THEN 'Default' ELSE [Field] ENDIF replaces nulls with a default. The Data Cleansing tool can remove null rows but does not substitute arbitrary defaults.

Question 8Data Preparation and Blending

Which tool combines two inputs by adding all fields from one input to every record of the other without a join key?

  1. Fuzzy Match tool
  2. Join tool
  3. Union tool
  4. Append Fields tool Correct answer.

Explanation

The Append Fields tool performs a cross join, adding every field from the source to each record of the target. The Join tool requires matching keys.

Question 9Data Preparation and Blending

A dataset has a date field stored as text in 'YYYY-MM-DD' format. Which approach converts it to a proper Date type?

  1. Use a Sort tool on the field
  2. Use a DateTimeParse function in a Formula tool Correct answer.
  3. Use a Summarize tool with Count
  4. Use a Record ID tool

Explanation

The DateTimeParse function converts a text string into a date/time value given a format string. Changing the field type alone without parsing can produce nulls if the format is not recognized.

Question 10Data Preparation and Blending

In the Join tool, what does the 'J' output anchor contain?

  1. Records that matched on the join key Correct answer.
  2. Records from the right input that did not match
  3. Records that were duplicated in either input
  4. Records from the left input that did not match

Explanation

The Join tool has three outputs: L (left unmatched), R (right unmatched), and J (joined matches). The J anchor holds records where the key matched in both inputs.

Question 11Data Preparation and Blending

A user needs to calculate a running total of a numeric field across records in their current sort order. Which tool is most appropriate?

  1. Cross Tab tool
  2. Summarize tool
  3. Transpose tool
  4. Multi-Row Formula tool Correct answer.

Explanation

The Multi-Row Formula tool can reference the previous row to compute a running total, such as [Row-1:RunningTotal] + [Value]. The Summarize tool produces independent aggregates, not running totals.

Question 12Data Preparation and Blending

Which tool pivots data from a wide format (many columns) into a tall format (key-value rows)?

  1. Summarize tool
  2. Join tool
  3. Transpose tool Correct answer.
  4. Cross Tab tool

Explanation

The Transpose tool converts columns into rows, producing Name and Value fields. The Cross Tab tool does the opposite, pivoting rows into columns.

Question 13Data Preparation and Blending

A user wants to group records by 'Category' and compute the total 'Sales' per group. Which tool should be used?

  1. Sample tool
  2. Filter tool
  3. Summarize tool Correct answer.
  4. Sort tool

Explanation

The Summarize tool groups records by selected fields and applies aggregations such as Sum on other fields. The Sort tool only reorders records.

Question 14Data Preparation and Blending

What does the Data Cleansing tool do with leading and trailing whitespace by default?

  1. It leaves whitespace unchanged
  2. It replaces whitespace with nulls
  3. It trims the whitespace from string fields Correct answer.
  4. It converts whitespace to tabs

Explanation

The Data Cleansing tool trims leading and trailing whitespace from string fields when the option is enabled. It does not replace whitespace with nulls or tabs.

Question 15Data Preparation and Blending

Which tool should be used to replace specific text values in a field using a lookup table of old and new values?

  1. Filter tool
  2. Find Replace tool Correct answer.
  3. Formula tool
  4. Union tool

Explanation

The Find Replace tool uses a lookup input to find values and replace them with corresponding new values. The Formula tool replaces values only via explicit expressions, not a lookup table.

Question 16Data Preparation and Blending

A user wants to assign each record to one of five equal-sized buckets based on a numeric field. Which tool accomplishes this?

  1. Sample tool
  2. Tile tool Correct answer.
  3. Sort tool
  4. Record ID tool

Explanation

The Tile tool can create equal-sized tiles (buckets) based on a numeric field. The Sample tool selects records rather than assigning bucket numbers.

Question 17Data Preparation and Blending

Which tool configuration allows a Join to match records case-insensitively?

  1. Change the join key field type to V_String
  2. Select the 'Case Insensitive' option in the Join tool configuration Correct answer.
  3. Use a Sort tool before the Join
  4. Use a Record ID tool before the Join

Explanation

The Join tool provides a case-insensitive matching option in its configuration. Changing the field type does not affect case sensitivity of comparisons.

Question 18Data Preparation and Blending

A user needs to concatenate multiple rows of a field into a single comma-separated string within each group. Which Summarize aggregation supports this?

  1. First
  2. Count
  3. Sum
  4. Concatenate Correct answer.

Explanation

The Concatenate aggregation in the Summarize tool joins values from multiple rows into a single string, optionally with a separator. Count and Sum return numeric results, not combined strings.

Question 19Data Preparation and Blending

Which tool is used to detect and optionally remove duplicate records based on selected key fields?

  1. Filter tool
  2. Unique tool Correct answer.
  3. Sample tool
  4. Sort tool

Explanation

The Unique tool identifies duplicates based on selected key fields and splits records into Unique and Duplicate outputs. The Sort tool reorders records but does not flag duplicates.

Question 20Data Preparation and Blending

A user wants to parse a JSON field into separate columns. Which tool is designed for this?

  1. JSON Parse tool Correct answer.
  2. Formula tool
  3. Cross Tab tool
  4. Text to Columns tool

Explanation

The JSON Parse tool converts JSON strings into a structured table of fields. The Text to Columns tool splits on delimiters but does not interpret JSON structure.

Question 21Data Preparation and Blending

In a Union tool configured to match fields 'by name', what happens to a field that exists in one input but not the other?

  1. The field is renamed automatically
  2. The Union tool errors out
  3. The field is dropped from the output
  4. The field is included and populated with nulls for records from the input that lacks it Correct answer.

Explanation

When matching by name, the Union tool includes all fields across inputs and fills nulls where a record's source lacks that field. It does not drop the field or error.

Question 22Data Preparation and Blending

A user needs to join two datasets but expects multiple matches on the right side for each left record. Which behavior should they anticipate from the Join tool?

  1. Each left record is duplicated for every matching right record Correct answer.
  2. Matches are averaged into one record
  3. The Join tool errors when multiple matches exist
  4. Only the first match is kept

Explanation

The Join tool outputs one record per matching pair, so a left record with multiple right matches produces multiple output rows. This is standard relational join behavior.

Question 23Data Preparation and Blending

A user applies a Sort tool followed by a Sample tool set to 'First N records'. What is the significance of the Sort order?

  1. The Sample tool randomizes records regardless of order
  2. The Sample tool always sorts ascending before sampling
  3. The Sample tool selects records according to the incoming sort order Correct answer.
  4. The Sort order has no effect on which records are sampled

Explanation

The Sample tool operates on records in their incoming order, so a preceding Sort determines which records are selected as the first N. Without sorting, the selection order is not guaranteed.

Question 24Data Preparation and Blending

A workflow uses a Join tool and the right input contains duplicate keys. How can a user keep only one right-side match per left record?

  1. Add a Record ID tool before the Join
  2. Add a Filter tool after the Join
  3. Add a Unique tool on the right input keyed on the join field before the Join Correct answer.
  4. Add a Sort tool after the Join

Explanation

Applying a Unique tool to the right input before the Join removes duplicate keys so each left record matches at most one right record. Post-join tools would not prevent the row multiplication.

Question 25Data Preparation and Blending

A user wants to compute the difference between the current row's value and the value two rows earlier. Which tool and configuration supports this?

  1. Summarize tool with a Sum aggregation
  2. Formula tool referencing [Value] only
  3. Cross Tab tool with a Sum aggregation
  4. Multi-Row Formula tool referencing [Row-2:Value] Correct answer.

Explanation

The Multi-Row Formula tool can reference rows offset from the current one, such as [Row-2:Value], enabling comparisons across multiple prior rows. The Formula tool can only reference the current row.

Question 26Data Preparation and Blending

In the Formula tool, which function returns the number of characters in a string field?

  1. Length Correct answer.
  2. Size
  3. Count
  4. Chars

Explanation

The Length function returns the character count of a string value. Count aggregates records and Size/Chars are not string-length functions in the expression editor.

Question 27Data Preparation and Blending

A user wants to append the value of a second input to every record of the first input with no join key. Which Join configuration produces this?

  1. Join on a constant field added to both inputs
  2. Join with the 'Join by Record Position' option enabled
  3. Join using a Record ID field created in both streams
  4. Join with no key fields selected and Cartesian mode active Correct answer.

Explanation

A Join tool with no key fields configured performs a Cartesian (many-to-many) match, pairing every left record with every right record. Adding a constant or Record ID key would create a keyed match rather than a true keyless append.

Question 28Data Preparation and Blending

Which tool should be used to split a single delimited string field into multiple separate fields?

  1. Text to Columns Correct answer.
  2. Field Info
  3. RegEx
  4. Multi-Field Formula

Explanation

The Text to Columns tool splits one string field into several fields using a specified delimiter. RegEx parses or replaces patterns but is not the dedicated splitter for delimited fields.

Question 29Data Preparation and Blending

A user needs to combine two inputs that have different schemas into a single stream while keeping all fields, filling missing fields with nulls. Which tool and configuration accomplishes this?

  1. Join tool with the 'J' output only
  2. Find Replace tool with append mode
  3. Append Fields tool with all fields selected
  4. Union tool set to 'Auto Configure by Name' Correct answer.

Explanation

The Union tool stacks inputs and, when configured by name, keeps fields from both inputs and fills missing values with nulls. Join and Append Fields combine columns rather than stacking records.

Question 30Data Preparation and Blending

Which tool is designed to output a specified number of randomly selected records from an input stream?

  1. Tile
  2. Select Records
  3. Sample Correct answer.
  4. Random Record

Explanation

The Sample tool can return a random percentage or a fixed number of randomly chosen records. Tile assigns records to groups and Select Records picks by record number, neither of which randomizes selection.

Question 31Data Preparation and Blending

A user wants to add a field that returns the row number of each record in the current data stream. Which tool configuration provides this?

  1. Record ID tool with a starting value of 1 Correct answer.
  2. Formula tool using the RowCount() function
  3. Multi-Row Formula with 'Output Row Number' enabled
  4. Sort tool with a numeric rank field

Explanation

The Record ID tool adds a sequential identifier field beginning at a configurable start value. RowCount() returns the total record count, not a per-row index.

Question 32Data Preparation and Blending

A numeric field contains values stored as text with thousands separators, such as '1,234.50'. Which approach converts these to numeric values correctly?

  1. Apply the Data Cleansing tool with 'Modify Case' enabled
  2. Use ToNumber() directly on the field
  3. Change the field type to Double in a Select tool
  4. Remove commas with a Replace function, then convert with ToNumber() Correct answer.

Explanation

ToNumber() fails on strings containing thousands separators, so the commas must be stripped first with Replace before conversion. Changing the field type alone does not resolve the embedded separator characters.

Question 33Data Preparation and Blending

Which tool allows a user to rename, reorder, retype, and deselect fields in a single interface?

  1. Field Info
  2. Auto Field
  3. Select Correct answer.
  4. Formula

Explanation

The Select tool provides a grid for renaming fields, changing types, reordering columns, and checking or unchecking fields to keep. Auto Field changes types automatically but does not rename or reorder.

Question 34Data Preparation and Blending

A user wants to create a new field whose value depends on the value of the same field in the previous row, such as a flag when sales increase from the prior record. Which tool is appropriate?

  1. Multi-Row Formula Correct answer.
  2. Cross Tab
  3. Running Total
  4. Summarize

Explanation

The Multi-Row Formula tool can reference values from the previous or next rows to compute row-relative logic. Summarize aggregates groups and Running Total accumulates values without comparing adjacent rows.

Question 35Data Preparation and Blending

A user needs to transpose a dataset so that distinct values in a 'Month' field become separate columns, with 'Sales' values populating them. Which tool accomplishes this?

  1. Cross Tab Correct answer.
  2. Summarize
  3. Transpose
  4. Text to Columns

Explanation

The Cross Tab tool pivots rows into columns, using one field for new column headers and another for the values. Transpose performs the opposite operation, converting columns into rows.

Question 36Data Preparation and Blending

A user wants to keep only records where the 'Status' field equals 'Active' before further processing. Which tool is the most direct choice?

  1. Sample
  2. Join to a status list
  3. Formula with an IF statement
  4. Filter Correct answer.

Explanation

The Filter tool splits the stream into True and False outputs based on a condition, keeping only matching records on the True anchor. A Formula creates values but does not route records to separate outputs.

Question 37Data Preparation and Blending

A user needs to replace all occurrences of a pattern such as any non-digit character within a string field. Which tool and approach is best suited?

  1. Data Cleansing with 'Remove Nulls' enabled
  2. Formula tool using REGEX_Replace Correct answer.
  3. Text to Columns with a custom delimiter
  4. Find Replace in Append mode

Explanation

REGEX_Replace in the Formula tool substitutes all matches of a regular expression pattern within a string. Text to Columns splits rather than substitutes, and Find Replace works on literal lookup values.

Question 38Data Preparation and Blending

A workflow must combine two inputs on a key where the left input has multiple matching records per key and the right input also has multiple matching records per key, and every combination must be retained. Which tool is appropriate?

  1. Join Multiple
  2. Union
  3. Append Fields
  4. Join Correct answer.

Explanation

The Join tool produces a many-to-many match on the 'J' anchor when duplicate keys exist on both sides, retaining every pairing. Append Fields and Union do not match on a key.

Question 39Data Preparation and Blending

A user applies a Sort tool on 'Date' ascending and then a Multi-Row Formula comparing each row to the prior row. What determines which record is treated as the prior row?

  1. The original input record order
  2. The alphabetical order of the key field
  3. The order produced by the preceding Sort tool Correct answer.
  4. The order of fields in the Select tool

Explanation

Multi-Row Formula references adjacent rows in the order the data arrives, so a preceding Sort tool establishes which record is the prior row. Input order and field order do not override the sorted sequence.

Question 40Data Preparation and Blending

A user wants to add the same constant value to a new field for every record in the stream. Which approach is most efficient?

  1. Join to a one-row lookup table containing the value
  2. Union with a one-row input
  3. Formula tool creating a field with a literal value Correct answer.
  4. Append Fields with a one-row input

Explanation

A Formula tool assigning a literal creates the field for all records in a single step. Joining or appending to a one-row input adds unnecessary tools and processing overhead.

Question 41Parsing, Transforming, and Formula Tools

In the Formula tool, which function returns the number of characters in a string field named [Name]?

  1. Size([Name])
  2. Count([Name])
  3. Length([Name]) Correct answer.
  4. Chars([Name])

Explanation

The Length function returns the character count of a string. Count is an aggregate used in the Summarize tool, not a string function. Size and Chars are not Alteryx string functions.

Question 42Parsing, Transforming, and Formula Tools

Which Formula tool expression extracts the first three characters of the field [Code]?

  1. Substring([Code], 1, 3)
  2. First([Code], 3)
  3. Substr([Code], 3)
  4. Left([Code], 3) Correct answer.

Explanation

Left(string, n) returns the leftmost n characters. Substring uses a zero-based start position, so Substring([Code],1,3) would skip the first character. First and Substr are not Alteryx functions.

Question 43Parsing, Transforming, and Formula Tools

A user wants to remove leading and trailing spaces from [Text] while preserving internal spaces. Which expression achieves this?

  1. Strip([Text])
  2. Clean([Text])
  3. Trim([Text]) Correct answer.
  4. Replace([Text], " ", "")

Explanation

Trim removes leading and trailing whitespace only. Replace with an empty string would delete every space, including internal ones. Clean removes non-printable characters rather than trimming spaces.

Question 44Parsing, Transforming, and Formula Tools

Which function converts the string field [Amount] to a numeric value in the Formula tool?

  1. Num([Amount])
  2. ToNumber([Amount]) Correct answer.
  3. Value([Amount])
  4. Int([Amount])

Explanation

ToNumber converts a string to a numeric type. Int truncates a numeric value to an integer but does not parse strings. Num and Value are not Alteryx conversion functions.

Question 45Parsing, Transforming, and Formula Tools

In the Formula tool, what does the IIF function return?

  1. The first non-null value among its arguments
  2. A value chosen between two options based on a boolean condition Correct answer.
  3. The index of a matching substring
  4. The integer portion of a numeric expression

Explanation

IIF(condition, trueValue, falseValue) evaluates a boolean and returns one of two results. It is Alteryx's conditional selection function. It does not handle nulls or substring indexing.

Question 46Parsing, Transforming, and Formula Tools

Which function joins multiple string values end to end in the Formula tool?

  1. Concat(a, b) Correct answer.
  2. Plus(a, b)
  3. Merge(a, b)
  4. Append(a, b)

Explanation

Concat concatenates its arguments into a single string. The + operator also concatenates strings in Alteryx, but Plus is not a function. Append and Merge are not string functions.

Question 47Parsing, Transforming, and Formula Tools

In the Text to Columns tool, what does the Split to Rows option do?

  1. It creates one output field per split segment
  2. It creates one output record per split segment Correct answer.
  3. It removes duplicate split segments
  4. It concatenates all split segments

Explanation

Split to Rows produces a new record for each delimited segment, keeping other fields repeated. Split to Columns instead creates separate fields. The option does not deduplicate or concatenate.

Question 48Parsing, Transforming, and Formula Tools

Which tool is designed to parse a single string field into multiple new fields using a delimiter or fixed width?

  1. Formula
  2. Text to Columns Correct answer.
  3. Multi-Row Formula
  4. RegEx

Explanation

Text to Columns splits one field into multiple fields or records based on a delimiter or fixed width. RegEx matches patterns but does not natively output multiple new fields. Formula and Multi-Row Formula do not split fields into multiple columns.

Question 49Parsing, Transforming, and Formula Tools

A user needs to replace every occurrence of "Ltd" with "Limited" in [Company]. Which expression is correct?

  1. ReplaceFirst([Company], "Ltd", "Limited")
  2. Substitute([Company], "Ltd")
  3. Replace([Company], "Limited", "Ltd")
  4. Replace([Company], "Ltd", "Limited") Correct answer.

Explanation

Replace(string, target, replacement) swaps all occurrences of the target with the replacement. The argument order matters, so the target must come before the replacement. ReplaceFirst and Substitute are not Alteryx functions.

Question 50Parsing, Transforming, and Formula Tools

Which expression returns the position of the first occurrence of "@" in [Email]?

  1. FindString([Email], "@") Correct answer.
  2. Locate([Email], "@")
  3. Position([Email], "@")
  4. IndexOf([Email], "@")

Explanation

FindString(string, target) returns the zero-based position of the first match, or -1 if not found. Position, IndexOf, and Locate are not Alteryx functions.