Designer Core - Data Preparation

Question 1

Which In/Out (Green) tools are on this exam?

Answer 1

Browse, Input Data, Output Data, and Text Input

Question 2

Which preparation (Blue) tools are on this exam?

Answer 2

Data Cleansing, Filter, Formula, Select Records, Sample, Select, Unique, and Sort

Question 3

Select all the ways in which a Browse tool can be added to the Canvas:

1. Right click a tool on the Canvas and select “Add Browse After”
2. Select a tool on the Canvas and hit CTRL + Shift + B
3. Drag a Browse tool on the Canvas from the Tool Palette

Answer 3

All 3

Question 4

True or False? The Filter tool includes two output anchors.

Answer 4

True

Question 5

True or False? Data is only created or modified when a workflow with a configured Output Data tool is run

Answer 5

True

Question 6

What does “Take File/Field Name from Table” mean on the Output tool?

Answer 6

It means that you can create multiple output files based on field names

Question 7

True or False? The Input Data tool can only connect to files.

Answer 7

False

Question 8

Which of the following are present in the configuration options for Alteryx Databases, Microsoft Excel workbooks, and CSVs? Select all that apply.
1. First Row Contains Data
2. Delimiters
3. Record Limit
4. Output File Name as Field

Answer 8

3 and 4

Question 9

If a cell in a field has leading spaces, then the color of the data quality bar for that portion of data would be:

Answer 9

Red

Question 10

If a cell in a field is [Null], then the color of the data quality bar for that portion of data would be:

Answer 10

Yellow

Question 11

If a field has no leading and trailing white space and no Null cells, then the color of the data quality bar would be:

Answer 11

Green

Question 12

True or False? The Formula tool is the only tool in Alteryx where you can create expressions

Answer 12

False. There are 14 tools in Designer that have an expression editor. You can enter functions in any of them.

Question 13

From the options listed below, how can functions be inserted into the Expression Editor?

1. Typing the name of a function directly into the Expression Editor and selecting the function from the auto-completed options
2. Right clicking in the Expression Editor and selecting a function
3. Clicking on the Function Library icon to navigate and select a function

Answer 13

1 and 3

Question 14

True or false? Conditional statements can be used with any data type.

Answer 14

True. All data types may be manipulated by conditional statements

Question 15

True or False? Null() and IsNull() is found in the same category in the Functions library

Answer 15

False. Null() is in the “Specialized” category, while IsNull() is in the “Test” category

Question 16

Which expression would convert Null values in the column [Status] to the value “Not available”?

Answer 16

IF IsNull([Status]) THEN “Not Available” ELSE [Status] ENDIF