Exam (elaborations)
A03 PRACTICE QUIZ FOR ALTERYX INTERACTIVE LESSONS QUESTIONS WITH COMPLETE ANSWERS
- Course
- Institution
A03 PRACTICE QUIZ FOR ALTERYX INTERACTIVE LESSONS QUESTIONS WITH COMPLETE ANSWERS
[Show more]
Content preview
A03 PRACTICE QUIZ FOR ALTERYXINTERACTIVE LESSONS QUESTIONS
WITH COMPLETE ANSWERS
3 - Answer-Given the Transpose Tool's configuration below, how many columns will
appear in the output?
The Unique tool is case sensitive - Answer-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.
- Answer-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() - Answer-Which of the following functions replace every occurrence of a
target string or character?
DateTimeAdd([Start Date], -1, "years") - Answer-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 - Answer-Which features are associated with the Find Replace
tool?
Join by Position - Answer-Based on the results below, which method was used to join
the two tables?
, IIF([Animals]="Cats", "Rule","Drool") - Answer-Which of the following expressions would
not produce the values in the column [Status] in the table?
Finance
Reporting
Numeric - Answer-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 - Answer-Which is not a way that a
Browse tool can be added to the Canvas?
One (1) - Answer-Base on the table below, how many output files will be produced
when the Output Data tool is configured as shown? (The field chosen is Borough Name)
Null - Answer-Cells that are left blank in the Text Input tool are assigned what value?
4 - Answer-How many unique rows would be identified if the Unique tool was configured
as below?
String - Answer-Which of the following data types are acceptable for identifying
matching values when using the Find Replace tool?
TrimLeft([Name],"0") - Answer-Which of the following is the correct expression to
remove leading zeros from the column [Name]?
output file type. - Answer-Which of the following statements are true?
The Output Data tool's configuration options change based on the ____________.
specialized - Answer-Which function category would contain the function "Null()"?
Select a tool on the Canvas and hit Alt+Shift+B - Answer-Which is not a way that a
Browse tool can be added to the Canvas?
Select a tool on the Canvas and hit Alt+Shift+B
Right click a tool on the Canvas and select "Add Browse After"
Drag a Browse tool on the Canvas form the Tool Palette.
Select a tool on the Canvas and hit Ctrl+Shift+B
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)
85169 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now