ALTERYX ADVANCED CERTIFICATION
PREP
EXAM NEWEST WITH
COMPLETE QUESTIONS AND ANSWERS
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> - ✔✔✔ Correct Answer > title, author, publication, country, year
Which of the following can not be selected as an element to parse in the XML
Parse tool? - ✔✔✔ Correct Answer > Cousin Element
Extensible Markup Language (.xml) files can be read into Designer with the Input
Data tool - ✔✔✔ Correct Answer > True
The JSON Parse tool is found in the Parse tool palette in Designer - ✔✔✔ Correct
Answer > False, Developer tool palette
1
,Which data types can be parsed into separate columns with the
JSON Parse tool? - ✔✔✔ Correct 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? - ✔✔✔ Correct 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 - ✔✔✔ Correct
Answer > True
The Spatial Info tool cannot output spatial objects - ✔✔✔ Correct Answer > False
Which of the following statements are true about spatial objects - ✔✔✔ Correct
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 - ✔✔✔ Correct
Answer > The create points tool does not allow grouping, and neither the create
points nor the polybuild tool can output multiple columns of spatial objects
The Poly-Build tool can output points, lines, and polygons -
✔✔✔ Correct Answer > False, the tool can only create
(poly)lines and polygons as outputs
2
, 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 - ✔✔✔ Correct
Answer > True
Which of the following statements regarding the Trade Area tool configuration are
true, based on the tool's output? - ✔✔✔ Correct Answer > The Eliminate Overlap
checkbox is selected
The Include in Output checkbox for SpatialObject Field of Point Source in Output
is selected
The Split_IsHole column is output from the Poly-Splot tool when the tool is
configured to split into points - ✔✔✔ Correct
Answer > False, the Split_IsHole column is output when the Poly-Split tool is
configured to split into detailed regions
The Distance tool can only calculate the distance between two point spatial objects
- ✔✔✔ Correct Answer > False, it can calculate the distance between a point (or
centroid source), and another point, line, or polygon
Which of the following are possible outputs from the distance tool? - ✔✔✔
Correct Answer > The Distance tool can output the distance (in meters), the
cardinal direction, and the direction (in degrees) between two spatial objects
However, it cannot output a line spatial object that connects the source and
destination spatial objects
The output spatial object from the intersection of a polygon and a line is a polygon
- ✔✔✔ Correct Answer > False
3
PREP
EXAM NEWEST WITH
COMPLETE QUESTIONS AND ANSWERS
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> - ✔✔✔ Correct Answer > title, author, publication, country, year
Which of the following can not be selected as an element to parse in the XML
Parse tool? - ✔✔✔ Correct Answer > Cousin Element
Extensible Markup Language (.xml) files can be read into Designer with the Input
Data tool - ✔✔✔ Correct Answer > True
The JSON Parse tool is found in the Parse tool palette in Designer - ✔✔✔ Correct
Answer > False, Developer tool palette
1
,Which data types can be parsed into separate columns with the
JSON Parse tool? - ✔✔✔ Correct 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? - ✔✔✔ Correct 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 - ✔✔✔ Correct
Answer > True
The Spatial Info tool cannot output spatial objects - ✔✔✔ Correct Answer > False
Which of the following statements are true about spatial objects - ✔✔✔ Correct
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 - ✔✔✔ Correct
Answer > The create points tool does not allow grouping, and neither the create
points nor the polybuild tool can output multiple columns of spatial objects
The Poly-Build tool can output points, lines, and polygons -
✔✔✔ Correct Answer > False, the tool can only create
(poly)lines and polygons as outputs
2
, 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 - ✔✔✔ Correct
Answer > True
Which of the following statements regarding the Trade Area tool configuration are
true, based on the tool's output? - ✔✔✔ Correct Answer > The Eliminate Overlap
checkbox is selected
The Include in Output checkbox for SpatialObject Field of Point Source in Output
is selected
The Split_IsHole column is output from the Poly-Splot tool when the tool is
configured to split into points - ✔✔✔ Correct
Answer > False, the Split_IsHole column is output when the Poly-Split tool is
configured to split into detailed regions
The Distance tool can only calculate the distance between two point spatial objects
- ✔✔✔ Correct Answer > False, it can calculate the distance between a point (or
centroid source), and another point, line, or polygon
Which of the following are possible outputs from the distance tool? - ✔✔✔
Correct Answer > The Distance tool can output the distance (in meters), the
cardinal direction, and the direction (in degrees) between two spatial objects
However, it cannot output a line spatial object that connects the source and
destination spatial objects
The output spatial object from the intersection of a polygon and a line is a polygon
- ✔✔✔ Correct Answer > False
3
