Page 1 of 57
ALTERYX ADVANCED CERTIFICATION EXAM
COMPLETE 300 QUESTIONS AND VERIFIED
SOLUTIONS LATEST UPDATE THIS YEAR
ALTERYX ADVANCED CERTIFICATION EXAM 1
QUESTION: 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
QUESTION: 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
, Page 2 of 57
QUESTION: 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
QUESTION: The Dynamic Input tool is the only tool required to import multiple sheets at once
T/F - ANSWER-False
QUESTION: Data is only created or modified when a workflow with a configured Output Data
tool is run
T/F - ANSWER-True
QUESTION: Select the statements that are true.
, Page 3 of 57
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
QUESTION: 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
QUESTION: 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
, Page 4 of 57
QUESTION: 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
QUESTION: 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
QUESTION: Columns classified as a numeric type may be joined to columns classified as any
data type when joining by specific fields
T/F - ANSWER-False
ALTERYX ADVANCED CERTIFICATION EXAM
COMPLETE 300 QUESTIONS AND VERIFIED
SOLUTIONS LATEST UPDATE THIS YEAR
ALTERYX ADVANCED CERTIFICATION EXAM 1
QUESTION: 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
QUESTION: 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
, Page 2 of 57
QUESTION: 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
QUESTION: The Dynamic Input tool is the only tool required to import multiple sheets at once
T/F - ANSWER-False
QUESTION: Data is only created or modified when a workflow with a configured Output Data
tool is run
T/F - ANSWER-True
QUESTION: Select the statements that are true.
, Page 3 of 57
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
QUESTION: 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
QUESTION: 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
, Page 4 of 57
QUESTION: 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
QUESTION: 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
QUESTION: Columns classified as a numeric type may be joined to columns classified as any
data type when joining by specific fields
T/F - ANSWER-False
