Alteryx Advanced Designer Certification
Exam Questions and Answers
What's the Multi-Field Formula Tool and what is its main difference when compared to
the standard Formula Tool? - Correct Answers -The Multi-Field Formula Tool allows the
application of a function across multiple fields or columns of data all at once.
The Multi-Field Formula Tool is limited to one formula expression per Tool.
What are the main differences between the Multi-Row Formula Tool and the standard
Formula Tool? - Correct Answers -The Multi-Row Formula Tool can use values from
other rows via referencing, but can only apply a single expression by tool.
What are the two methods for filling values in the Multi-Row Formula Tool? - Correct
Answers -- Value Fill: repeats the same value over and over.
- Series Fill: follows a pattern until the end.
What's the Generate Rows Tool? - Correct Answers -Use Generate Rows to create new
rows of data at the record level. You can use this tool to create a sequence of numbers,
transactions, or dates.
The Generate Rows tool follows a process to generate rows of data. That process
consists of an initial expression, then a loop expression that builds subsequent rows
based on a condition until such condition evaluates to False.
When can Pivot tables be created using the Table Tool? - Correct Answers -When
connecting a Crosstab tool to a Table tool.
What are the requirements to create the three types of spatial objects? - Correct
Answers -- Points: x and y coordinates.
- Line: at least two points.
- Polygons: a sequence of lines or points.
What's the Create Points tool used for? - Correct Answers -It's used to create a point-
type spatial object by specifying input fields containing the x and y coordinates.
What's the Poly-Build tool used for? - Correct Answers -Takes a group of spatial point
objects and draws a polygon or polyline in a specific sort order to represent that group
of points.
, Which Table tool element can be configured in the style editor of tool? - Correct
Answers -The text border.
Does the Report tool require an incoming connection? - Correct Answers -No, it has an
optional input anchor.
Can report snippets be laid out horizontally and vertically with a single Layout tool? -
Correct Answers -No, a single Layout tool can only have a single layout configuration.
Can the Layout tool accept multiple incoming connections strings? - Correct Answers -
No, the Layout tool can only accept a single incoming connection string.
To join by multiple connections one can use a Join Multiple tool with Join by Position
selected.
What is a Macro in Alteryx? - Correct Answers -A workflow or group of tools collapsed
into a single tool. They are useful to save time and space, and solve problems with
repetitive processes, or to share an analytic process as a tool.
What's the difference between an Analytic App (.yxwz) and a Macro (.yxmc)? - Correct
Answers -An Analytical App is an interface that allows for the limited customization of a
workflow.
A Macro is intended to be a piece of a workflow, meaning a macro can be a part of an
Analytical App.
What are the three types of Macros that exist in Alteryx? - Correct Answers -Standard,
batch, and iterative macros.
What is a Standard Macro in Alteryx? - Correct Answers -A workflow or group of tools
that have been combined into a single tool.
What is a Batch Macro in Alteryx? - Correct Answers -A macro that runs a process
using unique instructions for different types of data.
Records will run through a macro and will be split through user-defined groups, with a
different process being applied to each group.
Batch macros can also be configured to run several sets of instructions into the entire
dataset.
Batch macros require a Control Parameter tool. Dropping a Control Parameter tool into
the workflow will automatically set the workflow to a Batch Macro.
Exam Questions and Answers
What's the Multi-Field Formula Tool and what is its main difference when compared to
the standard Formula Tool? - Correct Answers -The Multi-Field Formula Tool allows the
application of a function across multiple fields or columns of data all at once.
The Multi-Field Formula Tool is limited to one formula expression per Tool.
What are the main differences between the Multi-Row Formula Tool and the standard
Formula Tool? - Correct Answers -The Multi-Row Formula Tool can use values from
other rows via referencing, but can only apply a single expression by tool.
What are the two methods for filling values in the Multi-Row Formula Tool? - Correct
Answers -- Value Fill: repeats the same value over and over.
- Series Fill: follows a pattern until the end.
What's the Generate Rows Tool? - Correct Answers -Use Generate Rows to create new
rows of data at the record level. You can use this tool to create a sequence of numbers,
transactions, or dates.
The Generate Rows tool follows a process to generate rows of data. That process
consists of an initial expression, then a loop expression that builds subsequent rows
based on a condition until such condition evaluates to False.
When can Pivot tables be created using the Table Tool? - Correct Answers -When
connecting a Crosstab tool to a Table tool.
What are the requirements to create the three types of spatial objects? - Correct
Answers -- Points: x and y coordinates.
- Line: at least two points.
- Polygons: a sequence of lines or points.
What's the Create Points tool used for? - Correct Answers -It's used to create a point-
type spatial object by specifying input fields containing the x and y coordinates.
What's the Poly-Build tool used for? - Correct Answers -Takes a group of spatial point
objects and draws a polygon or polyline in a specific sort order to represent that group
of points.
, Which Table tool element can be configured in the style editor of tool? - Correct
Answers -The text border.
Does the Report tool require an incoming connection? - Correct Answers -No, it has an
optional input anchor.
Can report snippets be laid out horizontally and vertically with a single Layout tool? -
Correct Answers -No, a single Layout tool can only have a single layout configuration.
Can the Layout tool accept multiple incoming connections strings? - Correct Answers -
No, the Layout tool can only accept a single incoming connection string.
To join by multiple connections one can use a Join Multiple tool with Join by Position
selected.
What is a Macro in Alteryx? - Correct Answers -A workflow or group of tools collapsed
into a single tool. They are useful to save time and space, and solve problems with
repetitive processes, or to share an analytic process as a tool.
What's the difference between an Analytic App (.yxwz) and a Macro (.yxmc)? - Correct
Answers -An Analytical App is an interface that allows for the limited customization of a
workflow.
A Macro is intended to be a piece of a workflow, meaning a macro can be a part of an
Analytical App.
What are the three types of Macros that exist in Alteryx? - Correct Answers -Standard,
batch, and iterative macros.
What is a Standard Macro in Alteryx? - Correct Answers -A workflow or group of tools
that have been combined into a single tool.
What is a Batch Macro in Alteryx? - Correct Answers -A macro that runs a process
using unique instructions for different types of data.
Records will run through a macro and will be split through user-defined groups, with a
different process being applied to each group.
Batch macros can also be configured to run several sets of instructions into the entire
dataset.
Batch macros require a Control Parameter tool. Dropping a Control Parameter tool into
the workflow will automatically set the workflow to a Batch Macro.
