Alteryx Core Certification Exam
Questions with 100% Correct
Answers
What does Default Sort do to numeric string data? - Answer-Using the default sort,
numeric strings are sorted left to right, character by character
What does Dictionary Sort do to numeric string data? - Answer-Using the dictionary
sort, numeric strings are sorted from the smallest to largest number
What does the Auto Field Tool do? - Answer-Use Auto Field to read through all of the
records of an input and set the field type to the smallest possible size relative to the
data contained within the column.
The tool correctly assigns a numeric field to a string data type where any record starts
with zero and not a number.
What should you do after running the Duplicates tool? - Answer-Manual inspection.
Manual inspection of the results is often necessary to ensure that rows flagged as
duplicates are actually duplicates. For example, you might have 2 customers that share
the same name but live at different addresses. If you think that your dataset might
include these types of outliers, you might want to select additional columns when you
configure this tool.
What is Sample tool used for? - Answer-Use Sample to limit the data stream to a
specified number, percentage, or random set of rows. In addition, the Sample tool
applies the selected configuration to the columns selected to group by
What is the option in the Sample tool to further sample the data? - Answer-Group by
column: If a group or groups are specified, N rows are returned for each group.
If you select to Group by a column named City, specify N as 2, and select First N Rows,
Alteryx returns the first 2 rows for each City.
What other tools contain the Select tool functionality? - Answer-Append Fields tool, Find
Nearest tool, Join tool, Join Multiple tool, Select In-DB tool, and Spatial Match tool
What is the Select tool used for? - Answer-Use Select to include, exclude, and reorder
the columns of data that pass through your workflow. Excluding columns can limit the
, data passing through a workflow and improve performance. You can also use the Select
tool to modify the type and size of data, rename a column, or add a description.
How do you change the supported length or measurement of data in the Select tool? -
Answer-Select size and enter a number. Size varies by data types and can be edited for
fixed decimal numeric types and all string types
What are the ways you can use the Formula tool? - Answer-Apply conditional
statements.
Convert numbers and strings.
Format dates.
Extract file paths.
Apply financial algorithms or mathematical calculations.
Find the minimum and maximum values.
Analyze spatial data.
Cleanse string data.
Perform validation tests on data.
What are the three functions of the Formula tool? - Answer-Build an Expression, Add an
Additional Expression, Reorder an Expression
What is the Multi-Row Formula tool used for? - Answer-Utilize row data as part of the
formula creation and is useful for parsing complex data, and creating running totals,
averages, percentages, and other mathematical calculations
What are the two sections of the Input Data Configuration window? - Answer-Connect a
File or Database AND Options
What does entering "*" do with an input file? - Answer-It brings in anything that starts
with the characters before the "*" and anything after it
What does entering "?" do with an input file? - Answer-It brings in anything that starts
with the characters before the "?" plus one character
What are the limits for the data layout preview window in the Input Data tool? - Answer-
100 records or fewer in wide files
How do you convert an Output Data Tool to an Input Data Tool? - Answer-1.) Right-click
the Output Data tool you want to convert to an Input Data tool.
2.) Select Convert To Input Data.
What are the 3 ways to add the Browse tool to the workflow? - Answer--Drag a Browse
tool to the canvas, and connect it to an upstream tool.
-Right-click on a tool on the canvas and select Add Browse After.
-Use the Shift+Ctrl+B keyboard shortcut and select the tools in a workflow.
Questions with 100% Correct
Answers
What does Default Sort do to numeric string data? - Answer-Using the default sort,
numeric strings are sorted left to right, character by character
What does Dictionary Sort do to numeric string data? - Answer-Using the dictionary
sort, numeric strings are sorted from the smallest to largest number
What does the Auto Field Tool do? - Answer-Use Auto Field to read through all of the
records of an input and set the field type to the smallest possible size relative to the
data contained within the column.
The tool correctly assigns a numeric field to a string data type where any record starts
with zero and not a number.
What should you do after running the Duplicates tool? - Answer-Manual inspection.
Manual inspection of the results is often necessary to ensure that rows flagged as
duplicates are actually duplicates. For example, you might have 2 customers that share
the same name but live at different addresses. If you think that your dataset might
include these types of outliers, you might want to select additional columns when you
configure this tool.
What is Sample tool used for? - Answer-Use Sample to limit the data stream to a
specified number, percentage, or random set of rows. In addition, the Sample tool
applies the selected configuration to the columns selected to group by
What is the option in the Sample tool to further sample the data? - Answer-Group by
column: If a group or groups are specified, N rows are returned for each group.
If you select to Group by a column named City, specify N as 2, and select First N Rows,
Alteryx returns the first 2 rows for each City.
What other tools contain the Select tool functionality? - Answer-Append Fields tool, Find
Nearest tool, Join tool, Join Multiple tool, Select In-DB tool, and Spatial Match tool
What is the Select tool used for? - Answer-Use Select to include, exclude, and reorder
the columns of data that pass through your workflow. Excluding columns can limit the
, data passing through a workflow and improve performance. You can also use the Select
tool to modify the type and size of data, rename a column, or add a description.
How do you change the supported length or measurement of data in the Select tool? -
Answer-Select size and enter a number. Size varies by data types and can be edited for
fixed decimal numeric types and all string types
What are the ways you can use the Formula tool? - Answer-Apply conditional
statements.
Convert numbers and strings.
Format dates.
Extract file paths.
Apply financial algorithms or mathematical calculations.
Find the minimum and maximum values.
Analyze spatial data.
Cleanse string data.
Perform validation tests on data.
What are the three functions of the Formula tool? - Answer-Build an Expression, Add an
Additional Expression, Reorder an Expression
What is the Multi-Row Formula tool used for? - Answer-Utilize row data as part of the
formula creation and is useful for parsing complex data, and creating running totals,
averages, percentages, and other mathematical calculations
What are the two sections of the Input Data Configuration window? - Answer-Connect a
File or Database AND Options
What does entering "*" do with an input file? - Answer-It brings in anything that starts
with the characters before the "*" and anything after it
What does entering "?" do with an input file? - Answer-It brings in anything that starts
with the characters before the "?" plus one character
What are the limits for the data layout preview window in the Input Data tool? - Answer-
100 records or fewer in wide files
How do you convert an Output Data Tool to an Input Data Tool? - Answer-1.) Right-click
the Output Data tool you want to convert to an Input Data tool.
2.) Select Convert To Input Data.
What are the 3 ways to add the Browse tool to the workflow? - Answer--Drag a Browse
tool to the canvas, and connect it to an upstream tool.
-Right-click on a tool on the canvas and select Add Browse After.
-Use the Shift+Ctrl+B keyboard shortcut and select the tools in a workflow.
