Alteryx Advanced Certification Prep all 350 QUESTIONS AND CORRECT DETAILED SOLUTIONS LATEST UPDATED VERSION JUST RELEASED

Page 1 of 111




Alteryx Advanced Certification Prep all 350
QUESTIONS AND CORRECT DETAILED SOLUTIONS
LATEST UPDATED VERSION JUST RELEASED


Question: What happens in the Configuration Window of the Browse Tool if there is only one

value in each column? - CORRECT ANSWER✔✔"Only one value" message displays




Question: What happens in the Configuration Window of the Browse Tool if each value in the

columns is unique? - CORRECT ANSWER✔✔"All values are unique" message displays




Question: In the Configuration Window of the Browse Tool, what are the two categories you

can filter based on? - CORRECT ANSWER✔✔Fields (columns) and Data Type




Question: What is the data profiling limit of the Browse Tool? - CORRECT ANSWER✔✔300 MB




Question: Is record size the same as file size? - CORRECT ANSWER✔✔No

, Page 2 of 111


Question: How to convert Browse Tool to Macro Output Tool - CORRECT ANSWER✔✔1.) Right-

click the Browse tool in your workflow.


2.) Select Convert To Macro Output.


3.) Configure the tool.




Question: How to convert Browse Tool to Output Data Tool - CORRECT ANSWER✔✔1.) Right-

click the Browse tool in your workflow.


2.) Select Convert To Output Data.


3.) Configure the tool.




Question: What does the "Append Suffix to File/Table Name" option do to the output data file?

- CORRECT ANSWER✔✔Appends the selected field name to the end of the name of the selected

table.




Question: What does the "Prepend Prefix to File/Table Name" option do to the output data

file? - CORRECT ANSWER✔✔Prepends the selected field name to the beginning of the name of

the selected table.

, Page 3 of 111




Q;What are the two sections of the Input Data Configuration window? - CORRECT

ANSWER✔✔Connect a File or Database AND Options




Question: What does entering "*" do with an input file? - CORRECT ANSWER✔✔It brings in

anything that starts with the characters before the "*" and anything after it




Question: What does entering "?" do with an input file? - CORRECT ANSWER✔✔It brings in

anything that starts with the characters before the "?" plus one character




Question: What are the limits for the data layout preview window in the Input Data tool? -

CORRECT ANSWER✔✔100 records or fewer in wide files




Question: How do you convert an Output Data Tool to an Input Data Tool? - CORRECT

ANSWER✔✔1.) Right-click the Output Data tool you want to convert to an Input Data tool.


2.) Select Convert To Input Data.

, Page 4 of 111


Question: What are the 3 ways to add the Browse tool to the workflow? - CORRECT

ANSWER✔✔-Drag a Browse tool to the canvas, and connect it to an upstream tool.


-Right-click on a tool on the canvas and select Add Browse After.


-Use the Shift+Ctrl+B keyboard shortcut and select the tools in a workflow.




Question: Without the browse tool, up to how much data shows in the Results window? -

CORRECT ANSWER✔✔1 MB of data




Question: How do you disable a browse tool? - CORRECT ANSWER✔✔-Select a random point

on the canvas to display the Workflow - Configuration window.


-In the configuration window, select Runtime.


-Check Disable All Browse Tools to make the Browse tools in the workflow unavailable. To

enable Browse tools, uncheck Disable All Browse Tools.




Question: What happens in the Configuration Window of the Browse Tool if a column's data

type is not compatible with data profiling? - CORRECT ANSWER✔✔"No Profiling Available"

message will display