Download ACTG 339 Final Exam Study Guide and more Exams Advanced Education in PDF only on Docsity!
ACTG 339 Final Exam Study Guide
What is the proper spelling? - Answer a) Alteryx The ____ tool appends multiple data streams into one unified steam. The tool accepts multiple inputs based on either field name or record position, creating a stacked output table. - Answer b) Union What is the default date format in Alteryx? - Answer c) yyyy-mm-dd Which of the following can the summarize tool not do. - Answer a) Filtering A Tool Container can be added to the Canvas without dragging/ inserting the tool. - Answer True Which of the following IS NOT a valid mathematical operators that can be used in the Formula tool's expression editor? - Answer ^ Once an expression has been built in the Formula tool, it cannot be saved for use at a later time. - Answer False It is possible to perform an Outer Join using only the Join tool. - Answer False In the Input Data tool, what is the symbol for "no delimiter''? - Answer
Which tool accepts multiple inputs, based on either field name or position, and creates a stacked output table? - Answer Union "Arrange values in one or more fields" - Answer Sort "Split text from a field in to one or more new columns based on a delimiter" - Answer Text-to-Columns "Bring data into your workflow by selecting a file or connecting to a database" - Answer Input "Write the results of a workflow to a file or database" - Answer Output "Combine data from two sources based on common fields or record position" - Answer Join "Query data based on an expression to split it into two streams. True or False." - Answer Filter "Drop, rename, or change the file type or order of fields" - Answer Select True or False: The Join tool restricts what field types can be joined together. - Answer True Which tool will take the two inputs and produced the output mentioned? - Answer Join
True or False: The Select tool allows you to select the fields that flow downstream, rename and re- sequence fields, modify data types, and add field descriptions. - Answer True Which tool lets you extract a specified portion of the rows in a data stream? - Answer Sample Which tool would be used to generate the following output from the given input? Triangle red?orange?yellow Square green?blue Triangle red Triangle orange Triangle yellow Square green Square blue - Answer Text to Columns This tool was used to combine 2 or more inputs based on a commonality between the input tables. - Answer Join Multiple Which tool provides four (4) kinds of output method? (namely replace, tokenize, parse, match) - Answer RegEx Which tool transforms date/time data to and from a variety of formats, including both expression-friendly and human readable formats? - Answer DateTime True or False; Both Text To Columns and RegEx tools have the same function to split data to rows. - Answer True True or False. Data input tool has a limitation to connect in the data sources such as Oracle, SQL and Teradata. - Answer False Data output tool will allow you to write separate files for each value in a selected fields?
- Answer True What tool use to write the results of a workflow to a file or database? - Answer Output Data Tool The data input from the Text Input tool saves within the workflow? - Answer True In Browse tool, you allowed to change the data within the tool. - Answer False What tool makes it possible to manually type text to create small data files for input, which can be useful for creating Lookup tables? - Answer Text Input Tool
Which of the following is NOT a Visualization Software? - Answer Alteryx A data mart is a subject-oriented data repository often a segregated section of a data warehouse. - Answer True Which of the following is a Big Data Platform? - Answer Hive Which tool would be used to create the following output? Elon Musk, Harry Potter 1 Elon Musk 2 Harry Potter - Answer Text to Columns One of these functions is not included in the RegEx tool, which one is it? - Answer Count This tool allows you to remove white-space, letters, numbers, and other unwanted characters - Answer Data Cleansing
You can filter, sort and cleanse data in the Browse tool - Answer False
What tool includes, excludes, and reorders the columns of data that pass through a workflow? - Answer 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? - Answer Cross Tab Tool
What tool writes the results of a workflow to a file or database? - Answer XDF Output Tool
What tool updates specific values in a numeric data field with another selected value? Hint: It is useful for replacing NULL values. - Answer 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? - Answer Find Replace Tool
What tool can conduct a host of summary processes, including grouping, summing, and counting? - Answer Summarize Tool
What is one way you can configure the Join Tool? - Answer Join by Specific Field
Which tool could be used to generate the following output:
ID A B 1 7 9 2 7 7
ID Name Value 1 A 7 1 B 9 2 A 7 2 B 7 - Answer Transpose
What is the correct delimiter for "Tab" in the Text to Columns tool? - Answer \t
Which tool could be used to generate the following output:
ID A B 1 2 3 1 5 6 2 2 2 2 5 5
Which configuration of the Sort tool would produce the following results:
Date Sales Rep 2018-07-21 63896 Joe 2018-07-21 78569 Christine 2018-04-08 82996 Dan - Answer Date: Descending | Rep: Ascending
The Basic Filter in the Filter tool allows for querying against multiple columns. - Answer False
Which of the following statements is FALSE about tool annotations? - Answer Annotations allow you to change the ID number of a tool
What is the correct file type for the Alteryx file extension ".yxdb"? - Answer Alteryx Database
True or False: In the results window there is a way to look at the metadata. - Answer True
How many rows would the T output contain with the following custom filter: [Day]="Monday" AND ([Year]=2010 OR [Year]=2016)
Year Day Amount 2010 Monday 12 2011 Wednesday 54 2012 Friday 36 2013 Tuesday 75 2014 Thursday 92
2015 Saturday 42 2016 Sunday 15 2017 [Null] 32 - Answer 1
Which is NOT a way to configure the Sample Tool? - Answer 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. - Answer False
True or False: The Data Cleansing Tool can run dynamically. - Answer False
Which tool accepts multiple inputs based on either column name or record position and then creates a stacked output table? - Answer Union Tool
By default, how much data can each anchor of the workflow store for review in the Results Window? - Answer 10,000 Rows
