Alteryx Designer Core Exam Questions
and Answers
Text Input Tool - Correct Answers -Manually add data which will be stored in the
workflow.
Methods of Use:
(1) Copy & Paste
(2) Import a File
(3*) Enter values in cells
- Data lives WITHIN the workflow
- Values are static
- Can be shared by sharing the workflow
- Data is automatically categorized to smallest type and size
Data Types:
-Data types may need to match that of other inputs, especially when that data will be
blended with other data
-Be mindful of the characteristics of each data type and how it may impact your
workflow later on.
- Empty values are assigned null values
Input Data Tool - Correct Answers -Bring data into your workflow by selecting a file or
connecting to a database (optionally, using a query).
- Data lives OUTSIDE the workflow
- Values update (are dynamic)
- Must export workflow to share files
- Data is configured based on the file type being imported
-Close all input files to avoid errors
- Previews the first 100 rows of data from the selected file
Output Data Tool - Correct Answers -Output the contents of a data stream to a file or
database
- Has only 1 anchor for INPUT
- Take File/Table Name From Field
, Browse Tool - Correct Answers -View data from a connected tool and view data profile
information, reporting snippets, maps, and behavior analysis information in the data.
Find Replace Tool - Correct Answers -Search for data in one field from one data stream
and replace it with a specified field from a different stream. Similar to an Excel
VLOOKUP
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 transform manual steps into an
automated process. With a repeatable workflow, simply change the input data and click
"Run".
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 existing file. You choose where and how to save results.
Scalability - Correct Answers -Designer accommodates multiple data sources at once,
in the same workflow. There is no row-limit so you can work with your large datasets all
at once. It also means that those sources can exist as varying formats in one workflow.
Append Fields Tool - Correct Answers -Append the fields from a source input to every
record of a target input. Each record of the target input will be duplicated for every
record in the source input.
Join Tool - Correct Answers -Combine two data streams based on common fields (or
record position). In the joined output, each row will contain the data from both inputs.
Union Tool - Correct Answers -Combine two or more data streams with similar
structures based on field names or position. In the output, each column will contain the
data from each input.
- Can accept multiple inputs
- First input connected determines output column names and data types
- Re-name the connections to help identify data sources
- Re-organize the order in which data is combined
Joins Data by stacking vertically based on:
(1) Column Name
(2) Column Position
(3) Manually
and Answers
Text Input Tool - Correct Answers -Manually add data which will be stored in the
workflow.
Methods of Use:
(1) Copy & Paste
(2) Import a File
(3*) Enter values in cells
- Data lives WITHIN the workflow
- Values are static
- Can be shared by sharing the workflow
- Data is automatically categorized to smallest type and size
Data Types:
-Data types may need to match that of other inputs, especially when that data will be
blended with other data
-Be mindful of the characteristics of each data type and how it may impact your
workflow later on.
- Empty values are assigned null values
Input Data Tool - Correct Answers -Bring data into your workflow by selecting a file or
connecting to a database (optionally, using a query).
- Data lives OUTSIDE the workflow
- Values update (are dynamic)
- Must export workflow to share files
- Data is configured based on the file type being imported
-Close all input files to avoid errors
- Previews the first 100 rows of data from the selected file
Output Data Tool - Correct Answers -Output the contents of a data stream to a file or
database
- Has only 1 anchor for INPUT
- Take File/Table Name From Field
, Browse Tool - Correct Answers -View data from a connected tool and view data profile
information, reporting snippets, maps, and behavior analysis information in the data.
Find Replace Tool - Correct Answers -Search for data in one field from one data stream
and replace it with a specified field from a different stream. Similar to an Excel
VLOOKUP
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 transform manual steps into an
automated process. With a repeatable workflow, simply change the input data and click
"Run".
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 existing file. You choose where and how to save results.
Scalability - Correct Answers -Designer accommodates multiple data sources at once,
in the same workflow. There is no row-limit so you can work with your large datasets all
at once. It also means that those sources can exist as varying formats in one workflow.
Append Fields Tool - Correct Answers -Append the fields from a source input to every
record of a target input. Each record of the target input will be duplicated for every
record in the source input.
Join Tool - Correct Answers -Combine two data streams based on common fields (or
record position). In the joined output, each row will contain the data from both inputs.
Union Tool - Correct Answers -Combine two or more data streams with similar
structures based on field names or position. In the output, each column will contain the
data from each input.
- Can accept multiple inputs
- First input connected determines output column names and data types
- Re-name the connections to help identify data sources
- Re-organize the order in which data is combined
Joins Data by stacking vertically based on:
(1) Column Name
(2) Column Position
(3) Manually
