Exam (elaborations)
TOOLS OF ALTERYX DESIGNER EXAM QUESTIONS AND ANSWERS
- Course
- Institution
TOOLS OF ALTERYX DESIGNER EXAM QUESTIONS AND ANSWERS
[Show more]
Content preview
TOOLS OF ALTERYX DESIGNER EXAMQUESTIONS AND ANSWERS
Directory - Answer-Returns all the files in a specified directory. Along with file names,
other pertinent information about each file is returned, including file size, creation date,
last modified, and much more.
Date Time Now - Answer-returns a single record: the Date and Time at the workflow
runtime, and convert the value into the string format of the user's choosing.
Browse - Answer-displays data from a connected tool as well as data profile
information, maps, reporting snippets, and behavior analysis information in the data.
Output Data - Answer-writes the results of a workflow to a file or database.
Map Input - Answer-makes it possible to draw or select map objects (points, lines, and
polygons) to be stored in the workflow.
Input Data - Answer-brings data in to your workflow by connecting to a file or database.
XDF Output - Answer-writes an Alteryx data stream to an XDF (.xdf) file, which is the
format used by Microsoft R ScaleR functions to scale predictive analytics to millions of
records.
XDF Input - Answer-reads data from an XDF (.xdf) file, which is the format used by
Microsoft R ScaleR functions to scale predictive analytics to millions of records for either
using the .xdf file as input to a predictive analytics tool or reading the file into an Alteryx
data stream for further data cleansing or blending.
Text Input - Answer-makes it possible to manually type text to create small data files for
input, which can be useful for creating Lookup tables.
Data Cleansing - Answer-fixes common data quality issues using a variety of
parameters.
Create Samples - Answer-splits the input records into two or three random samples.
Specify the percentage of records that are in the estimation and validation samples, and
if the total is less than 100%, the remaining records fall in the holdout sample.
Auto Field - Answer-reads through an input file and sets the field type to the smallest
possible size relative to the data contained within the column.
Generate Rows - Answer-creates new rows of data at the record level. It is useful to
create a sequence of numbers, transactions, or dates.
, Formula - Answer-creates or updates columns using one or more expressions to
perform a broad variety of calculations or operations.
Filter - Answer-queries records and splits the data into two outputs, True (where the
data meets the specified criteria) and False (where it does not).
Multi-Field Formula - Answer-makes it easy to execute a single function on multiple
fields.
Multi-Field Binning - Answer-groups multiple numeric fields into tiles or bins, especially
for use in predictive analysis.
Imputation - Answer-updates specific values in a numeric data field with another
selected value. It is useful for replacing NULL values.
Random % Sample - Answer-returns an expected number of records resulting in a
random sample of the incoming data stream.
Oversample Field - Answer-samples incoming data so that there is equal representation
of data values so they can be used effectively in a predictive model.
Multi-Row Formula - Answer-creates or updates a column using an expression that can
reference columns in a subsequent or prior row. It is useful for parsing complex data,
and creating running totals, averages, percentages, and other mathematical
calculations.
Select - Answer-includes, excludes, and reorders the columns of data that pass through
a workflow. You can also modify the type and size of data, rename a column, or add a
description.
Sample - Answer-extracts a specified portion of the records in the data stream.
Record ID - Answer-creates a new column in the data and assigns a unique identifier,
that increases sequentially, for each record in the data.
Tile - Answer-Group data into sets based on value ranges in a field.
Sort - Answer-arranges the records in a table in alphanumeric order, based on the
values of the specified data fields.
Select Records - Answer-selects specific records and/or ranges of records including
discontinuous ranges. It is useful for troubleshooting and sampling
Unique - Answer-distinguishes whether a data record is unique or a duplicate by
grouping on one or more specified fields, then sorting on those fields. The first record in
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 $14.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