Alteryx Core Certification Exam Questions and Answers

Alteryx Core Certification Exam
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.

How do you change the supported length or measurement of data in the Select tool? -
Correct Answers -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? - Correct Answers -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? - Correct Answers -Build an
Expression, Add an Additional Expression, Reorder an Expression

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.