A03 Practice Quiz for Alteryx Interactive
Lessons (53 Questions) with Verified Answers
3
Given the Transpose Tool's configuration below, how many columns will appear in
the output?
The Unique tool is case-sensitive
Which of the following statements about the Unique tool is True?
It's best practice to join the results from the U & D outputs
You can select up to 10 columns in one Unique tool
The Unique can change the case of the characters in a field.
The Unique tool is case-sensitive
The functions Null() and IsNull() are found in the same category in the Function
Library.
Which of the following statements is False?
Conditional statements can be used with any data type.
Math functions can only be used on numeric data types.
The functions Null() and IsNull() are found in the same category in the Function
Library.
A column's datatype can change in the course of a workflow.
Replace()
Which of the following functions replace every occurrence of a target string or
character?
DateTimeAdd([Start Date], -1, "years")
, Which expression would output the value in the column [Output] in the table
below?
Start Date Output
2017-01-01 2016-01-01
Partial field matching
Which features are associated with the Find Replace tool?
Join by Position
Based on the results below, which method was used to join the two tables?
IIF([Animals]="Cats", "Rule","Drool")
Which of the following expressions would not produce the values in the column
[Status] in the table?
Finance
Reporting
Numeric
Which of the following function categories have Action Properties?
All of the listed
Finance
Reporting
Numeric
Select a tool on the Canvas and hit Alt+Shift+B
Which is not a way that a Browse tool can be added to the Canvas?
One (1)
Based on the table below, how many output files will be produced when the Output
Lessons (53 Questions) with Verified Answers
3
Given the Transpose Tool's configuration below, how many columns will appear in
the output?
The Unique tool is case-sensitive
Which of the following statements about the Unique tool is True?
It's best practice to join the results from the U & D outputs
You can select up to 10 columns in one Unique tool
The Unique can change the case of the characters in a field.
The Unique tool is case-sensitive
The functions Null() and IsNull() are found in the same category in the Function
Library.
Which of the following statements is False?
Conditional statements can be used with any data type.
Math functions can only be used on numeric data types.
The functions Null() and IsNull() are found in the same category in the Function
Library.
A column's datatype can change in the course of a workflow.
Replace()
Which of the following functions replace every occurrence of a target string or
character?
DateTimeAdd([Start Date], -1, "years")
, Which expression would output the value in the column [Output] in the table
below?
Start Date Output
2017-01-01 2016-01-01
Partial field matching
Which features are associated with the Find Replace tool?
Join by Position
Based on the results below, which method was used to join the two tables?
IIF([Animals]="Cats", "Rule","Drool")
Which of the following expressions would not produce the values in the column
[Status] in the table?
Finance
Reporting
Numeric
Which of the following function categories have Action Properties?
All of the listed
Finance
Reporting
Numeric
Select a tool on the Canvas and hit Alt+Shift+B
Which is not a way that a Browse tool can be added to the Canvas?
One (1)
Based on the table below, how many output files will be produced when the Output
