ALTERYX ADVANCED CERTIFICATION PREP
EXAM/ QUESTIONS WITH CORRECT ANSWERS
VERIFIED 100% CORRECT ( A+ GRADE)
Choose the statement(s) below that are true regarding the RegEx tool's Tokenize
Output Method - ANSWER -The Tokenize method allows for simple parsing with
a single marked group in the regular expression
Which changes can be applied to output columns from the RegEx tool when the
Parse output method is selected? - ANSWER -Name, Size, Data Type
Select the combination of values that can be output from the RegEx Match
function - ANSWER --1, 0
Choose the statements that are true with respect to the RegEx_Replace function: -
ANSWER -Regular Expressions must be quoted, the function CAN use a marked
group, and case sensitivity can be enforced with a 4th parameter
Given the xml sample below, select the names of the child elements
<book>
<title>Harry Potter and the Sorcerer's Stone</title>
<author>J.K. Rowling</author>
<publication>
<country>USA</country>
<year>1998</year>
</publication>
<book> - ANSWER -title, author, publication, country, year
Which of the following can not be selected as an element to parse in the XML
Parse tool? - ANSWER -Cousin Element
, Extensible Markup Language (.xml) files can be read into Designer with the Input
Data tool - ANSWER -True
The JSON Parse tool is found in the Parse tool palette in Designer - ANSWER -
False, Developer tool palette
Which data types can be parsed into separate columns with the JSON Parse tool? -
ANSWER -Float, String, Integer, Boolean (DateTime)
Which of the following file types can be used to read spatial objects into Designer
with the Input tool? - ANSWER -Alteryx databases (.yxdb), Google Earth KML
(.kml), and Esri shapefiles (.shp) can be used to read spatial objects into Designer.
Excel workbooks (.xlsx) do not support spatial objects
A browse tool must be used to view spatial objects in Designer - ANSWER -True
The Spatial Info tool cannot output spatial objects - ANSWER -False
Which of the following statements are true about spatial objects - ANSWER -A
point has zero dimensions
A line is one-dimensional
A polygon is two-dimensional
Which of the following statements are true about spatial objects - ANSWER -The
create points tool does not allow grouping, and neither the create points nor the
poly-build tool can output multiple columns of spatial objects
The Poly-Build tool can output points, lines, and polygons - ANSWER -False, the
tool can only create (poly)lines and polygons as outputs
When using a polygon as the spatial object field of point source in the trade area
tool, its centroid is used to create the trade area polygon output - ANSWER -True
EXAM/ QUESTIONS WITH CORRECT ANSWERS
VERIFIED 100% CORRECT ( A+ GRADE)
Choose the statement(s) below that are true regarding the RegEx tool's Tokenize
Output Method - ANSWER -The Tokenize method allows for simple parsing with
a single marked group in the regular expression
Which changes can be applied to output columns from the RegEx tool when the
Parse output method is selected? - ANSWER -Name, Size, Data Type
Select the combination of values that can be output from the RegEx Match
function - ANSWER --1, 0
Choose the statements that are true with respect to the RegEx_Replace function: -
ANSWER -Regular Expressions must be quoted, the function CAN use a marked
group, and case sensitivity can be enforced with a 4th parameter
Given the xml sample below, select the names of the child elements
<book>
<title>Harry Potter and the Sorcerer's Stone</title>
<author>J.K. Rowling</author>
<publication>
<country>USA</country>
<year>1998</year>
</publication>
<book> - ANSWER -title, author, publication, country, year
Which of the following can not be selected as an element to parse in the XML
Parse tool? - ANSWER -Cousin Element
, Extensible Markup Language (.xml) files can be read into Designer with the Input
Data tool - ANSWER -True
The JSON Parse tool is found in the Parse tool palette in Designer - ANSWER -
False, Developer tool palette
Which data types can be parsed into separate columns with the JSON Parse tool? -
ANSWER -Float, String, Integer, Boolean (DateTime)
Which of the following file types can be used to read spatial objects into Designer
with the Input tool? - ANSWER -Alteryx databases (.yxdb), Google Earth KML
(.kml), and Esri shapefiles (.shp) can be used to read spatial objects into Designer.
Excel workbooks (.xlsx) do not support spatial objects
A browse tool must be used to view spatial objects in Designer - ANSWER -True
The Spatial Info tool cannot output spatial objects - ANSWER -False
Which of the following statements are true about spatial objects - ANSWER -A
point has zero dimensions
A line is one-dimensional
A polygon is two-dimensional
Which of the following statements are true about spatial objects - ANSWER -The
create points tool does not allow grouping, and neither the create points nor the
poly-build tool can output multiple columns of spatial objects
The Poly-Build tool can output points, lines, and polygons - ANSWER -False, the
tool can only create (poly)lines and polygons as outputs
When using a polygon as the spatial object field of point source in the trade area
tool, its centroid is used to create the trade area polygon output - ANSWER -True
