Alteryx Advanced Certification Exam Questions And Answers | Verified 100% Correct

Alteryx Advanced Certification Exam Questions And Answers | Verified 100% Correct What is the intersect/inverse intersect bt. a line and a polygon? - ANSWERs - theinverse intersect bt. two different spatial object will be the simpler object of the two, a line in this case - True or false spatial process tool can combine spatial object of different type? - ANSWERs False. The tool can only combine two same spatial object types. Combination of two different spatial types will result in a null value. What configuration in the spatial process tool acts as a filter tool that filter out null result? - ANSWERs "Don't Output Empty Objects" - True of false The output spatial object from the intersection of a polygon and a line is a polygon - ANSWERs False If we combine a circle with a line in the spatial process tool, what will the output be? - ANSWERs Null An universe spatial object is the closest spatial object to our target spatial object, but the spatial objects are not output from the "M" anchor of the find nearest tool. Which configuration modification will create a match? - ANSWERs Increase the maximum distance What are the columns created by the find nearest tool? - ANSWERs - distance bt. a target and universe spatial object - cardinal direction - rank of the matched universe spatial objects Which data investigation tool provides remarks and suggestion on data quality? - ANSWERs Field Summary Tool Which correlation tool is effective at measuring any arbitrary monotonic relationship between 2 variables? - ANSWERs Spearman Correlation Tool Which correlation tool only measures how well the data fits a linear model? - ANSWERs Pearson Correlation Tool Which correlation tool can measure correlation between more than 2 variables? - ANSWERs Pearson Correlation Tool Which correlation tool offers a group by option to measure correlations between 2 values within specific groups? - ANSWERs Spearman Correlation Tool What are the basic types of spatial relationship in the spatial match tool? - ANSWERs - touch: target object touches the outside boundary of the universe object, but doesn't share any interior space - within: target object is within an universe object, if it is completely encompasses by the universe object - contains: target object contains an universe object, if it fully encompasses the universe object - intersect: if the target object and the universe object overlap each other or share any area in common Which file extension is associated with an analytic application created in Designer? - ANSWERs .yxwz What are the tools that have additional Q anchor for the interfaces? - ANSWERs Tools that contain an expression editor can be updated with questions True or false Anchor connections bt. workflow tools and interface tools do not necessarily be matched - ANSWERs False. Q anchor must be connected to Q anchor while action anchor (the lightning) must be connected to another action anchor What is necessary configuration in the fields from an external source to display as list values in the list box's interface? - ANSWERs The two columns must be named as "Name" and "Value" In which view can you NOT apply changes to the app interface to affect the user experience? - ANSWERs Test view Which view in the interface designer allows a user to enter app values and open the workflow in debug updated with those values? - ANSWERs Test view - True or false Error message tools can be updated with action tools - ANSWERs false Specific cell values can be updated with a text box tool when it is connected to which tool? - ANSWERs text input What are the attributes of the text box tool? - ANSWERs - display default text - multi-line text entry - text masking (for password) - no incoming question anchor - True or false If a radio button is selected, tool container connected to the radio button will be disabled - ANSWERs true - True or false An action tool is required to connect a Q anchor to a lightning bolt anchor - ANSWERs true - True or false Input records must match with a batch group to be included in output - ANSWERs True Which tool is exclusively associated with batch macros? - ANSWERs control parameter tool - True or false When a batch macro is NOT configured for grouping, its behavior will be similar to a traditional join - ANSWERs false In which tools' configuration can you replace a specific string in an expression? - ANSWERs action tool -True or false Designer starts counting iterations at "0" - ANSWERs True How to make the created macro searchable? - ANSWERs Workflow - Meta Info - Tool Palette, under Search Tags, type your search key Which action can be taken for records that do not match a regular expression? - ANSWERs Error if not matched - True or false The tokenize method allows for simple parsing with a single marked group in the regular expression - ANSWERs true What changes can be applied to output columns from the RegEx tool when the Parse output method is selected? - ANSWERs - Change Output Column Data Type - Change Output Column Name - Change Output Column Size - True or false Case sensitivity can be enforced with an optional fourth parameter in RegexEx_Replace function - ANSWERs True Which tool allows us to measure covariance bt. 2 or more variables? - ANSWERs Pearson Correlation Tool In which data investigation tool can we find the p-values for correlations? - ANSWERs