Exam (elaborations)
ALTERYX CORE EXAM QUESTIONS AND ANSWERS
- Course
- Institution
ALTERYX CORE EXAM QUESTIONS AND ANSWERS
[Show more]
Content preview
ALTERYX CORE EXAM QUESTIONS ANDANSWERS
String Data - Answer-·a sequence of characters such as letters numbers, sequences or
spaces, Qualitative data
Variable string Data - Answer-different length
Fixed String Data - Answer-Same length
Numeric Data - Answer-quantitative, can be measured
Byte - Answer-0-255
Int16 - Answer--(2^15) to (2^15)-1
Int32 - Answer--(2^31) to (2^31)-1
Int 64 - Answer--(2^63) to (2^63)-1
Fixed Numeric - Answer-1234.p
Float - Answer-+/-(3.4E+/-38)
Double - Answer-+/-(1.7E+/-308)
Metadata includes - Answer-names, type, size, and source
What database file is the most effective to use in Alteryx - Answer-Alteryx database file
(YXDB)
Input Data (tool) - Answer-Bring data into your workflow by selecting a file or connecting
to a database
Text input (tool) - Answer-Manually add data values that will be stored in the workflow.
The text input tool - allows you to enter data on the fly to test or use lookup data, leaves
room for error. Can read in data from another source and copy paste
Select (tool) - Answer-Select, deselect, reorder, and rename fields, change filed type or
size, and assign a description. Displays columns, use tool to change things about.
browse (tool) - Answer-View data from a connected tool and view data profile
information, reporting snippets, maps and behavioral analysis information in the data.
, filter (tool) - Answer-Query records based on an expression to split data into two
streams: True (records that satisfy the expression) and false (those that do not)
Sort (tool) - Answer-Sort records based on the values in one or more fields. You can
select multiple columns for sorting in a single tool. String data types are sorted
alphabetically.
sample (tool) - Answer-Limit the data stream to a number, percentage, or random set of
records. Provides options for isolating a subset of data. Sampling data is an easy way to
remove empty rows from the top or bottom of a data set. Also helpful for pairing down
data based on a pattern. Six different methods for sampling data. First N rows, last N
rows, Skip 1st N rows, 1 of every N row, 1 in N chance to include each row, first N% of
rows. One output anchor, meaning rows removed from sampling anchor are not output.
If you want to retain all records use filter tool instead. For a random sample, use 1 in N
chance to include each row
True or False? "1 in N chance to include each row" means that the resulting number of
records will be equivalent to 1/N of the records in the original dataset - Answer-·false,
there is no exact fraction
What are the six different methods for sampling in the sampling tool? - Answer-First N
rows, last N rows, Skip 1st N rows, 1 of every N row, 1 in N chance to include each row,
first N% of rows.
Text to Columns - Answer-Split the text from one field into separate rows or columns.
Sometimes information that should be separate is combined into a single cell, making it
difficult to filter, sort, or sample. In those instances, it makes sense to split that
information into columns or rows. If the values are separated by a delimiter, the text to
columns tool is a quick way to split data into columns or rows.
What is a delimiter? - Answer-A character that separates the data field values.
Examples: Commas, spaces, tabs, pipes, underscore and many other characters.
Multiple delimiters can be specified into the Configuration box at once.
Unique (tool) - Answer-separate data into two streams, duplicate and unique records,
based on the fields of the user's choosing. Selecting a single column in the tool's
configuration window will evaluate values in that column only. Selecting multiple
columns will evaluate the combination of values and determine if the combination is
unique. Duplicate values can lead to inaccurate analysis. Two output anchors U and D.
U outputs unique values and D outputs duplicates. Classified as unique if value ahs not
been encountered before. Split to columns is set to default.
The Unique tool is case sensitive, true or false? - Answer-True
The unique tool processes data bottom up, true or False? - Answer-False, the data is
processed top to bottom
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 biggdreamer. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $12.49. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
75323 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now