Alteryx Preparation Tools Exam
Questions and Answers
Filter - Correct Answers -Allows user to restrict data based on certain criteria; queries
records in file to meet specified criteria; two output anchors - T for records that match
criteria and F for records that do not match criteria
Formula - Correct Answers -Derive new column or modify existing column by using
expressions to perform a broad variety of calculations and/or operations
Generate Rows - Correct Answers -Create new rows of data at the record level; create
rows incrementally based on the initial expression, loop expression, and stops when
condition criteria are met
Select Records - Correct Answers -Select specific records and or ranges of records
including discontinuous ranges; useful for troubleshooting and sampling
Data Cleansing - Correct Answers -Perform basic data cleansing operations such as
replacing null values, eliminating null rows or colums, removing whitespace (leading and
trailing), and modifying case or removing punctuation
Multi-Row Formula - Correct Answers -Add new column or change row values based on
expressions which are applied to multiple rows; can group based on fields; Row - 1
references row before current, Row + 1 references row after current; can specify other
numbers of rows to apply; can only one field per tool instance
Auto Field - Correct Answers -Reads through all of the records of an input and sets the
field type to the smallest possible size relative to the data contained within the column;
configuration allows user to select which fields to auto configure
Random N% of Records - Correct Answers -Return an expected number of records
resulting in a random sample of incoming data stream
Sample - Correct Answers -Extracts a specified portion of records in the data stream
Select - Correct Answers -Change metadata; rename or reorder columns, change data
type, deselect unneeded columns, assign a description
Questions and Answers
Filter - Correct Answers -Allows user to restrict data based on certain criteria; queries
records in file to meet specified criteria; two output anchors - T for records that match
criteria and F for records that do not match criteria
Formula - Correct Answers -Derive new column or modify existing column by using
expressions to perform a broad variety of calculations and/or operations
Generate Rows - Correct Answers -Create new rows of data at the record level; create
rows incrementally based on the initial expression, loop expression, and stops when
condition criteria are met
Select Records - Correct Answers -Select specific records and or ranges of records
including discontinuous ranges; useful for troubleshooting and sampling
Data Cleansing - Correct Answers -Perform basic data cleansing operations such as
replacing null values, eliminating null rows or colums, removing whitespace (leading and
trailing), and modifying case or removing punctuation
Multi-Row Formula - Correct Answers -Add new column or change row values based on
expressions which are applied to multiple rows; can group based on fields; Row - 1
references row before current, Row + 1 references row after current; can specify other
numbers of rows to apply; can only one field per tool instance
Auto Field - Correct Answers -Reads through all of the records of an input and sets the
field type to the smallest possible size relative to the data contained within the column;
configuration allows user to select which fields to auto configure
Random N% of Records - Correct Answers -Return an expected number of records
resulting in a random sample of incoming data stream
Sample - Correct Answers -Extracts a specified portion of records in the data stream
Select - Correct Answers -Change metadata; rename or reorder columns, change data
type, deselect unneeded columns, assign a description
