A03 Practice Quiz for Alteryx Interactive Lessons (53 Questions)

impossible to tell

An input dataset contains 54 records. With the give configuration window, how many records will be output?

Right clicking in the Expression Editor and selecting a function.

From the options listed below, which is not a way that functions can be inserted into the Expression Editor?

3

Given the Transpose Tool's configuration below, how many columns will appear in the output?

all the listed ways

How can data be added to a workflow with the Text Input tool? All listed ways Manually enter values in cells Import data from a file or database Copy and paste values from another source

2

How many cells in Column 1 would be evaluated as True by the function IsEmpty?

4

How many unique rows would be identified if the Unique tool was configured as below?

Record Limit

To limit the number of input rows to 10 from a CSV file, where will you put the number 10 in the Configuration window?

Syntax error and Data type

What about the configuration below is incorrect?

Round()

Which Function would produce the results in Result below?

Partial field matching

Which features are associated with the Find Replace tool?

rename

Which of the values are not included in a data stream's metadata in Designer? size rename type source

5

Values in the data below are comma-delimited. How many columns should be specified for splitting the data if delimiters in quotes and brackets are ignored when using the Text To Columns tool?

An error message appears.

What happens when Designer fails to read in a sheet?

ENDIF

What syntax element is missing from the statement below?

Last

Which aggregation method was used for the Cross Tab tool to get the result?

space

Which character is not used to parse the data, as shown below? comma space semi-colon hyphen

[Borough Code]=1 OR [Health] = "Good"

Which expression was used in the Filter tool to create the True output below?

IF IsNull([Status]) THEN "Not available" ELSE [Status] ENDIF

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

DateTimeAdd([Start Date], -1, "years")

Which expression would output the value in the column [Output] in the table below? Start Date Output 2017-01-01 2016-01-01

Operators

Which function category would contain the function "Addition"?

specialized

Which function category would contain the function "Null()"?

Upper Case ()

Which function was used to produce the values in the column [Email]?

Select a tool on the Canvas and hit Alt+Shift+B

Which is not a way that a Browse tool can be added to the Canvas?

Select a tool on the Canvas and hit Alt+Shift+B

Which is not a way that a Browse tool can be added to the Canvas? Select a tool on the Canvas and hit Alt+Shift+B Right click a tool on the Canvas and select "Add Browse After" Drag a Browse tool on the Canvas form the Tool Palette. Select a tool on the Canvas and hit Ctrl+Shift+B

Double Clicking a Tool in the Tool Palette

Which is not a way to add a tool to Canvas in Alteryx Designer?

First Row Contains Data

Which of the following are not present in the configuration options for all the three file types-CSVs, Microsoft Excel Workbooks, and Alteryx Databases?

String

Which of the following data types are acceptable for identifying matching values when using the Find Replace tool?

IIF([Animals]="Cats", "Rule","Drool")

Which of the following expressions would not produce the values in the column [Status] in the table?

.xlsx

Which of the following file types support reading in multiple sheets?

Finance Reporting Numeric

Which of the following function categories have Action Properties? All of the listed Finance Reporting Numeric

Replace()

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

Data type

Which of the following is not an available option for combining data in the Union tool?

TrimLeft([Name],"0")

Which of the following is the correct expression to remove leading zeros from the column [Name]?

Auto

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

Sort the content in a field

Which of the following processes can not be performed with a Select tool? Save field configuration sort the content in a field change a data type remove columns

The Unique tool is case sensitive

Which of the following statements about the Unique tool is True? It's best practice to join the results from the U & D outputs You can select up to 10 columns in one Unique tool The Unique can change the case of the characters in a field. The Unique tool is case sensitive

output file type.

Which of the following statements are true? The Output Data tool's configuration options change based on the ____________.

Output Data

Which of the following statements are true? The ________________ tool's configuration options change based on the output file type.

The Input Data tool can only connect to files.

Which of the following statements is False? Browse tool is needed to view the entire dataset in the Results window. The dataset that is connected to the "F" input of the Find Replace tool is the input in which data values are replaced or appended. The filter tool includes two output anchors. The Input Data tool can only connect to files.

The functions Null() and IsNull() are found in the same category in the Function Library.

Which of the following statements is False? Conditional statements can be used with any data type. Math functions can only be used on numeric data types. The functions Null() and IsNull() are found in the same category in the Function Library. A column's datatype can change in the course of a workflow.

Math functions can only be used on numeric data types.

Which of the following statements is True? Any value entered into the Text Input tool is characterized as a string data type. Columns classified as a numeric data type may be joined to columns classified as any data type when joining by specific fields. The ability to reorder and rename columns, as well as change a column's data type, exists only in the Select tool. Math functions can only be used on numeric data types.

Browse

Which of the following statements is True? ______________ is needed to view the entire dataset in the Results window.

Browse tool

Which of the following statements is True? ________________ is needed to view the entire dataset in the Results window.

Only one expression can be written in a single Formula tool

Which of the following statements is false? The Formula tool can create a new field. Only one expression can be written in a single Formula tool Syntax highlighting distinguishes functions, columns, operators, and text The Data Preview provides a view of the output in the first record of the incoming dataset

b&b

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

every row

All of the following sampling methods are available in the Sample tool except:

One (1)

Base on the table below, how many output files will be produced when the Output Data tool is configured as shown? (The field chosen is Borough Name)

two (2)

Base on the table below, how many output files will be produced when the Output Data tool is configured as shown? (The field chosen is Common Name)

Five (5)

Based on the configuration below, how many rows will be output from the Union tool?

split to rows

Based on the data before and after parsing, select the method in the Text To Columns tool that was used.

Join by Position

Based on the results below, which method was used to join the two tables?

Null

Cells that are left blank in the Text Input tool are assigned what value?

"Score" is sorted in ascending order and "Use Dictionary Order" is unchecked.

The data type of Score filed is String. Based on the result, which option in the Sort tool was used?

Click the "Run" Button

To move data through a workflow, which action should be taken?