Alteryx

T or F: A column's data type can change in the course of a workflow?

True

T or F: Data is only created or modified when a workflow with a configured output data tool is run

True

T or F: Any value entered into the Text Input tool is characterized as a string data type

False

T or F: Columns classified as a numeric data type may be joined to columns classified as any data type when joining by specific fields

False

T or F: The dynamic input tool is the only tool required to input multiple sheets at once

False

T or F: The input data tool can only connect to files?

False

Alteryx is?

Data analytics software

To move data through a workflow, which action should be taken? a) Click the "run" button b) Drag a tool onto the canvas c) Press "Enter" on the keyboard

a) Click the "run" button

How can data be added to a workflow with the text input tool? a. input data from a file or database b. manually enter values in cells c. copy and paste values from another source

a, b and c

Select all the ways in which a browse tool can be added to the canvas? a. Right click a tool on the canvas and select "add browse after" b. Select a tool on the canvas and hit Ctrl-Shift-B c. Drag a browse tool on the canvas from the tool palette

a, b and c

Select all the ways in which a tool can be added to the Canvas in Designer: a. Right click on the canvas and insert a tool from the list of tool categories b. Drag a tool from the tool palette onto the canvas c. Drag a tool from the search results onto the canvas d. Double clicking a tool in the palette

a, b, and c

Select all the values that are included in a data stream's metadata in Designer? a. type b. size c. name d. source

a, b, c, and d

What happens when Designer fails to read in a sheet? a. a warning message appears b. nothing happens c. this would never happen in Designer d. an error message appears

a. a warning message appears

Which of the following is not an available option for combining data in the Union tool? a. data type b. manual configuration c. column name d. column position

a. data type

The tool that allows you to annotate in the canvas is?

comment tool

Which of the following are present in the configuration options for Alteryx Databases, Microsoft Excel workbooks, and CSVs? a. first row contains data b. output file name as field c. delimiters d. record limit

b and d

Cells that are left blank in the text input tool are assigned what value? a. empty b. null c. zero

b. null

Which of the following file types support reading in multiple sheets? Select all that apply. a. .xls b. all listed options c. .xlsx d. .csv e. .yxdb

c. .xlsx ONLY

Which of the following options is not a data type recognized in Designer? a. string b. numeric c. auto

c. auto

On the main page in Designer you see?

canvas, tool palette, configuration window, results window

The join tool output anchors are?

left, join, right

Select the statements that are true: a. the output data tool's configuration options change based on the output file type b. the output data tool can only write to files c. the output data tool can only output one file at a time d. the output data tool does not include an output anchor

a and d

Common output file types in Alteryx are?

excel, csv, and alteryx database

If a workflow in Alteryx has resulted in an error you will see a?

exclamation mark

The browse tool is used when?

only a fraction of the data is displayed

The final step in a workflow is to?

output the workflow to a database, cloud platform, or file

To limit the number of rows of output with the input data tool you would select?

record limit