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

Alteryx Designer Core practice questions

One question at a time. Build your Alteryx Designer Core 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 Input/Output

Which tool is used to read an existing file from disk, such as a CSV or Excel workbook, into an Alteryx workflow?

  1. Output Data
  2. Text Input
  3. Input Data Correct answer.
  4. Browse

Explanation

The Input Data tool connects a workflow to an external source such as a file, database table, or named connection and brings those records into the data stream. The other tools either write data outward, create data manually, or only display data already in the stream.

Question 2Data Preparation and Input/Output

What is the primary purpose of the Output Data tool?

  1. Writing the incoming stream to a file or database Correct answer.
  2. Reading records from a database table into the stream
  3. Displaying a sample of records in a grid
  4. Changing a text field into a numeric field

Explanation

The Output Data tool takes the records arriving on its input anchor and writes them to a destination such as a file, a database table, or a named connection. It sits at the end of a stream rather than at the beginning.

Question 3Data Preparation and Input/Output

Alteryx has a native file format that stores field names, types, and sizes and is optimized for fast reading inside a workflow. Which extension does it use?

  1. .csv
  2. .yxmd
  3. .yxdb Correct answer.
  4. .yxwz

Explanation

The .yxdb format is Alteryx's own database file format and retains field metadata such as type and size, which makes it fast to read and write between workflows. Plain text formats such as CSV do not store type information.

Question 4Data Preparation and Input/Output

A CSV file has column headers in its very first line. Which Input Data configuration ensures those headers become the field names?

  1. Set the delimiter to \n
  2. Set Skip 1 line to 1
  3. Set Field length to 254
  4. Select the First row contains field names option Correct answer.

Explanation

The Input Data tool has an option that treats the first record of a delimited file as the field names instead of as data. Without it, the header line is read as an ordinary row of values and generic field names are generated.

Question 5Data Preparation and Input/Output

Which tool splits a single delimited text field into several new fields?

  1. Select
  2. Formula
  3. Data Cleansing
  4. Text to Columns Correct answer.

Explanation

The Text to Columns tool takes one string field and divides its content at a specified delimiter, root name, or fixed width, producing multiple fields. It can also split values into separate rows instead of columns.

Question 6Data Preparation and Input/Output

Which tool is used to rename fields, change their data types and sizes, and reorder or deselect them in a single step?

  1. Select Correct answer.
  2. Sample
  3. Data Cleansing
  4. Sort

Explanation

The Select tool is the central place to manage field metadata: it can rename, retype, resize, reorder, and deselect fields, and it offers options such as Select All or deselecting unknown fields.

Question 7Data Preparation and Input/Output

Which tool splits records into two streams, one where a condition is true and one where it is false?

  1. Sample
  2. Unique
  3. Join
  4. Filter Correct answer.

Explanation

The Filter tool evaluates an expression against each record and routes it to the True output or the False output. This makes it the standard way to branch a stream by a condition.

Question 8Data Preparation and Input/Output

Which tool can both trim leading and trailing whitespace from text fields and replace null values in one configuration?

  1. Record ID
  2. Formula
  3. Text to Columns
  4. Data Cleansing Correct answer.

Explanation

The Data Cleansing tool bundles several common cleanup actions, including trimming whitespace, removing unwanted characters, changing case, and replacing nulls with a specified value or blank.

Question 9Data Preparation and Input/Output

A user enters C:\Data\Sales\*.csv into the file path of the Input Data tool. What is the result?

  1. All CSV files in that folder are read and stacked into a single input stream Correct answer.
  2. Only the first CSV file in alphabetical order is read
  3. The tool throws an error because wildcards are not supported
  4. A file literally named *.csv is expected to exist

Explanation

The Input Data tool accepts a wildcard in the filename, which reads every matching file in the folder and stacks the results into one stream. This works best when the files share the same schema.

Question 10Data Preparation and Input/Output

How does the Dynamic Input tool differ from the standard Input Data tool?

  1. It merges files with different schemas into a single standardized table
  2. It writes records to whichever database table is named in a field
  3. It reads a fixed source that is set once when the workflow is built
  4. It reads from a template source and swaps the source using values from an incoming field Correct answer.

Explanation

Dynamic Input is configured once with a template, then the source path, sheet, or query is modified at run time by values arriving on its input anchor. This allows a workflow to read a different source on each run without manual edits.

Question 11Data Preparation and Input/Output

Which tool produces a table listing the files in a folder together with attributes such as size and last modified date?

  1. Input Data
  2. Directory Correct answer.
  3. Dynamic Input
  4. Run Command

Explanation

The Directory tool returns one record per file in a specified folder, including the full path and file attributes. Its output is commonly fed into a batch macro or Dynamic Input so a workflow can process every file it finds.

Question 12Data Preparation and Input/Output

A workflow must write one CSV per region, with the file name coming from a Region field. Which Output Data configuration achieves this?

  1. Select Append to Existing File and rename each output manually
  2. Place a Block Until Done tool before the Output Data tool
  3. Use a Formula tool to build the path and pass it downstream
  4. Select Take File/Table Name From Field and choose the Region field Correct answer.

Explanation

The Output Data tool can derive the destination from a field value, writing a separate file or table for each distinct value and even creating subfolders. Grouping by fields such as Region lets a single tool write many outputs.

Question 13Data Preparation and Input/Output

Which tool lets an analyst type a small table of values directly into a workflow without connecting to an external source?

  1. Append Fields
  2. Generate Rows
  3. Text Input Correct answer.
  4. Input Data

Explanation

The Text Input tool provides a grid in which values are entered manually, and each column's type and size can be set. It is commonly used for lookup tables, parameters, or test data.

Question 14Data Preparation and Input/Output

A CSV exported from a European system shows garbled accented characters after being read. Which Input Data setting most directly addresses this?

  1. Delimiter
  2. Field length
  3. Code page Correct answer.
  4. Record limit

Explanation

Garbled accented characters indicate that the file's character encoding does not match the one used to read it. Setting the code page on the Input Data tool to the encoding used when the file was written resolves the corruption.

Question 15Data Preparation and Input/Output

Two streams are combined with the Union tool set to Auto Config by Name. The first stream has fields A and B, the second has fields A and C. What does the output contain?

  1. Fields A, B, and C merged strictly by column position
  2. An error, because the field sets do not match
  3. Fields A, B, and C, with nulls where a field is absent from an input Correct answer.
  4. Only field A, because it is common to both inputs

Explanation

Union matches fields by name, so the combined output carries every field from every input. Records from the stream lacking a given field receive nulls for it.

Question 16Data Preparation and Input/Output

Which output anchor of the Join tool carries records from the left input that found no match on the right?

  1. L Correct answer.
  2. U
  3. J
  4. R

Explanation

The Join tool has three outputs: J for matched records, L for left records without a match, and R for right records without a match. Unmatched left records therefore leave through the L anchor.

Question 17Data Preparation and Input/Output

A field arrives as text containing numeric characters, such as 0042, and must be treated as a number downstream. Which approach converts it?

  1. Use a Formula expression that wraps the field in Trim()
  2. Use the Sort tool and choose numeric sort order
  3. Use Text to Columns with a numeric split mode
  4. Use the Select tool and set the field type to a numeric type Correct answer.

Explanation

Changing a field's type to a numeric type in the Select tool converts the stored values to numbers so that math and numeric comparisons work. Text fields that look numeric are still handled as text until converted.

Question 18Data Preparation and Input/Output

Which tool outputs the first record for each distinct combination of selected key fields and sends the remaining records to a separate anchor?

  1. Summarize
  2. Unique Correct answer.
  3. Sort
  4. Sample

Explanation

The Unique tool compares the chosen key fields across records, passes the first occurrence of each distinct combination to the U anchor, and routes repeats to the D anchor. Which record counts as first depends on the order of the incoming stream.

Question 19Data Preparation and Input/Output

Which tool replaces null values in a numeric field with the field mean, median, or a specified constant?

  1. Multi-Row Formula
  2. Data Cleansing
  3. Imputation Correct answer.
  4. Formula

Explanation

The Imputation tool is built for filling missing values and can apply a fixed replacement or a statistic such as the mean or median of the non-null values in that field. It can also be configured per field.

Question 20Data Preparation and Input/Output

A Multi-Row Formula must compute a running total that restarts for every customer. Which configuration produces this behavior?

  1. Set the Group By option to the customer field Correct answer.
  2. Set Num Rows to 1 and leave grouping empty
  3. Enable the option to output the value as a new field
  4. Sort the data by customer before the tool runs

Explanation

Group By tells the Multi-Row Formula to treat each distinct value of the selected field as a separate stream, so row references and running values start fresh within each group. Sorting alone does not create these boundaries.

Question 21Data Preparation and Input/Output

Which tool adds every field of a second stream to every record of the first stream?

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

Explanation

The Append Fields tool pairs each record of the source stream with each record of the target stream, adding the target's fields horizontally. This is effectively a Cartesian product, so record counts multiply.

Question 22Data Preparation and Input/Output

A text field holds dates formatted as 2024-03-15 and must become a true Date type so date functions work. Which approach is correct?

  1. Use the Formula tool with DateTimeFormat([Date], "%Y-%m-%d")
  2. Use the Select tool and change the field to Date
  3. Use the DateTime tool with String to DateTime and the format %Y-%m-%d Correct answer.
  4. Use the Imputation tool with the date format setting

Explanation

The DateTime tool converts between strings and Alteryx date/time values, and the String to DateTime direction accepts a format string using specifiers such as %Y, %m, and %d. Once converted, the value is a real Date/Time type that date functions can consume.

Question 23Data Preparation and Input/Output

A Join is run on a key where one customer ID appears three times on the left and twice on the right. What does the J output contain for that key?

  1. Two records, keeping only the right-side duplicates
  2. Three records, keeping only the left-side duplicates
  3. One record, using the first match found on each side
  4. Six records, pairing every left match with every right match Correct answer.

Explanation

A join produces a record for each pairing between matching rows, so duplicate keys multiply the output. Three left rows times two right rows yields six joined records for that key, which is why duplicate keys should be checked before joining.

Question 24Data Preparation and Input/Output

A Unique tool is configured with key fields A and B. Two records share the same value of A but have different values of B. What happens?

  1. Only the record with the larger B value is kept
  2. The second record is sent to the duplicate output
  3. Both records leave on the unique output because the A and B combination is distinct Correct answer.
  4. The workflow errors because A repeats

Explanation

The Unique tool evaluates the combination of all selected key fields together, not each field in isolation. Because the pair of values differs, the two records represent different keys and both are treated as unique.

Question 25Data Preparation and Input/Output

An analyst needs a pipe-delimited text file rather than a comma-delimited one. Which change accomplishes this?

  1. Change the file extension to .txt
  2. Select the First row contains field names option
  3. Set the delimiter on the Output Data tool configuration Correct answer.
  4. Add a Text to Columns tool before the Output Data tool

Explanation

The Output Data tool exposes delimiter settings when writing delimited text files, so the separator can be changed from a comma to a pipe or another character. The file extension alone does not determine how values are separated.

Question 26Data Preparation and Input/Output

Which tool arranges records in a specified order based on one or more fields?

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

Explanation

The Sort tool orders records by one or more selected fields and lets each field be set to ascending or descending. It does not add, remove, or aggregate records; it only changes their order.

Question 27Data Preparation and Input/Output

Which tool adds a unique sequential number to each record in a stream?

  1. Unique
  2. Sample
  3. Formula
  4. Record ID Correct answer.

Explanation

The Record ID tool appends a numeric identifier that increments for each record. It is commonly used to create a row key before operations that may reorder or summarize the data.

Question 28Data Preparation and Input/Output

Which tool splits one text field into several fields using a delimiter such as a comma?

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

Explanation

Text to Columns divides a single text field into multiple output fields based on a specified delimiter. The number of output columns can be set to match the expected number of pieces.

Question 29Data Preparation and Input/Output

An analyst wants to add new records to an existing Excel worksheet without deleting the records already there. Which Output Data option should be chosen?

  1. Create New Sheet
  2. Overwrite Sheet (Drop)
  3. Take File/Table Name From Field
  4. Append to Existing Sheet Correct answer.

Explanation

The Append to Existing Sheet option keeps the worksheet's current rows and adds the new records beneath them. Overwrite clears the sheet first, while Create New Sheet writes to a different sheet.

Question 30Data Preparation and Input/Output

When an Input Data tool connects to an Excel workbook that contains multiple worksheets, which configuration element determines which worksheet is read?

  1. The Sheet drop-down Correct answer.
  2. The Record Limit setting
  3. The Field Length setting
  4. The Start Data Import on Line setting

Explanation

Excel connections let the user choose the worksheet through the sheet selection in the tool configuration. The other settings control how many records are read or how text fields are interpreted.

Question 31Data Preparation and Input/Output

Which tool and configuration returns only the first 100 records from a stream?

  1. Sort with a record limit of 100
  2. Unique with 100 key fields
  3. Filter with a record position condition
  4. Sample with First N set to 100 Correct answer.

Explanation

The Sample tool can return the first N records from a stream, so First N with a value of 100 returns the first 100 rows. It does not order the data first; it takes records in their current order.

Question 32Data Preparation and Input/Output

Which tool is used to create a new calculated field such as Revenue = Price * Quantity?

  1. Select
  2. Summarize
  3. Formula Correct answer.
  4. Join

Explanation

The Formula tool creates or updates fields using expressions, including arithmetic such as Price multiplied by Quantity. Each new field is given a name and a data type.

Question 33Data Preparation and Input/Output

Which tool writes the records from a workflow to a file or database table?

  1. Browse
  2. Input Data
  3. Text Input
  4. Output Data Correct answer.

Explanation

The Output Data tool writes the incoming records to a destination such as a flat file, Excel workbook, or database table. It is the standard terminal tool for persisting workflow results.

Question 34Data Preparation and Input/Output

A workflow must produce one row per Region with the number of records in each region. Which configuration accomplishes this?

  1. Cross Tab with Region as header and Count as data
  2. Summarize with Region as Group By and Count as an action Correct answer.
  3. Sort by Region then Sample First 1
  4. Unique on Region with Count selected

Explanation

The Summarize tool with Region as a Group By field and Count as an action outputs one record per distinct region along with the record count. Grouping is the key to producing one row per region.

Question 35Data Preparation and Input/Output

Which tool converts values stored in a field into new columns, turning long data into wide data?

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

Explanation

Cross Tab uses a header field whose values become new column names and a data field whose values populate those columns. This reshapes long data into a wide layout.

Question 36Data Preparation and Input/Output

Which tool converts multiple columns into a key/value pair of fields, turning wide data into long data?

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

Explanation

The Transpose tool takes selected columns and outputs one row per column per original record, with a key field holding the column name and a value field holding the cell value. This is the standard wide-to-long reshape.

Question 37Data Preparation and Input/Output

Which tool examines fields and assigns the smallest data type that can hold the values, such as converting a numeric-looking string to a number?

  1. Data Cleansing
  2. Select
  3. Multi-Field Formula
  4. Auto Field Correct answer.

Explanation

The Auto Field tool inspects field values and converts each field to the smallest appropriate data type. Select can change types manually, but Auto Field performs the sizing automatically.

Question 38Data Preparation and Input/Output

An analyst must apply the same expression, such as Trim, to 20 text fields at once. Which tool is designed for this?

  1. Find Replace
  2. Multi-Row Formula
  3. Multi-Field Formula Correct answer.
  4. Formula

Explanation

The Multi-Field Formula tool applies one expression to multiple selected fields, optionally creating new output fields. It avoids configuring the same logic repeatedly for each column.

Question 39Data Preparation and Input/Output

Which tool uses a separate lookup stream to replace values in a field, such as mapping old product codes to new product names?

  1. Append Fields
  2. Union
  3. Find Replace Correct answer.
  4. Join

Explanation

The Find Replace tool takes a lookup input and replaces or appends values in the target stream based on matching entries. It is suited to code-to-description mappings without adding all lookup columns.

Question 40Data Preparation and Input/Output

Which RegEx tool mode outputs the portions of text captured by groups in a regular expression?

  1. Replace
  2. Tokenize
  3. Match
  4. Parse Correct answer.

Explanation

The Parse mode of the RegEx tool outputs new fields based on capture groups defined in the regular expression. Match mode only identifies whether a pattern occurs and does not split out captured substrings.

Question 41Data Preparation and Input/Output

A text file uses the pipe character (|) as its field separator. Which Input Data change is required so the fields are read correctly?

  1. Set a record limit of 1
  2. Set the delimiter to | Correct answer.
  3. Set the file format to Excel
  4. Change the field type to V_String

Explanation

For delimited text input, the delimiter setting tells the Input Data tool which character separates fields. Setting it to the pipe character allows the file to be parsed into the correct columns.

Question 42Data Preparation and Input/Output

Which tool joins three or more streams on key fields in a single step?

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

Explanation

Join Multiple accepts more than two inputs and joins them on selected key fields in one tool. The standard Join tool connects exactly two inputs.

Question 43Data Preparation and Input/Output

Which tool calculates a cumulative sum across records without requiring a Multi-Row Formula?

  1. Sample
  2. Summarize
  3. Tile
  4. Running Total Correct answer.

Explanation

The Running Total tool creates a field that accumulates values as records are processed, producing a cumulative sum. It depends on the incoming record order, so sorting beforehand controls the result.

Question 44Data Preparation and Input/Output

Which tool renames fields dynamically using a formula, a lookup table, or by adding a prefix or suffix?

  1. Dynamic Rename Correct answer.
  2. Multi-Field Formula
  3. Field Summary
  4. Select

Explanation

Dynamic Rename changes field names programmatically, such as by applying a formula or matching a lookup table. It is useful when field names vary from run to run and must be standardized automatically.

Question 45Data Preparation and Input/Output

Which tool reports profiling information such as count, minimum, maximum, and average for each field without changing the data?

  1. Browse
  2. Summarize
  3. Field Summary Correct answer.
  4. Auto Field

Explanation

The Field Summary tool produces a profile of each field, including statistics such as count, minimum, maximum, and average. It is intended for data investigation rather than transforming the stream.

Question 46Data Preparation and Input/Output

In Alteryx, which statement correctly distinguishes String from V_String?

  1. String stores only numeric characters, while V_String stores any character
  2. String is variable length, while V_String is fixed length
  3. String has a fixed length, while V_String stores variable-length text up to its maximum size Correct answer.
  4. String is used for dates, while V_String is used for text

Explanation

A String field is fixed in length, whereas a V_String field uses variable-length storage up to its defined maximum. Choosing appropriately affects storage and how values are handled downstream.

Question 47Data Preparation and Input/Output

An integer field must store values up to 2,000,000,000. Which Alteryx numeric type is the smallest that can hold this range without overflow?

  1. Int16
  2. Int64
  3. Int32 Correct answer.
  4. Byte

Explanation

Int32 holds signed integers up to approximately 2.147 billion, which covers 2,000,000,000. Int16 and Byte are much smaller, while Int64 would work but is larger than necessary.

Question 48Data Preparation and Input/Output

A Multi-Row Formula is configured with Group By CustomerID and an expression referencing Row-1. What value is available for Row-1 on the first record of each customer group?

  1. NULL, because there is no previous row within the group Correct answer.
  2. Zero for numeric fields and an empty string for text fields
  3. The last row of the previous group
  4. The first row of the entire data stream

Explanation

With Group By enabled, row references are evaluated only within each group. On the first record of a group there is no previous row inside that group, so Row-1 evaluates to NULL.

Question 49Data Preparation and Input/Output

Two streams are combined with the Union tool configured By Position. The first stream has fields A and B; the second has fields X, Y, and Z. What is the resulting field structure?

  1. Five fields, because all field names are preserved side by side
  2. Three fields, with all values placed in a single field
  3. Three fields; the first two positions align A with X and B with Y, and the third position contains Z with nulls for the first stream Correct answer.
  4. Two fields, because the extra field Z is dropped

Explanation

By Position aligns fields according to their order in each input, not their names. Positions that exist in only one input are retained, with nulls supplied for records from the other input.

Question 50Data Preparation and Input/Output

Which Alteryx data type is designed to store monetary values with a fixed number of decimal places and exact precision?

  1. Double
  2. Fixed Decimal Correct answer.
  3. Float
  4. Int64

Explanation

Fixed Decimal stores values with a defined precision and scale, making it suitable for exact monetary amounts. Floating-point types can introduce rounding artifacts that are undesirable for currency calculations.