Alteryx Exam- Tools Questions and Answers | Graded A

Alteryx Exam- Tools Questions and
Answers



Record ID - Correct Answers -Assigns a unique numeric value to each row of data

Formula - Correct Answers -Create new data fields based on expression or by
assigning a data relationship, or to update an existing field, can also reorder fields and
change field types

Multi-Field Formula - Correct Answers -Applies the same expression to all selected
columns

Text to Columns - Correct Answers -Able to split field by delimiter into a set of columns
and then can rename using the select node

Categorical Data - Correct Answers -Think dictionaries from Python, nominal

Binary Data - Correct Answers -1,0

Boolean - Correct Answers -When states are represented as true or false

Formula` - Correct Answers -Create new data fields based on expression or by
assigning a data relationship, or to update an existing field, can also reorder fields and
change field types

Filter Tool - Examples of Filtering Types - Correct Answers -- Greater Than Filter
- Basic Filter, Is Not Null
- Basic Filter, Date Expressions (Fixed or Dynamic)
- Basic Filter, Date and Period Expressions
- Custom Filter, Multiple Columns

Dictionary Order is checked - Correct Answers -Why would 22 be placed before 4 in
descending order in the sort tool?

Replace - Correct Answers -Replaces a string that matches the specified regular
expression with another string specified in the Replace option

Parse - Correct Answers -Extracts any group specified and places each in a separate
column

, Match - Correct Answers -Test if a string matches the specified regular expression

Filter - Correct Answers -Allows you to filter out data you want by choosing specific
criteria to filter the whole data set

Sort - Correct Answers -Allows sorting of data in ascending or descending order (sorts
based on first field)

Sample - Correct Answers -Limit the data to a certain number, percentage, or random
set of records out of the whole data set

Random Sample % - Correct Answers -Generates a random number or percentage of
records passing through the data stream

Unique - Correct Answers -Separate data into two streams based on the fields of the
user's choosing

Inner Join - Correct Answers -Both sides have to match, only those records are returned

Left Unjoin - Correct Answers -Show records (and their attributes) that only exist in the
left table

Right Unjoin - Correct Answers -Show records (and attributes) that only exists in the
right table

Left Outer Join - Correct Answers -Inner join + left unjoin

Right Outer Join - Correct Answers -Inner join + right union

Full Outer Join - Correct Answers -Everything in both tables; inner join + left unjoin +
right unjoin

Step 1- Define project objectives - Correct Answers -Define project objectives

(specify business problem, acquire subject matter expertise, define unit of analysis and
prediction target, prioritize modeling criteria, consider risks and success criteria, decide
whether to continue)

Step 2- Acquire and explore data - Correct Answers -Acquire and explore data

find appropriate data, merge data into single table, conduct exploratory data analysis,
find and remove any target leakage, feature engineering)

Step 3- Model Data - Correct Answers -Model Data