Alteryx Quizzes
Cells that are left blank in the Text Input tool are assigned what value? A) Null B) N/A C) Empty D) Zero (0)
A) Null
Which of the following data types are acceptable for identifying matching values when using the Find Replace tool? A) String B) DateTime C) All listed data types D) Numeric
A) String
How can data be added to a workflow with the Text Input tool? A) Copy and paste values from another source B) All listed ways C) Import data from a file or database D) Manually enter values in cells
B) All listed ways
Which of the following is not an available option for combining data in the Union tool? A) Manual Configuration B) DateTime C) Column Name D) Column Position
B) DateTime
Which function category would contain the function "Addition"? A) Conversion B) Operators C) Test D) Math
B) Operators
Which function category would contain the function "Null()"? A) Math B) Specialized C) Operators D) Test
B) Specialized
Which of the following statements is true? A) The Output Data tool can only write to files B) The Output Data tools configuration options change based on the output file type C) the Output Data tool can only output one file at a time D) The Output Data tool includes an output anchor
B) The Output Data tools configuration options change based on the output file type
Which of the following statements about the Unique tool is True? A) It's best practice to join the results from the U & D outputs B) The Unique tool is case sensitive C) The Unique can change the case of the characters in a field. D) You can select up to 10 columns in one Unique tool
B) The Unique tool is case sensitive
Which of the following statements about tool containers are true? A tool container can be: 1. disabled from the canvas. 2. added without inserting the tool from the menu. A) neither 1 nor 2 are true B) both 1 and 2 are true C) 2 but not 1 is true D) 1 but not 2 is true
B) both 1 and 2 are true
Which of the following file types support reading in multiple sheets? A) .yxdb B) All listed options C) .csv D) .xlsx
D) .xlsx
The append fields tool: 1. is limited to generating no more than 16 appends per record 2. requires two input anchors. Which of the above statements are true? A) both 1 and 2 are true B) 1 but not 2 is true C) neither 1 nor 2 are true D) 2 but not 1 is true
D) 2 but not 1 is true
Which of the following options is not a data type recognized in Designer? A) Numeric B) String C) DateTime D) Auto
D) Auto
To limit the number of input rows to 10 from a CSV file, where will you put the number 10 in the Configuration window? A) Delimiters B) Field Length C) Start Data Important on Line D) Record Limit
D) Record Limit
Which of the values are not included in a data stream's metadata in Designer? A) Size B) Source C) Type D) Rename
D) Rename
Which of the header values below would have characters converted to underscores when output by the Cross Tab tool? A) A1 B) Ayx C) All listed D) b&b
D) b&b
Longer statements that document a workflow are best put in a ________ while shorter comments are better in a(n) ___________. A) annotation, comment tool B) tool container, comment tool C) comment tool, API tool D) comment tool, annotation
D) comment tool, annotation
Which statement below is true about the summarize tool? A) only one summarize function can be applied to a field B) the summarize tool is case insensitive C) the "count" function can only be used with numeric data types. D) some summarize function depend on the data type
D) some summarize function depend on the data type
Which is not a way that a Browse tool can be added to the Canvas? A) Select a tool on the Canvas and hit Ctrl+Shift+B B) Right click a tool on the Canvas and select "Add Browse After" C) Select a tool on the Canvas and hit Alt+Shift+B D) Drag a Browse tool on the Canvas from the Tool Palette
C) Select a tool on the Canvas and hit Alt+Shift+B
The DateTime Tool is able to convert A) datetime to string B) numeric to datetime C) both datetime to string and string to datetime D) string to datetime
C) both datetime to string and string to datetime
