Alteryx Certification Study Guide
Study online at https://quizlet.com/_g2t4uw
1. Any value entered into the Text Input tool is character- False
ized as a string data type
T/F
2. Cells that are left blank in the Text Input tool are as- Null
signed what value?
A - Empty
B - Null
C - Zero (0)
3. How can data be added to a workflow with the Text All of the above
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
4. The Input Data tool can only connect to files False
T/F
5. Which of the following are present in the configuration Record Limit and
options for Alteryx Databases, Microsoft Excel work- Output File Name
books, and CSVs?
1 - Delimiters
2 - First Row Contains Data
3 - Record Limit
4 - Output File Name
6. Which of the following file types support reading in .xlsx
multiple sheets? Select all that apply
1 - .xls
2 - All listed options
3 - .yxdb
1/9
, Alteryx Certification Study Guide
Study online at https://quizlet.com/_g2t4uw
4 - .csv
5 - .xlsx
7. What happens when Designer fail to read in a sheet? A warning mes-
sage appears
A - a warning message appears
B - an error message appears
C - this would never happen in Designer
D- nothing happens
8. The Dynamic Input tool is the only tool required to False
import multiple sheets at once
T/F
9. Data is only created or modified when a workflow with True
a configured Output Data tool is run
T/F
10. Select the statements that are true. 1&4
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.
11. Select all the ways in which a Browse tool can be All the Above
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
2/9
Study online at https://quizlet.com/_g2t4uw
1. Any value entered into the Text Input tool is character- False
ized as a string data type
T/F
2. Cells that are left blank in the Text Input tool are as- Null
signed what value?
A - Empty
B - Null
C - Zero (0)
3. How can data be added to a workflow with the Text All of the above
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
4. The Input Data tool can only connect to files False
T/F
5. Which of the following are present in the configuration Record Limit and
options for Alteryx Databases, Microsoft Excel work- Output File Name
books, and CSVs?
1 - Delimiters
2 - First Row Contains Data
3 - Record Limit
4 - Output File Name
6. Which of the following file types support reading in .xlsx
multiple sheets? Select all that apply
1 - .xls
2 - All listed options
3 - .yxdb
1/9
, Alteryx Certification Study Guide
Study online at https://quizlet.com/_g2t4uw
4 - .csv
5 - .xlsx
7. What happens when Designer fail to read in a sheet? A warning mes-
sage appears
A - a warning message appears
B - an error message appears
C - this would never happen in Designer
D- nothing happens
8. The Dynamic Input tool is the only tool required to False
import multiple sheets at once
T/F
9. Data is only created or modified when a workflow with True
a configured Output Data tool is run
T/F
10. Select the statements that are true. 1&4
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.
11. Select all the ways in which a Browse tool can be All the Above
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
2/9
