Alteryx Certification Exam Questions
and Answers
Any value entered into the Text Input tool is characterized as a string data type
T/F - Answer- False
Cells that are left blank in the Text Input tool are assigned what value?
A - Empty
B - Null
C - Zero (0) - Answer- 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 - Answer- All of the above
The Input Data tool can only connect to files
T/F - Answer- 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 - Answer- 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 - Answer- .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 - Answer- A warning message appears
The Dynamic Input tool is the only tool required to import multiple sheets at once
T/F - Answer- False
Data is only created or modified when a workflow with a configured Output Data tool
is run
T/F - Answer- 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. - Answer- 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 - Answer- 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 - Answer- 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 - Answer- 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
4 - Embedded select window
5 - Appending a column
6 - Partial field matching - Answer- Works with numeric values & Embedded select
window
Columns classified as a numeric type may be joined to columns classified as any
data type when joining by specific fields
and Answers
Any value entered into the Text Input tool is characterized as a string data type
T/F - Answer- False
Cells that are left blank in the Text Input tool are assigned what value?
A - Empty
B - Null
C - Zero (0) - Answer- 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 - Answer- All of the above
The Input Data tool can only connect to files
T/F - Answer- 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 - Answer- 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 - Answer- .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 - Answer- A warning message appears
The Dynamic Input tool is the only tool required to import multiple sheets at once
T/F - Answer- False
Data is only created or modified when a workflow with a configured Output Data tool
is run
T/F - Answer- 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. - Answer- 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 - Answer- 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 - Answer- 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 - Answer- 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
4 - Embedded select window
5 - Appending a column
6 - Partial field matching - Answer- Works with numeric values & Embedded select
window
Columns classified as a numeric type may be joined to columns classified as any
data type when joining by specific fields
