ACTG 339 Final MC

What is the proper spelling?

a) Alteryx

b) Atlyrx

c) Alteyrx

d) Altaryax

a) Alteryx

The ____ tool appends multiple data streams into one unified steam.

a) Join Multiple

b) Union

c) Join

d) Append Field

b) Union

What is the default date format in Alteryx?

a) mm-dd-yyyy

b) yy-mm-dd

c) yyyy-mm-dd

d) mm-dd-yy

c) yyyy-mm-dd

Which of the following can the summarize tool not do.

a) Filtering

b) Summing

c) Grouping

d) Counting

a) Filtering

A Tool Container can be added to the Canvas without dragging/inserting the tool.

a) False

b) True

b) True

Which of the following IS NOT a valid mathematical operator in the Formula tool?

a) /

b) *

c) +

d) ^

d) ^

Once an expression has been built in the Formula tool, it cannot be saved for later use.

a) True

b) False

b) False

It is possible to perform an Outer Join using only the Join tool.

a) False

b) True

b) True

In the Input Data tool, what symbol means "no delimiter"?

a) \n

b) N/A

c) \0

d) Ind

c) \0

Which tool accepts multiple inputs and creates a stacked output table?

a) Join Multiple

b) Union

c) Join

d) Append Fields

b) Union

"Arrange values in one or more fields"

a) Join

b) Filter

c) Sort

d) Output

c) Sort

"Split text from a field into columns by delimiter"

a) Delimitication

b) Output

c) Axe

d) Text-to-Columns

d) Text-to-Columns

"Bring data into your workflow"

a) Input

b) Select

c) Join

d) Load

a) Input

"Write the results of a workflow"

a) Input

b) Write

c) Output

d) Save

c) Output

"Combine data from two sources"

a) Merge

b) Input

c) Join

d) Select

c) Join

"Query data into two streams"

a) Filter

b) Join

c) Sort

d) Arrange

a) Filter

"Drop, rename, or change field order"

a) Input

b) Sort

c) Filter

d) Select

d) Select

True or False: The Join tool restricts field types

a) True

b) False

a) True

Which tool to take two inputs and produce output

a) Join

b) Append Fields

c) Union

d) Find Replace

b) Append Fields

True or False: Select tool allows renaming, reordering, changing types

a) False

b) True

b) True

Which tool lets you extract a portion of rows in a data stream?

a) Filter

b) Select

c) Multi-Field Formula

d) Sample

d) Sample

Which tool would be used to generate the output from the given input?

a) Formula

b) Append Fields

c) Unique

d) Text to Columns

d) Text to Columns

This tool was used to combine 2 or more inputs based on a commonality between the input tables.

a) Join

b) Append Tool

c) Union

d) Join Multiple

a) Join

Which tool provides four (4) kinds of output methods: replace, tokenize, parse, match?

a) XML Parse

b) Text To Columns

c) RegEx

d) DateTime

c) RegEx

Which tool transforms date/time data to and from various formats?

a) RegEx

b) XML Parse

c) DateTime

d) Text To Columns

c) DateTime

True or False: Both Text To Columns and RegEx tools have the same function to split data to rows.

a) True

b) False

a) True

Data Output tool allows writing separate files for each value in a selected field.

a) True

b) False

a) True

What tool is used to write workflow results to file or database?

a) Text Input Tool

b) Date Time Now Tool

c) Output Data Tool

d) Browse Tool

c) Output Data Tool

In the Browse tool, you are allowed to change the data within the tool.

a) False

b) True

a) False

What tool lets you manually type small data files for input (e.g., lookup tables)?

a) Text Input Tool

b) Date Time Now Tool

c) Directory Tool

d) Browse Tool

a) Text Input Tool

Which statement is NOT true about Alteryx?

a) Able to connect to various data sources

b) Able to read PDF files as input

c) Able to extract outputs in different file types

d) Able to read PDF files as input

b) Able to read PDF files as input

d) Able to read PDF files as input

Which is not a component of Alteryx Workflow?

a) Connections

b) Tool palette

c) Tools

d) Anchors

b) Tool palette

Part of Alteryx Designer User Interface that gives us the links to output files that is created.

a) Tool palette

b) Working canvass

c) Configuration window

d) Results window

d) Results window

It is a component of Alteryx Workflow that represents each step in the process

a) connections

b) tools

c) elements

d) anchors

b) tools

A feature where tools are grouped and categorized according to its functionality

a) Tool Palette

b) Configuration window

c) Working canvas

d) Results window

a) Tool Palette

It includes inputs and outputs of each data on each tool

a) Anchors

b) Connections

c) Tools

d) Elements

a) Anchors

This is where we put our tools or processes.

a) Results window

b) Tool Palette

c) Configuration window

d) Working canvas

d) Working canvas

Alteryx can extract outputs in different file types.

a) False

b) True

b) True

Alteryx is a data analytics platform offering extensive data prep & blending capabilities without any ______.

a) data

b) elements

c) coding

d) analytics

c) coding

Which statement is NOT true about Alteryx?

a) Can be used by people with no coding experience

b) Able to connect to various data sources

c) Able to extract outputs in different file types

d) Able to read PDF files as an input

d) Able to read PDF files as an input

Which is not a component of Alteryx Workflow?

a) Connections

b) Anchors

c) Tools

d) Tool palette

d) Tool palette

Alteryx offers data prep & blending without any ___________.

a) elements

b) coding

c) data

d) analytics

b) coding

Which statement is true about Alteryx?

a) It is a business intelligence platform for data analysts that offers data mining and predictive analytics.

b) It specializes in self-service analytics with an intuitive user interface.

c) It allows users to blend data from disparate sources, including Microsoft Excel, Hadoop, and Salesforce, with drag-and-drop features.

d) All of the above

d) All of the above

59. Alteryx can be used in which department?

a) Tax

b) All of the above

c) Audit

d) Finance

b) All of the above

Alteryx is designed for who?

a) Coders and Developers

b) Non-Technical Business Decision Makers

c) Accountants but Not Financial Analysts

d) Bill's Mom

b) Non-Technical Business Decision Makers

Alteryx can bring together data from multiple accounting ledgers and consolidate them for reporting and sub-ledger account analysis.
a) True
b) False

a) True

In most organizations data resides in a single enterprise source (such as a financial data warehouse).
a) False
b) True

a) False

Today analysts are often required to prepare, blend, and analyze data from many sources, without writing any code and without dependencies on the IT organization.
a) False
b) True

b) True

Which of the following is NOT a benefit of Business Analytics?
a) Employee Churn
b) Better Decision Making
c) Personalized Recommendations
d) Revenue Increment

a) Employee Churn

_ is a unified data repository that allows you to store structured, semi-structured, and unstructured enterprise data at any scale.
a) Data Mart
b) Data Warehouse
c) Data Cube
d) Data Lake

d) Data Lake

Which of the following is NOT a Visualization Software?
a) Qlik sense
b) Alteryx
c) Spotfire
d) Power BI

b) Alteryx

Which of the following is a Big Data Platform?
a) Hive
b) Spotfire
c) Powerpoint
d) Microsoft Excel

a) Hive

Which tool would be used to create the following output?
a) Text to Columns
b) Join
c) All of the above
d) Filter

a) Text to Columns

One of these functions is not included in the RegEx tool, which one is it?
a) Parse
b) Count
c) Match
d) Tokenize

b) Count

This tool allows you to remove white-space, letters, numbers, and other unwanted characters
a) Formula
b) All of the above
c) Data Cleansing
d) RegEx

c) Data Cleansing

You can filter, sort and cleanse data in the Browse tool
a) True
b) False

b) False

What tool includes, excludes, and reorders the columns of data that pass through a workflow?
a) Sort Tool
b) Browse Tool
c) Select Tool
d) Join Tool

c) Select Tool

What tool pivots the orientation of the data table and transforms the data so vertical data fields can be viewed on a horizontal axis, summarizing data where specified?
a) Transpose Tool
b) Count Records Tool
c) Cross Tab Tool
d) Summarize Tool

c) Cross Tab Tool

What is the default date format in Alteryx?
a) mm-dd-yy
b) yyyy-mm-dd
c) mm-dd-yyyy
d) dd-mm-yy

b) yyyy-mm-dd

What tool updates specific values in a numeric data field with another selected value?
Hint: It is useful for replacing NULL values.
a) Tile Tool
b) Multi-Field Binning Tool
c) Filter Tool
d) Imputation Tool

d) Imputation Tool

What tool searches for data in one field from the input table and replaces it with a specified field from a different data table?
a) Find Replace Tool
b) Join Multiple Tool
c) Fuzzy Match Tool
d) Append Fields Tool

a) Find Replace Tool

What tool can conduct a host of summary processes, including grouping, summing, and counting?
a) Transpose Tool
b) Running Total Tool
c) Cross Tab Tool
d) Summarize Tool

d) Summarize Tool

What is one way you can configure the Join Tool?
a) Join by Shape
b) Join by Specific Field
c) Join by Text
d) Join by Color

b) Join by Specific Field

Which tool would be used for the following output:

a) Transpose
b) Cross Tab
c) Arrange
d) Summarize

a) Transpose

What is the correct delimiter for "Tab" in the Text to Columns tool?
a) \s
b) \s\t
c) \t
d) \n

c) \t

Which tool would be used for the following output:

a) Summarize
b) Transpose
c) Cross Tab
d) Running Tool

a) Summarize

a) Summarize
b) Cross Tab
c) Transpose
d) Running Total

b) Cross Tab

The Find Replace tool can be configured to be case insensitive, whereas the Join tool is always case sensitive.
a) True
b) False

a) True

Which tool would be used to create the following output?

a) Append Fields
b) Join
c) Union
d) Summarize

c) Union

When configuring the Cross Tab tool, you must group data by at least one value.
a) True
b) False

b) False

Which tool would be used to create the following output?

a) Formula
b) Join
c) Append Fields
d) Union

d) Union

What type of join will the following workflow perform?

a) Middle Join
b) Join
c) Right Outer Join
d) Left Outer Join

d) Left Outer Join

You have a field in your data with the following types of values: -2, 0, 10

There are no decimal values and the minimum value is -255 and the maximum value is +255.

What data type is the best fit for this field?

a) Int32
b) Int16
c) Double
d) Int24

b) Int16

Which configuration of the Sort tool would produce the following results

a) Date: Descending | Rep: Ascending
b) Date: Ascending | Rep: Ascending
c) Date: Ascending | Rep: Descending
d) Date: Descending | Rep: Descending

d) Date: Descending | Rep: Descending

The Basic Filter in the Filter tool allows for querying against multiple columns.
a) False
b) True

b) True

Which of the following statements is FALSE about tool annotations?
a) Annotations can be customized with your own text
b) Annotations allow you to change the ID number of a tool.
c) Annotations can be disabled so they don't show up on the canvas.
d) Annotations can appear above or below the tool on the canvas.

b) Annotations allow you to change the ID number of a tool.

What is the correct file type for the Alteryx file extension ".yxdb"?
a) Alteryx Macro
b) Alteryx Database
c) Alteryx App
d) Alteryx Micro

b) Alteryx Database

True or False: In the results window there is a way to look at the metadata.
a) True
b) False

a) True

Consider the following input data with a Filter tool:

How many rows would the T output contain with the following custom filter: [Day]="Monday" AND ([Year]=2010 OR [Year]=2016)
a) 2
b) 3
c) 1
d) 5

c) 1

Which is NOT a way to configure the Sample Tool?
a) Middle N Rows
b) Last N Rows
c) 1 of every N Rows
d) First N Rows

a) Middle N Rows

True or False: the definition for the Sample Tool is as follows - this tool includes, excludes, and reorders the columns of data that pass through a workflow.
a) True
b) False

b) False

True or False: The Data Cleansing Tool can run dynamically.

a) True
b) False

b) False

Which tool accepts multiple inputs based on either column name or record position and then creates a stacked output table?
a) Union Tool
b) Join Tool
c) Append Fields Tool
d) Join Multiple Tool

a) Union Tool

By default, how much data can each anchor of the workflow store for review in the Results Window?
a) 10000 rows
b) 10 megabytes
c) 1000 rows
d) 1 megabyte

d) 1 megabyte