Alteryx Certification Study Guide Latest Updated | Graded A

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