ACC 324 Alteryx Practice Questions
with 100% Correct Answers
Which is not a way to add a tool to Canvas in Alteryx Designer?
A. Double Clicking a Tool in the Tool Palette
B. Drag a tool from the Tool Palette and drop it on the Canvas.
C. Search for a tool and drag the tool from the Search results onto the Canvas.
D. Right clicking on the Canvas and selecting the tool from the list of tool categories. -
Answer-Double Clicking a Tool in the Tool Palette
The data type of Score filed is String. Based on the result, which option in the Sort tool
was used?
Score
1
1
2
22
4
A. "Score" is sorted in ascending order and "Use Dictionary Order" is checked.
B. "Score" is sorted in descending order and "Use Dictionary Order" is checked.
C. "Score" is sorted in descending order and "Use Dictionary Order" is unchecked.
D. "Score" is sorted in ascending order and "Use Dictionary Order" is unchecked. -
Answer-"Score" is sorted in ascending order and "Use Dictionary Order" is unchecked.
Based on the results below, which method was used to join the two tables?
A. Join by Specific Fields based on Type and Height
B. Join by Specific Fields based on Type
C. Join by Position
D. Join by Specific Fields based on Type, Height and Health - Answer-Join by Position
Which of the following options is not a data type recognized in Designer?
A. String
B. Auto
C. DateTime
D. Numeric - Answer-Auto
, Which of the header values below would have characters converted to underscores
when output by the Cross Tab tool?
A. A1
B. All listed
C. b&b
D. Ayx - Answer-b&b
Which of the following statements is True?
A. The Formula tool is the only tool in Designer in which expressions can be written.
B. 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.
C. The Unique tool is case sensitive and will display the last value from the dataset in
the U output when duplicate values are found.
D. The DateTimeDiff() function will never return a negative value. - Answer-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.
Which of the following functions replace every occurrence of a target string or
character?
A. ReplaceFirst()
B. Replace()
C. FindString()
D. ReplaceChar() - Answer-Replace()
Which of the following statements is False?
A. The functions Null() and IsNull() are found in the same category in the Function
Library.
B. Math functions can only be used on numeric data types.
C. Conditional statements can be used with any data type.
D. A column's datatype can change in the course of a workflow. - Answer-The functions
Null() and IsNull() are found in the same category in the Function Library.
An input dataset contains 54 records. With the give configuration window, how many
records will be output?
A. 17
B. 36
C. Impossible to tell
D. 0 - Answer-Impossible to Tell
Which of the following is not an available option for combining data in the Union tool?
with 100% Correct Answers
Which is not a way to add a tool to Canvas in Alteryx Designer?
A. Double Clicking a Tool in the Tool Palette
B. Drag a tool from the Tool Palette and drop it on the Canvas.
C. Search for a tool and drag the tool from the Search results onto the Canvas.
D. Right clicking on the Canvas and selecting the tool from the list of tool categories. -
Answer-Double Clicking a Tool in the Tool Palette
The data type of Score filed is String. Based on the result, which option in the Sort tool
was used?
Score
1
1
2
22
4
A. "Score" is sorted in ascending order and "Use Dictionary Order" is checked.
B. "Score" is sorted in descending order and "Use Dictionary Order" is checked.
C. "Score" is sorted in descending order and "Use Dictionary Order" is unchecked.
D. "Score" is sorted in ascending order and "Use Dictionary Order" is unchecked. -
Answer-"Score" is sorted in ascending order and "Use Dictionary Order" is unchecked.
Based on the results below, which method was used to join the two tables?
A. Join by Specific Fields based on Type and Height
B. Join by Specific Fields based on Type
C. Join by Position
D. Join by Specific Fields based on Type, Height and Health - Answer-Join by Position
Which of the following options is not a data type recognized in Designer?
A. String
B. Auto
C. DateTime
D. Numeric - Answer-Auto
, Which of the header values below would have characters converted to underscores
when output by the Cross Tab tool?
A. A1
B. All listed
C. b&b
D. Ayx - Answer-b&b
Which of the following statements is True?
A. The Formula tool is the only tool in Designer in which expressions can be written.
B. 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.
C. The Unique tool is case sensitive and will display the last value from the dataset in
the U output when duplicate values are found.
D. The DateTimeDiff() function will never return a negative value. - Answer-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.
Which of the following functions replace every occurrence of a target string or
character?
A. ReplaceFirst()
B. Replace()
C. FindString()
D. ReplaceChar() - Answer-Replace()
Which of the following statements is False?
A. The functions Null() and IsNull() are found in the same category in the Function
Library.
B. Math functions can only be used on numeric data types.
C. Conditional statements can be used with any data type.
D. A column's datatype can change in the course of a workflow. - Answer-The functions
Null() and IsNull() are found in the same category in the Function Library.
An input dataset contains 54 records. With the give configuration window, how many
records will be output?
A. 17
B. 36
C. Impossible to tell
D. 0 - Answer-Impossible to Tell
Which of the following is not an available option for combining data in the Union tool?
