ALTERYX CERTIFICATION STUDY
GUIDE EXAM QUESTIONS AND
ANSWERS
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
T/F - Answer-False
Which of the following is not an available option for combining data in the Union tool?
A - Manual Configuration
B - Column Position
C - Column Name
D - Data Type - Answer-Data Type
Which of the following statements about the Unique tool are NOT true? Select all that
apply.
1 - The Unique tool is case sensitive
2 - You can select up to 10 columns in one Unique tool
3 - It's best practice to join the results from the U & D outputs - Answer-2 & 3
The Unique tool is case sensitive and will display the last value from the dataset in the
U when duplicate values are found.
T/F - Answer-False
, Choose all of the following processes that can be performed with a Select tool.
1 - Rename columns
2 - Change a data type
3 - Change a column size
4 - Remove columns - Answer-All of the above
The ability to reorder and rename columns, as well as change a column's data type,
exists only in the Select tool.
T/F - Answer-False
The Formula tool is the only tool in Designer in which expressions can be written.
T/F - Answer-False
From the options listed below, how can functions be inserted into the Expression
Editor?
1 - Typing the name of a function directly into the Expression Editor and selecting the
function from the auto-completed options.
2 - Right clicking in the Expression Editor and selecting a function.
3 - Clicking on the Function Library icon to navigate and select a function. - Answer-1
and 3
Select the statement that is false.
A - The Data Preview provides a view of the output in the first record of the incoming
dataset.
B - Only one expression can be written in a single Formula tool.
C - Syntax highlighting distinguishes functions, columns, operators, and text. - Answer-
False - Only one expression can be written in a single Formula tool.
Conditional statements can be used with any data type.
T/F - Answer-True
The functions Null() and IsNull() are found in the same category in the Function Library.
T/F - Answer-False
GUIDE EXAM QUESTIONS AND
ANSWERS
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
T/F - Answer-False
Which of the following is not an available option for combining data in the Union tool?
A - Manual Configuration
B - Column Position
C - Column Name
D - Data Type - Answer-Data Type
Which of the following statements about the Unique tool are NOT true? Select all that
apply.
1 - The Unique tool is case sensitive
2 - You can select up to 10 columns in one Unique tool
3 - It's best practice to join the results from the U & D outputs - Answer-2 & 3
The Unique tool is case sensitive and will display the last value from the dataset in the
U when duplicate values are found.
T/F - Answer-False
, Choose all of the following processes that can be performed with a Select tool.
1 - Rename columns
2 - Change a data type
3 - Change a column size
4 - Remove columns - Answer-All of the above
The ability to reorder and rename columns, as well as change a column's data type,
exists only in the Select tool.
T/F - Answer-False
The Formula tool is the only tool in Designer in which expressions can be written.
T/F - Answer-False
From the options listed below, how can functions be inserted into the Expression
Editor?
1 - Typing the name of a function directly into the Expression Editor and selecting the
function from the auto-completed options.
2 - Right clicking in the Expression Editor and selecting a function.
3 - Clicking on the Function Library icon to navigate and select a function. - Answer-1
and 3
Select the statement that is false.
A - The Data Preview provides a view of the output in the first record of the incoming
dataset.
B - Only one expression can be written in a single Formula tool.
C - Syntax highlighting distinguishes functions, columns, operators, and text. - Answer-
False - Only one expression can be written in a single Formula tool.
Conditional statements can be used with any data type.
T/F - Answer-True
The functions Null() and IsNull() are found in the same category in the Function Library.
T/F - Answer-False