A03 Practice Quiz for Alteryx Interactive
Lessons (53 Questions) with Verified Answers
3
Given the Transpose Tool's configuration below, how many columns will appear in
the output?
The Unique tool is case-sensitive
Which of the following statements about the Unique tool is True?
It's best practice to join the results from the U & D outputs
You can select up to 10 columns in one Unique tool
The Unique can change the case of the characters in a field.
The Unique tool is case-sensitive
The functions Null() and IsNull() are found in the same category in the Function
Library.
Which of the following statements is False?
Conditional statements can be used with any data type.
Math functions can only be used on numeric data types.
The functions Null() and IsNull() are found in the same category in the Function
Library.
A column's datatype can change in the course of a workflow.
Replace()
Which of the following functions replace every occurrence of a target string or
character?
DateTimeAdd([Start Date], -1, "years")
, Which expression would output the value in the column [Output] in the table
below?
Start Date Output
2017-01-01 2016-01-01
Partial field matching
Which features are associated with the Find Replace tool?
Join by Position
Based on the results below, which method was used to join the two tables?
IIF([Animals]="Cats", "Rule","Drool")
Which of the following expressions would not produce the values in the column
[Status] in the table?
Finance
Reporting
Numeric
Which of the following function categories have Action Properties?
All of the listed
Finance
Reporting
Numeric
Select a tool on the Canvas and hit Alt+Shift+B
Which is not a way that a Browse tool can be added to the Canvas?
One (1)
Based on the table below, how many output files will be produced when the Output
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 Mirror. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $13.49. You're not tied to anything after your purchase.