Alteryx Core Exam Prep
Study online at https://quizlet.com/_g2t4na
1. What are the two Connect a File or Database AND Options
sections of the
Input Data Con-
figuration win-
dow?
2. What does enter- It brings in anything that starts with the characters before
ing "*" do with an the "*" and anything after it
input file?
3. What does enter- It brings in anything that starts with the characters before
ing "?" do with the "?" plus one character
an input file?
4. What are the 100 records or fewer in wide files
limits for the
data layout pre-
view window in
the Input Data
tool?
5. How do you con- 1.) Right-click the Output Data tool you want to convert to
vert an Output an Input Data tool.
Data Tool to an 2.) Select Convert To Input Data.
Input Data Tool?
6. What are the 3 -Drag a Browse tool to the canvas, and connect it to an
ways to add the upstream tool.
Browse tool to -Right-click on a tool on the canvas and select Add
the workflow? Browse After.
-Use the Shift+Ctrl+B keyboard shortcut and select the
tools in a workflow.
7. Without the 1 MB of data
browse tool, up
to how much
data shows in the
Results window?
8.
, Alteryx Core Exam Prep
Study online at https://quizlet.com/_g2t4na
How do you dis- -Select a random point on the canvas to display the Work-
able a browse flow - Configuration window.
tool? -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.
9. What happens "No Profiling Available" message will display
in the Configu-
ration Window of
the Browse Tool
if a column's
data type is not
compatible with
data profiling?
10. What happens "Only one value" message displays
in the Configu-
ration Window of
the Browse Tool
if there is only
one value in each
column?
11. What happens "All values are unique" message displays
in the Configu-
ration Window of
the Browse Tool
if each value in
the columns is
unique?
12. In the Configu- Fields (columns) and Data Type
ration Window of
the Browse Tool,
what are the two
categories you
can filter based
on?
, Alteryx Core Exam Prep
Study online at https://quizlet.com/_g2t4na
13. What is the data 300 MB
profiling limit of
the Browse Tool?
14. Is record size No
the same as file
size?
15. How to con- 1.) Right-click the Browse tool in your workflow.
vert Browse Tool 2.) Select Convert To Macro Output.
to Macro Output 3.) Configure the tool.
Tool
16. How to convert 1.) Right-click the Browse tool in your workflow.
Browse Tool to 2.) Select Convert To Output Data.
Output Data Tool 3.) Configure the tool.
17. What does the Appends the selected field name to the end of the name
"Append Suf- of the selected table.
fix to File/Table
Name" option do
to the output
data file?
18. What does the Prepends the selected field name to the beginning of the
"Prepend Pre- name of the selected table.
fix to File/Table
Name" option do
to the output
data file?
19. What does Changes the file name to the selected field name
the "Change
File/Table Name"
option do to the
output data file?
20. What does the Changes the file name to the name of the selected field.
"Change Entire The name must be a complete file path. This option can
File Path" option
, Alteryx Core Exam Prep
Study online at https://quizlet.com/_g2t4na
do to the output overwrite an existing file if a file exists in the full path
data file? directory
21. What does De- Using the default sort, numeric strings are sorted left to
fault Sort do right, character by character
to numeric string
data?
22. What does Dic- Using the dictionary sort, numeric strings are sorted from
tionary Sort do the smallest to largest number
to numeric string
data?
23. What does the Use Auto Field to read through all of the records of an
Auto Field Tool input and set the field type to the smallest possible size
do? 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.
24. What should you Manual inspection. Manual inspection of the results is
do after run- often necessary to ensure that rows flagged as duplicates
ning the Dupli- are actually duplicates. For example, you might have 2
cates tool? 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.
25. What is Sample Use Sample to limit the data stream to a specified num-
tool used for? ber, percentage, or random set of rows. In addition, the
Sample tool applies the selected configuration to the
columns selected to group by
26. What is the op- Group by column: If a group or groups are specified, N
tion in the Sam- rows are returned for each group.
ple tool to further
sample the data? 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.
27.
Study online at https://quizlet.com/_g2t4na
1. What are the two Connect a File or Database AND Options
sections of the
Input Data Con-
figuration win-
dow?
2. What does enter- It brings in anything that starts with the characters before
ing "*" do with an the "*" and anything after it
input file?
3. What does enter- It brings in anything that starts with the characters before
ing "?" do with the "?" plus one character
an input file?
4. What are the 100 records or fewer in wide files
limits for the
data layout pre-
view window in
the Input Data
tool?
5. How do you con- 1.) Right-click the Output Data tool you want to convert to
vert an Output an Input Data tool.
Data Tool to an 2.) Select Convert To Input Data.
Input Data Tool?
6. What are the 3 -Drag a Browse tool to the canvas, and connect it to an
ways to add the upstream tool.
Browse tool to -Right-click on a tool on the canvas and select Add
the workflow? Browse After.
-Use the Shift+Ctrl+B keyboard shortcut and select the
tools in a workflow.
7. Without the 1 MB of data
browse tool, up
to how much
data shows in the
Results window?
8.
, Alteryx Core Exam Prep
Study online at https://quizlet.com/_g2t4na
How do you dis- -Select a random point on the canvas to display the Work-
able a browse flow - Configuration window.
tool? -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.
9. What happens "No Profiling Available" message will display
in the Configu-
ration Window of
the Browse Tool
if a column's
data type is not
compatible with
data profiling?
10. What happens "Only one value" message displays
in the Configu-
ration Window of
the Browse Tool
if there is only
one value in each
column?
11. What happens "All values are unique" message displays
in the Configu-
ration Window of
the Browse Tool
if each value in
the columns is
unique?
12. In the Configu- Fields (columns) and Data Type
ration Window of
the Browse Tool,
what are the two
categories you
can filter based
on?
, Alteryx Core Exam Prep
Study online at https://quizlet.com/_g2t4na
13. What is the data 300 MB
profiling limit of
the Browse Tool?
14. Is record size No
the same as file
size?
15. How to con- 1.) Right-click the Browse tool in your workflow.
vert Browse Tool 2.) Select Convert To Macro Output.
to Macro Output 3.) Configure the tool.
Tool
16. How to convert 1.) Right-click the Browse tool in your workflow.
Browse Tool to 2.) Select Convert To Output Data.
Output Data Tool 3.) Configure the tool.
17. What does the Appends the selected field name to the end of the name
"Append Suf- of the selected table.
fix to File/Table
Name" option do
to the output
data file?
18. What does the Prepends the selected field name to the beginning of the
"Prepend Pre- name of the selected table.
fix to File/Table
Name" option do
to the output
data file?
19. What does Changes the file name to the selected field name
the "Change
File/Table Name"
option do to the
output data file?
20. What does the Changes the file name to the name of the selected field.
"Change Entire The name must be a complete file path. This option can
File Path" option
, Alteryx Core Exam Prep
Study online at https://quizlet.com/_g2t4na
do to the output overwrite an existing file if a file exists in the full path
data file? directory
21. What does De- Using the default sort, numeric strings are sorted left to
fault Sort do right, character by character
to numeric string
data?
22. What does Dic- Using the dictionary sort, numeric strings are sorted from
tionary Sort do the smallest to largest number
to numeric string
data?
23. What does the Use Auto Field to read through all of the records of an
Auto Field Tool input and set the field type to the smallest possible size
do? 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.
24. What should you Manual inspection. Manual inspection of the results is
do after run- often necessary to ensure that rows flagged as duplicates
ning the Dupli- are actually duplicates. For example, you might have 2
cates tool? 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.
25. What is Sample Use Sample to limit the data stream to a specified num-
tool used for? ber, percentage, or random set of rows. In addition, the
Sample tool applies the selected configuration to the
columns selected to group by
26. What is the op- Group by column: If a group or groups are specified, N
tion in the Sam- rows are returned for each group.
ple tool to further
sample the data? 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.
27.
