Alteryx Core Exam Prep Questions and
Answers
What are the two sections of the Input Data Configuration window? - Correct Answers -
Connect a File or Database AND Options
What does entering "*" do with an input file? - Correct Answers -It brings in anything that
starts with the characters before the "*" and anything after it
What does entering "?" do with an input file? - Correct Answers -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? - Correct
Answers -100 records or fewer in wide files
How do you convert an Output Data Tool to an Input Data Tool? - Correct Answers -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? - Correct Answers --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.
Without the browse tool, up to how much data shows in the Results window? - Correct
Answers -1 MB of data
How do you disable a browse tool? - Correct Answers --Select a random point on the
canvas to display the Workflow - Configuration window.
-In the configuration window, select Runtime.
-Check Disable All Browse Tools to make the Browse tools in the workflow unavailable.
To enable Browse tools, uncheck Disable All Browse Tools.
What happens in the Configuration Window of the Browse Tool if a column's data type
is not compatible with data profiling? - Correct Answers -"No Profiling Available"
message will display
What happens in the Configuration Window of the Browse Tool if there is only one value
in each column? - Correct Answers -"Only one value" message displays
,What happens in the Configuration Window of the Browse Tool if each value in the
columns is unique? - Correct Answers -"All values are unique" message displays
In the Configuration Window of the Browse Tool, what are the two categories you can
filter based on? - Correct Answers -Fields (columns) and Data Type
What is the data profiling limit of the Browse Tool? - Correct Answers -300 MB
Is record size the same as file size? - Correct Answers -No
How to convert Browse Tool to Macro Output Tool - Correct Answers -1.) Right-click the
Browse tool in your workflow.
2.) Select Convert To Macro Output.
3.) Configure the tool.
How to convert Browse Tool to Output Data Tool - Correct Answers -1.) Right-click the
Browse tool in your workflow.
2.) Select Convert To Output Data.
3.) Configure the tool.
What does the "Append Suffix to File/Table Name" option do to the output data file? -
Correct Answers -Appends the selected field name to the end of the name of the
selected table.
What does the "Prepend Prefix to File/Table Name" option do to the output data file? -
Correct Answers -Prepends the selected field name to the beginning of the name of the
selected table.
Sort - Correct Answers -Allows sorting of data in ascending or descending order (sorts
based on first field)
Sample - Correct Answers -Limit the data to a certain number, percentage, or random
set of records out of the whole data set
Random Sample % - Correct Answers -Generates a random number or percentage of
records passing through the data stream
Unique - Correct Answers -Separate data into two streams based on the fields of the
user's choosing
Inner Join - Correct Answers -Both sides have to match, only those records are returned
What does the "Change File/Table Name" option do to the output data file? - Correct
Answers -Changes the file name to the selected field name
, What does the "Change Entire File Path" option do to the output data file? - Correct
Answers -Changes the file name to the name of the selected field. The name must be a
complete file path. This option can overwrite an existing file if a file exists in the full path
directory
What does Default Sort do to numeric string data? - Correct Answers -Using the default
sort, numeric strings are sorted left to right, character by character
What does Dictionary Sort do to numeric string data? - Correct Answers -Using the
dictionary sort, numeric strings are sorted from the smallest to largest number
What does the Auto Field Tool do? - Correct Answers -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? - Correct Answers -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? - Correct Answers -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? - Correct Answers -
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? - Correct Answers -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? - Correct Answers -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.
Answers
What are the two sections of the Input Data Configuration window? - Correct Answers -
Connect a File or Database AND Options
What does entering "*" do with an input file? - Correct Answers -It brings in anything that
starts with the characters before the "*" and anything after it
What does entering "?" do with an input file? - Correct Answers -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? - Correct
Answers -100 records or fewer in wide files
How do you convert an Output Data Tool to an Input Data Tool? - Correct Answers -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? - Correct Answers --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.
Without the browse tool, up to how much data shows in the Results window? - Correct
Answers -1 MB of data
How do you disable a browse tool? - Correct Answers --Select a random point on the
canvas to display the Workflow - Configuration window.
-In the configuration window, select Runtime.
-Check Disable All Browse Tools to make the Browse tools in the workflow unavailable.
To enable Browse tools, uncheck Disable All Browse Tools.
What happens in the Configuration Window of the Browse Tool if a column's data type
is not compatible with data profiling? - Correct Answers -"No Profiling Available"
message will display
What happens in the Configuration Window of the Browse Tool if there is only one value
in each column? - Correct Answers -"Only one value" message displays
,What happens in the Configuration Window of the Browse Tool if each value in the
columns is unique? - Correct Answers -"All values are unique" message displays
In the Configuration Window of the Browse Tool, what are the two categories you can
filter based on? - Correct Answers -Fields (columns) and Data Type
What is the data profiling limit of the Browse Tool? - Correct Answers -300 MB
Is record size the same as file size? - Correct Answers -No
How to convert Browse Tool to Macro Output Tool - Correct Answers -1.) Right-click the
Browse tool in your workflow.
2.) Select Convert To Macro Output.
3.) Configure the tool.
How to convert Browse Tool to Output Data Tool - Correct Answers -1.) Right-click the
Browse tool in your workflow.
2.) Select Convert To Output Data.
3.) Configure the tool.
What does the "Append Suffix to File/Table Name" option do to the output data file? -
Correct Answers -Appends the selected field name to the end of the name of the
selected table.
What does the "Prepend Prefix to File/Table Name" option do to the output data file? -
Correct Answers -Prepends the selected field name to the beginning of the name of the
selected table.
Sort - Correct Answers -Allows sorting of data in ascending or descending order (sorts
based on first field)
Sample - Correct Answers -Limit the data to a certain number, percentage, or random
set of records out of the whole data set
Random Sample % - Correct Answers -Generates a random number or percentage of
records passing through the data stream
Unique - Correct Answers -Separate data into two streams based on the fields of the
user's choosing
Inner Join - Correct Answers -Both sides have to match, only those records are returned
What does the "Change File/Table Name" option do to the output data file? - Correct
Answers -Changes the file name to the selected field name
, What does the "Change Entire File Path" option do to the output data file? - Correct
Answers -Changes the file name to the name of the selected field. The name must be a
complete file path. This option can overwrite an existing file if a file exists in the full path
directory
What does Default Sort do to numeric string data? - Correct Answers -Using the default
sort, numeric strings are sorted left to right, character by character
What does Dictionary Sort do to numeric string data? - Correct Answers -Using the
dictionary sort, numeric strings are sorted from the smallest to largest number
What does the Auto Field Tool do? - Correct Answers -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? - Correct Answers -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? - Correct Answers -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? - Correct Answers -
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? - Correct Answers -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? - Correct Answers -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.
