Tibco Spotfire Certified Professional Exam Practice Test

Answer : A, B, E

A data function is a reusable calculation that can be applied to data in a Spotfire analysis. A data function can have input and output parameters that define how the data function interacts with the data and the analysis. The input parameters specify what data or values are required for the data function to run, and the output parameters specify what data or values are returned by the data function.The types of input or output parameters for a data function are1:

Column: A column parameter represents a single column of data from a data table. A column parameter can be used as input to provide a vector of values to the data function, or as output to create a new column in the data table or overwrite an existing column. A column parameter can have a data type such as real, integer, string, or boolean.

Document property: A document property parameter represents a value that is stored in the analysis document and can be used to control various aspects of the analysis, such as filters, markings, colors, etc. A document property parameter can be used as input to provide a scalar value to the data function, or as output to create a new document property or overwrite an existing document property. A document property parameter can have a data type such as real, integer, string, boolean, date, or time.

Value: A value parameter represents a scalar value that is entered by the user or calculated by the data function. A value parameter can be used as input to provide a constant or variable value to the data function, or as output to return a single value from the data function. A value parameter can have a data type such as real, integer, string, boolean, date, or time.

The other options, column property, table, and visualization, are not valid types of input or output parameters for a data function.Reference:

Details on Data Functions -- Parameters

Configuring Data Function Parameters

How to select/deselect inputs/outputs/parameters in Statistica Data Function for Spotfire

How to pass input from Spotfire to Statistica Data Function?

Answer : B

AutoBinNumeric() is a custom expression function that is used when you auto-bin a numeric column. This function creates a binned column where the value range is divided into intervals based on the number of unique values and the distribution of the data. The function takes one argument, which is the column to bin, and returns a string column with the bin labels. The function is equivalent to right-clicking on a column selector and selecting Auto-bin Column, which creates a temporary, automatic binning on an axis. The function can be used in custom expressions to create permanent binned columns or to apply binning to other visualizations.Reference:AutoBinNumeric,How to Use Binning

Answer : B

Unpivoting is a transformation method that changes the data table from a short/wide format to a tall/skinny format. This means that multiple columns are combined into one or a few columns, and the number of rows increases accordingly. Unpivoting can be useful when you want to analyze the distribution of data across different categories or values, or when you want to apply other transformations or calculations on the data. Unpivoting can be done either when loading data or after the data has been loaded into Spotfire. To unpivot data, you need to select which columns to keep as they are (category columns) and which columns to merge into one or more value columns (value columns). You can also specify the names of the new columns and the data types of the value columns.Reference:Unpivoting Data,Transforming Data,Spotfire Tips & Tricks: Normalize/Standardize your data with Spotfire

Answer : A

A pivot transformation is one way to transform data from a tall/skinny format to a short/wide format. The data is distributed into columns, usually aggregating the values. This means that multiple values from the original data end up in the same place in the new data table.A pivot transformation requires selecting row identifiers, column titles, values and aggregation methods, and optionally transfer columns and aggregation methods12.The function of the pivot transformation is to pivot row values into columns of data, based on the chosen parameters34.Reference:

Pivoting Data - TIBCO Software

Details on Pivot Data - TIBCO Software

Transforming Data - TIBCO Software

Transforming Data - TIBCO Software

Answer : A

CountSmall() is not a valid statistical function in TIBCO Spotfire. It is not listed among thestatistical functionsthat can be used in expressions or data functions. The other options are valid statistical functions that can perform calculations such as counting non-empty values, computing the lower adjacent value, or calculating the standard deviation.Reference:Statistical Functions - TIBCO Software

Answer : B

A unique join is a type of join that eliminates duplicate rows from the result set. It is not available in the Information Designer, as it is not a standard SQL join operator.The join operators that are available in the Information Designer are: inner join, left outer join, right outer join, full outer join, left single match join, right single match join, and freehand join12.These join operators can be used to define how rows in different tables relate to one another, and can be reused in multiple information links3.Reference:Creating a Join in Information Designer,Freehand Joins in Information Designer,Overview of Joins in Information Designer

Answer : A, C

According to the official documentation, there are four levels of permissions that can be set for a folder in the library: Access, Browse + Access, Browse + Access + Modify, and Full Control12. Therefore, the options A (Access) and C (Modify) are not valid permission levels by themselves.Access only allows the user to execute information links in the folder, but not browse or open the contents1.Modify is not a standalone permission level, but a part of Browse + Access + Modify, which allows the user to modify and save items in the folder1.Reference:1: Setting Folder Permissions - TIBCO Software1,2: Permissions - TIBCO Software2