1 | P a g e | © copyright 2024/2025 | Grade A+
Alteryx Certification Study Guide
Questions and Answers (100% Pass)
Any value entered into the Text Input tool is characterized as a string data
type
T/F
✓ False
Cells that are left blank in the Text Input tool are assigned what value?
A - Empty
B - Null
C - Zero (0)
✓ 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
Master01 | September, 2024/2025 | Latest update
, 1 | P a g e | © copyright 2024/2025 | Grade A+
2 - Manually enter values in cells
3 - Input data from a file or database
✓ All of the above
The Input Data tool can only connect to files
T/F
✓ 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
✓ Record Limit and Output File Name
Which of the following file types support reading in multiple sheets? Select all
that apply
Master01 | September, 2024/2025 | Latest update
, 1 | P a g e | © copyright 2024/2025 | Grade A+
1 - .xls
2 - All listed options
3 - .yxdb
4 - .csv
5 - .xlsx
✓ .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
✓ A warning message appears
The Dynamic Input tool is the only tool required to import multiple sheets at
once
Master01 | September, 2024/2025 | Latest update
Alteryx Certification Study Guide
Questions and Answers (100% Pass)
Any value entered into the Text Input tool is characterized as a string data
type
T/F
✓ False
Cells that are left blank in the Text Input tool are assigned what value?
A - Empty
B - Null
C - Zero (0)
✓ 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
Master01 | September, 2024/2025 | Latest update
, 1 | P a g e | © copyright 2024/2025 | Grade A+
2 - Manually enter values in cells
3 - Input data from a file or database
✓ All of the above
The Input Data tool can only connect to files
T/F
✓ 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
✓ Record Limit and Output File Name
Which of the following file types support reading in multiple sheets? Select all
that apply
Master01 | September, 2024/2025 | Latest update
, 1 | P a g e | © copyright 2024/2025 | Grade A+
1 - .xls
2 - All listed options
3 - .yxdb
4 - .csv
5 - .xlsx
✓ .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
✓ A warning message appears
The Dynamic Input tool is the only tool required to import multiple sheets at
once
Master01 | September, 2024/2025 | Latest update
