Alteryx Core Exam Prep with correct answers 100% 2024
1 view 0 purchase
Course
Alteryx
Institution
Alteryx
Alteryx Core Exam Prep with correct answers 100% 2024
What are the two sections of the Input Data Configuration window? - Correct Answer Connect a File or Database AND Options
What does entering "*" do with an input file? - Correct Answer It brings in anything that starts with the characters ...
Alteryx Core Exam Prep with correct
answers 100% 2024
What are the two sections of the Input Data Configuration window? - Correct Answer Connect a File or
Database AND Options
What does entering "*" do with an input file? - Correct Answer It brings in anything that starts with the
characters before the "*" and anything after it
What does entering "?" do with an input file? - Correct Answer It brings in anything that starts with the
characters before the "?" plus one character
What are the limits for the data layout preview window in the Input Data tool? - Correct Answer 100
records or fewer in wide files
How do you convert an Output Data Tool to an Input Data Tool? - Correct Answer 1.) Right-click the
Output Data tool you want to convert to an Input Data tool.
2.) Select Convert To Input Data.
What are the 3 ways to add the Browse tool to the workflow? - Correct Answer -Drag a Browse tool to
the canvas, and connect it to an upstream tool.
-Right-click on a tool on the canvas and select Add Browse After.
-Use the Shift+Ctrl+B keyboard shortcut and select the tools in a workflow.
Without the browse tool, up to how much data shows in the Results window? - Correct Answer 1 MB of
data
How do you disable a browse tool? - Correct Answer -Select a random point on the canvas to display
the Workflow - Configuration window.
-In the configuration window, select Runtime.
-Check Disable All Browse Tools to make the Browse tools in the workflow unavailable. To enable
Browse tools, uncheck Disable All Browse Tools.
,What happens in the Configuration Window of the Browse Tool if a column's data type is not compatible
with data profiling? - Correct Answer "No Profiling Available" message will display
What happens in the Configuration Window of the Browse Tool if there is only one value in each
column? - Correct Answer "Only one value" message displays
What happens in the Configuration Window of the Browse Tool if each value in the columns is unique? -
Correct Answer "All values are unique" message displays
In the Configuration Window of the Browse Tool, what are the two categories you can filter based on? -
Correct Answer Fields (columns) and Data Type
What is the data profiling limit of the Browse Tool? - Correct Answer 300 MB
Is record size the same as file size? - Correct Answer No
How to convert Browse Tool to Macro Output Tool - Correct Answer 1.) Right-click the Browse tool in
your workflow.
2.) Select Convert To Macro Output.
3.) Configure the tool.
How to convert Browse Tool to Output Data Tool - Correct Answer 1.) Right-click the Browse tool in
your workflow.
2.) Select Convert To Output Data.
3.) Configure the tool.
What does the "Append Suffix to File/Table Name" option do to the output data file? - Correct Answer
Appends the selected field name to the end of the name of the selected table.
What does the "Prepend Prefix to File/Table Name" option do to the output data file? - Correct Answer
Prepends the selected field name to the beginning of the name of the selected table.
,What does the "Change File/Table Name" option do to the output data file? - Correct Answer Changes
the file name to the selected field name
What does the "Change Entire File Path" option do to the output data file? - Correct Answer Changes
the file name to the name of the selected field. The name must be a complete file path. This option can
overwrite an existing file if a file exists in the full path directory
What does Default Sort do to numeric string data? - Correct Answer Using the default sort, numeric
strings are sorted left to right, character by character
What does Dictionary Sort do to numeric string data? - Correct Answer Using the dictionary sort,
numeric strings are sorted from the smallest to largest number
What does the Auto Field Tool do? - Correct Answer Use Auto Field to read through all of the records of
an input and set the field type to the smallest possible size relative to the data contained within the
column.
The tool correctly assigns a numeric field to a string data type where any record starts with zero and not
a number.
What should you do after running the Duplicates tool? - Correct Answer Manual inspection. Manual
inspection of the results is often necessary to ensure that rows flagged as duplicates are actually
duplicates. For example, you might have 2 customers that share the same name but live at different
addresses. If you think that your dataset might include these types of outliers, you might want to select
additional columns when you configure this tool.
What is Sample tool used for? - Correct Answer Use Sample to limit the data stream to a specified
number, percentage, or random set of rows. In addition, the Sample tool applies the selected
configuration to the columns selected to group by
What is the option in the Sample tool to further sample the data? - Correct Answer Group by column: If
a group or groups are specified, N rows are returned for each group.
, If you select to Group by a column named City, specify N as 2, and select First N Rows, Alteryx returns
the first 2 rows for each City.
What other tools contain the Select tool functionality? - Correct Answer Append Fields tool, Find
Nearest tool, Join tool, Join Multiple tool, Select In-DB tool, and Spatial Match tool
What is the Select tool used for? - Correct Answer Use Select to include, exclude, and reorder the
columns of data that pass through your workflow. Excluding columns can limit the data passing through
a workflow and improve performance. You can also use the Select tool to modify the type and size of
data, rename a column, or add a description.
How do you change the supported length or measurement of data in the Select tool? - Correct Answer
Select size and enter a number. Size varies by data types and can be edited for fixed decimal numeric
types and all string types
What are the ways you can use the Formula tool? - Correct Answer Apply conditional statements.
Convert numbers and strings.
Format dates.
Extract file paths.
Apply financial algorithms or mathematical calculations.
Find the minimum and maximum values.
Analyze spatial data.
Cleanse string data.
Perform validation tests on data.
What are the three functions of the Formula tool? - Correct Answer Build an Expression, Add an
Additional Expression, Reorder an Expression
What is the Multi-Row Formula tool used for? - Correct Answer Utilize row data as part of the formula
creation and is useful for parsing complex data, and creating running totals, averages, percentages, and
other mathematical calculations
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller PROFFESORMAURINE. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $7.99. You're not tied to anything after your purchase.
