Alteryx Advanced Certification Exam
Which data investigation tool provides remarks and suggestion on data quality? - (ANSWER)Field
Summary Tool
Which correlation tool is effective at measuring any arbitrary monotonic relationship between 2
variables? - (ANSWER)Spearman Correlation Tool
Which correlation tool only measures how well the data fits a linear model? - (ANSWER)Pearson
Correlation Tool
Which correlation tool can measure correlation between more than 2 variables? - (ANSWER)Pearson
Correlation Tool
Which correlation tool offers a group by option to measure correlations between 2 values within specific
groups? - (ANSWER)Spearman Correlation Tool
Which tool allows us to measure covariance bt. 2 or more variables? - (ANSWER)Pearson Correlation
Tool
In which data investigation tool can we find the p-values for correlations? - (ANSWER)Association
Analysis Tool
How to interpret the output of the Spearman Correlation tool? - (ANSWER)A positive correlation
indicates that when one variable increases, the other will also increase. A negative correlation indicates
that as one variable increases, the other will decrease. Results close to 1 indicate a perfect correlation,
while 0 indicates no correlation.
Which tool places reporting snippets (maps, text, images, etc.) on top of one another? -
(ANSWER)Overlay Tool
What are the ways the Report Text tool can accept incoming data? - (ANSWER)- Create new field for this
text (doesn't need to be connected to a tool with incoming data)
, Alteryx Advanced Certification Exam
- attach text to existing field (text can be populated from available columns)
- attach another report text tool to create a single element
- expert mode: treat text as raw PXCML
At what level, conditional formatting of Tables using the reporting tools can be done? - (ANSWER)Field
Level and Row Level
What are the ways the Render tool can write out reporting snippets? - (ANSWER)- create a temporary
file/save a file to a specified directory
- batch outputting by using "Group Data Into Separate Reports"
- add header/footer by checking the header and footer options
How to achieve batch reporting with the Reporting tools? - (ANSWER)Table tool: Group by
Interactive Chart: Batch tab, under Group By
Render tool: Group Data into Separate Reports -> select the field to group on
Which spatial tools can generate the centroid of a polygon? - (ANSWER)- Formula
- Sumarize
- Spatial Info
True or False:
When using 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
True or false:
Which data investigation tool provides remarks and suggestion on data quality? - (ANSWER)Field
Summary Tool
Which correlation tool is effective at measuring any arbitrary monotonic relationship between 2
variables? - (ANSWER)Spearman Correlation Tool
Which correlation tool only measures how well the data fits a linear model? - (ANSWER)Pearson
Correlation Tool
Which correlation tool can measure correlation between more than 2 variables? - (ANSWER)Pearson
Correlation Tool
Which correlation tool offers a group by option to measure correlations between 2 values within specific
groups? - (ANSWER)Spearman Correlation Tool
Which tool allows us to measure covariance bt. 2 or more variables? - (ANSWER)Pearson Correlation
Tool
In which data investigation tool can we find the p-values for correlations? - (ANSWER)Association
Analysis Tool
How to interpret the output of the Spearman Correlation tool? - (ANSWER)A positive correlation
indicates that when one variable increases, the other will also increase. A negative correlation indicates
that as one variable increases, the other will decrease. Results close to 1 indicate a perfect correlation,
while 0 indicates no correlation.
Which tool places reporting snippets (maps, text, images, etc.) on top of one another? -
(ANSWER)Overlay Tool
What are the ways the Report Text tool can accept incoming data? - (ANSWER)- Create new field for this
text (doesn't need to be connected to a tool with incoming data)
, Alteryx Advanced Certification Exam
- attach text to existing field (text can be populated from available columns)
- attach another report text tool to create a single element
- expert mode: treat text as raw PXCML
At what level, conditional formatting of Tables using the reporting tools can be done? - (ANSWER)Field
Level and Row Level
What are the ways the Render tool can write out reporting snippets? - (ANSWER)- create a temporary
file/save a file to a specified directory
- batch outputting by using "Group Data Into Separate Reports"
- add header/footer by checking the header and footer options
How to achieve batch reporting with the Reporting tools? - (ANSWER)Table tool: Group by
Interactive Chart: Batch tab, under Group By
Render tool: Group Data into Separate Reports -> select the field to group on
Which spatial tools can generate the centroid of a polygon? - (ANSWER)- Formula
- Sumarize
- Spatial Info
True or False:
When using 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
True or false:
