Alteryx Certification Study Guide
Any value entered into the Text Input tool is characterized as a string data type
T/F - Correct Answers -False
Cells that are left blank in the Text Input tool are assigned what value?
A - Empty
B - Null
C - Zero (0) - Correct Answers -Null
How can data be added to a workflow with the Text Input tool? Choose all that apply.
1- Copy and paste values from another source
2 - Manually enter values in cells
3 - Input data from a file or database - Correct Answers -All of the above
The Input Data tool can only connect to files
T/F - Correct Answers -False
Which of the following are present in the configuration options for Alteryx Databases,
Microsoft Excel workbooks, and CSVs?
1 - Delimiters
2 - First Row Contains Data
3 - Record Limit
4 - Output File Name - Correct Answers -Record Limit and Output File Name
Which of the following file types support reading in multiple sheets? Select all that apply
1 - .xls
2 - All listed options
3 - .yxdb
4 - .csv
5 - .xlsx - Correct Answers -.xlsx
What happens when Designer fail to read in a sheet?
, A - a warning message appears
B - an error message appears
C - this would never happen in Designer
D- nothing happens - Correct Answers -A warning message appears
The Dynamic Input tool is the only tool required to import multiple sheets at once
T/F - Correct Answers -False
Data is only created or modified when a workflow with a configured Output Data tool is
run
T/F - Correct Answers -True
Select the statements that are true.
1 - The Output Data tool's configuration options change based on the output file type.
2 - The Output Data tool can only write to files.
3 - The Output Data tool can only produce one file at a time.
4 - The Output Data tool does not include an output anchor. - Correct Answers -1 & 4
Select all the ways in which a Browse tool can be added to the Canvas.
1 - Right click a tool on the Canvas and select "Add Browse After"
2 - Select a tool on the Canvas and hit CTRL + Shift + B
3 - Drag a Browse tool on the Canvas from the Tool Palette - Correct Answers -All the
Above
Which of the following data types are acceptable for identifying matching values when
using the Find Replace tool? Select all that apply.
1 - Spatial
2 - DateTime
3 - Numeric
4 - String - Correct Answers -String
The dataset that is connected to the "F" input of the Find Replace tool is the input in
which data values are replaced or appended.
T/F - Correct Answers -True
Select all features which are not associated with the Find Replace tool.
1 - Appending more than one column
2 - Case insensitivity
3 - Works with numeric values
Any value entered into the Text Input tool is characterized as a string data type
T/F - Correct Answers -False
Cells that are left blank in the Text Input tool are assigned what value?
A - Empty
B - Null
C - Zero (0) - Correct Answers -Null
How can data be added to a workflow with the Text Input tool? Choose all that apply.
1- Copy and paste values from another source
2 - Manually enter values in cells
3 - Input data from a file or database - Correct Answers -All of the above
The Input Data tool can only connect to files
T/F - Correct Answers -False
Which of the following are present in the configuration options for Alteryx Databases,
Microsoft Excel workbooks, and CSVs?
1 - Delimiters
2 - First Row Contains Data
3 - Record Limit
4 - Output File Name - Correct Answers -Record Limit and Output File Name
Which of the following file types support reading in multiple sheets? Select all that apply
1 - .xls
2 - All listed options
3 - .yxdb
4 - .csv
5 - .xlsx - Correct Answers -.xlsx
What happens when Designer fail to read in a sheet?
, A - a warning message appears
B - an error message appears
C - this would never happen in Designer
D- nothing happens - Correct Answers -A warning message appears
The Dynamic Input tool is the only tool required to import multiple sheets at once
T/F - Correct Answers -False
Data is only created or modified when a workflow with a configured Output Data tool is
run
T/F - Correct Answers -True
Select the statements that are true.
1 - The Output Data tool's configuration options change based on the output file type.
2 - The Output Data tool can only write to files.
3 - The Output Data tool can only produce one file at a time.
4 - The Output Data tool does not include an output anchor. - Correct Answers -1 & 4
Select all the ways in which a Browse tool can be added to the Canvas.
1 - Right click a tool on the Canvas and select "Add Browse After"
2 - Select a tool on the Canvas and hit CTRL + Shift + B
3 - Drag a Browse tool on the Canvas from the Tool Palette - Correct Answers -All the
Above
Which of the following data types are acceptable for identifying matching values when
using the Find Replace tool? Select all that apply.
1 - Spatial
2 - DateTime
3 - Numeric
4 - String - Correct Answers -String
The dataset that is connected to the "F" input of the Find Replace tool is the input in
which data values are replaced or appended.
T/F - Correct Answers -True
Select all features which are not associated with the Find Replace tool.
1 - Appending more than one column
2 - Case insensitivity
3 - Works with numeric values
