Alteryx Advanced Certification Prep
Exam Questions and Answers
All tools in Designer are Macros (T/F) - Correct Answers -False
What file type are Macros saved as? - Correct Answers -.yxmc
Select all that are TRUE
1. Macros use Interface Tools to Generate their configuration windows
2. All Analytical Apps contain at least one macro
3. To open a Macro, a user must have Designer installed on their computer. - Correct
Answers -1 & 3
True or False? Only Standard Macros can include custom help documentation - Correct
Answers -False
Dragging a Macro Input Tool onto a canvas will automatically change the workflow
configuration to which type? - Correct Answers -.Standard Macro
Which Macros are most associated with loops? - Correct Answers -Iterative Macros
Why would you copy an input data tool to a new canvas when creating a Macro? -
Correct Answers -It's faster than creating a template input manually
Ensures the macro process will map correctly to the incoming data
An input data tool can be converted into a macro input tool
A new macro will be searchable in Designer by default. - Correct Answers -False
How can a macro be inserted into an existing workflow? - Correct Answers -Right click
on the canvas & select "Macro" from the "Insert" menu
Create a custom tool palette in "user settings"
Which of the following are true concerning interface tool anchors - Correct Answers -Q
icons represent "question"
Lightning Bolt icons represent "action"
An action tool is required to connect a Q anchor to a Lightning Bolt anchor - Correct
Answers -True
, Which languages can be leveraged to directly modify the function of tools in Designer? -
Correct Answers -XML
In which tools' configuration can you replace a specific string in an expression? -
Correct Answers -Action Tool
When a batch macro is NOT configured for grouping, its behavior will be similar to a
traditional Join - Correct Answers -False
Which tool is exclusively associated with Batch Macros? - Correct Answers -Control
Parameter Tool
Which designer constant is unlocked when a workflow is configured to "Iterative Macro"
- Correct Answers -[Engine.IterationNumber]
Where do you specify which output is the Macro's exit, and which output is the Loop? -
Correct Answers -Interface Designer
Designer starts counting iterations at "0" - Correct Answers –True
Select all of the output file types available in the Render tool - Correct Answers -Word
Document, PDF, HTML
Which Reporting tool has an optional input anchor - Correct Answers -Report Text
What happens when spatial objects intersect - Correct Answers -The resulting object is
the object with the simpler geometry. The resulting object would be a line since it is
simpler than a polygon
Which of the following formulas would create a series that would double each value of
[count] from the previous row? - Correct Answers -If [Row-1:Count]=0
Then 1
Else 2*([Row-1:Count])Endif
In the Function Library, clicking a function once displays a description of that function -
Correct Answers -True
Any dependent files associated with your macro will automatically be included with
your .yxmc file - Correct Answers -false
Which deployment method has built-in version control? - Correct Answers -Saving to
the Gallery
How can you include a macro file in an existing workflow when sharing with others? -
Correct Answers -Export the workflow as a .yxzp file
Save your workflow to the Gallery with dependent assets included
Exam Questions and Answers
All tools in Designer are Macros (T/F) - Correct Answers -False
What file type are Macros saved as? - Correct Answers -.yxmc
Select all that are TRUE
1. Macros use Interface Tools to Generate their configuration windows
2. All Analytical Apps contain at least one macro
3. To open a Macro, a user must have Designer installed on their computer. - Correct
Answers -1 & 3
True or False? Only Standard Macros can include custom help documentation - Correct
Answers -False
Dragging a Macro Input Tool onto a canvas will automatically change the workflow
configuration to which type? - Correct Answers -.Standard Macro
Which Macros are most associated with loops? - Correct Answers -Iterative Macros
Why would you copy an input data tool to a new canvas when creating a Macro? -
Correct Answers -It's faster than creating a template input manually
Ensures the macro process will map correctly to the incoming data
An input data tool can be converted into a macro input tool
A new macro will be searchable in Designer by default. - Correct Answers -False
How can a macro be inserted into an existing workflow? - Correct Answers -Right click
on the canvas & select "Macro" from the "Insert" menu
Create a custom tool palette in "user settings"
Which of the following are true concerning interface tool anchors - Correct Answers -Q
icons represent "question"
Lightning Bolt icons represent "action"
An action tool is required to connect a Q anchor to a Lightning Bolt anchor - Correct
Answers -True
, Which languages can be leveraged to directly modify the function of tools in Designer? -
Correct Answers -XML
In which tools' configuration can you replace a specific string in an expression? -
Correct Answers -Action Tool
When a batch macro is NOT configured for grouping, its behavior will be similar to a
traditional Join - Correct Answers -False
Which tool is exclusively associated with Batch Macros? - Correct Answers -Control
Parameter Tool
Which designer constant is unlocked when a workflow is configured to "Iterative Macro"
- Correct Answers -[Engine.IterationNumber]
Where do you specify which output is the Macro's exit, and which output is the Loop? -
Correct Answers -Interface Designer
Designer starts counting iterations at "0" - Correct Answers –True
Select all of the output file types available in the Render tool - Correct Answers -Word
Document, PDF, HTML
Which Reporting tool has an optional input anchor - Correct Answers -Report Text
What happens when spatial objects intersect - Correct Answers -The resulting object is
the object with the simpler geometry. The resulting object would be a line since it is
simpler than a polygon
Which of the following formulas would create a series that would double each value of
[count] from the previous row? - Correct Answers -If [Row-1:Count]=0
Then 1
Else 2*([Row-1:Count])Endif
In the Function Library, clicking a function once displays a description of that function -
Correct Answers -True
Any dependent files associated with your macro will automatically be included with
your .yxmc file - Correct Answers -false
Which deployment method has built-in version control? - Correct Answers -Saving to
the Gallery
How can you include a macro file in an existing workflow when sharing with others? -
Correct Answers -Export the workflow as a .yxzp file
Save your workflow to the Gallery with dependent assets included
