Alteryx – General Exam Questions and
Answers
4 Benefits of Alteryx - Correct Answers -1) Transparency, 2) Repeatability, 3) Safety, 4)
Scalability
Transparency - Correct Answers -You have visibility of all the actions performed on the
data set; the workflow shows what steps were taken and the order in which they were
performed
Repeatability - Correct Answers -Use a workflow to perform manual steps in an
automated process; with a repeatable workflow, just change the input and run the
process again
Safety - Correct Answers -Designer offers a safe development environment for testing,
exploring, and solving; by simply inputting data into the workflow, you are not
overwriting the original file; you choose where and how to save the results
.XLSX (Excel) workbook configuration - Correct Answers -Data stored in tabular format;
can specify record limit (extra files created if limit exceeded); can search subdirectories;
can start import on a specific line; can output file name as a field; can specify 1st row as
headers or data
.YXMD (Alteryx Database) configuration - Correct Answers -Most efficient file type to
import data; can specify record limits; can search subdirectories to import files of a
similar type or structure; can output file name as field
Tool Palette - Correct Answers -Contains the tools used for data manipulation;
separated into categories based on the function they perform; each have a color and
shape combo that is unique
Scalability - Correct Answers -Accommodates multiple data sources at once in the
same workflow; there is no row limit so can accommodate large data sets; those
sources can exist in varying formats in one workflow
4 Components of Alteryx Designer - Correct Answers -1) Tool Palette, 2) Configuration
Window, 3) Canvas, 4) Results Window
3 Ways to Add Tools to the Workflow - Correct Answers -1) Drag and drop from tool
palette, 2) right click and insert from category menu, and 3) add from tool search
Answers
4 Benefits of Alteryx - Correct Answers -1) Transparency, 2) Repeatability, 3) Safety, 4)
Scalability
Transparency - Correct Answers -You have visibility of all the actions performed on the
data set; the workflow shows what steps were taken and the order in which they were
performed
Repeatability - Correct Answers -Use a workflow to perform manual steps in an
automated process; with a repeatable workflow, just change the input and run the
process again
Safety - Correct Answers -Designer offers a safe development environment for testing,
exploring, and solving; by simply inputting data into the workflow, you are not
overwriting the original file; you choose where and how to save the results
.XLSX (Excel) workbook configuration - Correct Answers -Data stored in tabular format;
can specify record limit (extra files created if limit exceeded); can search subdirectories;
can start import on a specific line; can output file name as a field; can specify 1st row as
headers or data
.YXMD (Alteryx Database) configuration - Correct Answers -Most efficient file type to
import data; can specify record limits; can search subdirectories to import files of a
similar type or structure; can output file name as field
Tool Palette - Correct Answers -Contains the tools used for data manipulation;
separated into categories based on the function they perform; each have a color and
shape combo that is unique
Scalability - Correct Answers -Accommodates multiple data sources at once in the
same workflow; there is no row limit so can accommodate large data sets; those
sources can exist in varying formats in one workflow
4 Components of Alteryx Designer - Correct Answers -1) Tool Palette, 2) Configuration
Window, 3) Canvas, 4) Results Window
3 Ways to Add Tools to the Workflow - Correct Answers -1) Drag and drop from tool
palette, 2) right click and insert from category menu, and 3) add from tool search