Alteryx Core Certification Questions and
Answers with Complete Solutions 100% Correct
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.
Without the browse tool, up to how much data shows in the Results window? -
ANSWER 1 MB of data
, How do you disable a browse tool? - ANSWER -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? - ANSWER "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? - ANSWER "Only one value" message displays
What happens in the Configuration Window of the Browse Tool if each value in
the columns is unique? - ANSWER "All values are unique" message displays
In the Configuration Window of the Browse Tool, what are the two categories you
can filter based on? - ANSWER Fields (columns) and Data Type
What is the data profiling limit of the Browse Tool? - ANSWER 300 MB
Is record size the same as file size? - ANSWER No
How to convert Browse Tool to Macro Output Tool - ANSWER 1.) Right-click the
Browse tool in your workflow.
2.) Select Convert To Macro Output.
Answers with Complete Solutions 100% Correct
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.
Without the browse tool, up to how much data shows in the Results window? -
ANSWER 1 MB of data
, How do you disable a browse tool? - ANSWER -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? - ANSWER "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? - ANSWER "Only one value" message displays
What happens in the Configuration Window of the Browse Tool if each value in
the columns is unique? - ANSWER "All values are unique" message displays
In the Configuration Window of the Browse Tool, what are the two categories you
can filter based on? - ANSWER Fields (columns) and Data Type
What is the data profiling limit of the Browse Tool? - ANSWER 300 MB
Is record size the same as file size? - ANSWER No
How to convert Browse Tool to Macro Output Tool - ANSWER 1.) Right-click the
Browse tool in your workflow.
2.) Select Convert To Macro Output.
