ALTERYX CORE CERTIFICATION
QUESTIONS AND ANSWERS
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.
3.) Configure the tool.
How to convert Browse Tool to Output Data Tool - Answer- 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? -
Answer- 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?
- Answer- Prepends the selected field name to the beginning of the name of the
selected table.
What does the "Change File/Table Name" option do to the output data file? -
Answer- Changes the file name to the selected field name
What does the "Change Entire File Path" option do to the output data file? - Answer-
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? - 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.
QUESTIONS AND ANSWERS
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.
3.) Configure the tool.
How to convert Browse Tool to Output Data Tool - Answer- 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? -
Answer- 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?
- Answer- Prepends the selected field name to the beginning of the name of the
selected table.
What does the "Change File/Table Name" option do to the output data file? -
Answer- Changes the file name to the selected field name
What does the "Change Entire File Path" option do to the output data file? - Answer-
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? - 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.
