Learning Path

Which of the following options is not a data type recognized in Designer?

Auto

A columns datatype can chnage in the course of a workflow

True

Select all of the value that are included in a data stream’s metadata in Designer

Name, Type, Size, Source

All of the following sampling methods are available in the sample tool

First N rows

Last N rows

Skip 1st N rows

1 of every N row

1 in N chance to include each row

First N% of rows

Which of the following sample tool configurations would produce the results from this input dataset run after run

1 of N chance to include each row

1 in N chance to include each row means the resulting # of records will be equivalent to 1/N of the records in the original dataset

False

The filter tool includes two output anchors

True

Select the expression that was used in the filter tool to create the true output below

OR

The sort tool can only sort one column of data

false

Uppercase to lowercase

Default sort behavior

Processes that can be performed with a select tool

Change a data type

Rename columns

Remove columns

Change a column size

The summarize tool can apply summary processes to spaital, string, and numeric datatypes

true

Which of the following function categories have action properties

string and finance data types

The functions null and isNull are found in the same category in the function library

False null is in the specialized category, while isNull in the test category

test null values

isNull function is required to test null values

The datetimediff function will never return a negative value

false

negative values indicate dt2>dt1

positive values indicate dt1>dt2

Match functions can only be used on numeric data types

True

Which function category would contain the function “addition”

Operator 

Trim Left()

removes specificed characters from the beginning of a string

Which of the following functions replace every occurence of a target string or character

Replace()

ReplaceChar()

Conditional statements can be used with any data type

True

The formula tool is the only tool in designer in which expressions can be written

False

How can functions be inserted into the expression editor

You can type functions into the editor or use the function library to insert functions

Columns classfied as numeric data type may be joined to columns classfied as any data type when joining by specific fields

False- when joining b y specific fields, the data types of columns used to join must match

Which of the following is not an avaliable option for combining data in the union tool

data can not be combined by data type in the union tool

Unique tool 

is not limited to 10 columns

The unique tool is case sensitve and will display the last value from the dataset in the U output when duplicate values are found

false-the unique tool processes data from the top down

Input Data Tool can only connect to files

False-Can connect do databases, APIS and fiels

Which of the following are present in the configuration options for Alteryx, Microsoft Excel, and CSVs

record limit

search subdirs

output file name as field

Constrict the # of input fields

Record Limit Field

The ability to reorder and rename columns, as well as change column’s data type, exist ONLY in the select tool

False

Filtering Data- Basic Filter

Column (Column name)

Operator (Contains)

Condition To Test (OAK)

Cells that are left blank in the text input tool are assigned what value

null value

How can data be added to a workflow with the text input tool

Input data from a file or database

Copy and Paste values from another source

Manually enter values in cells

Any value entered in the text input tool is characterized as a string data type

False

IsEmpty() function accounts for both:

Empty Value

Null Value

ENDIF

clause is required for all conditional statements

Math functions can only be used on numeric data types

True

Tranpose Tool

will always output at least two colums + each key field selected in the configuration window

Which of the header values below would have characters converted to underscores when output by the Cross Tab tool?

Special charactersand spaces are replcaed by underscores in the cross tab tools output

Find Replace tool can only match

string data

The dataset that is conected to the F input of the find replace tool is the input in which data values are replaced or appended

True

Data is only created or modified when a workflow with a configured Output data tool is run

True