Tibco - Big Savings Alert – Don’t Miss This Deal - Ends In 1d 00h 00m 00s Coupon code: 26Y30OFF
  1. Home
  2. Tibco
  3. TCP-SP Exam
  4. Free TCP-SP Questions

Free Practice Questions for Tibco TCP-SP Exam

Pass4Future also provide interactive practice exam software for preparing Tibco Spotfire Certified Professional (TCP-SP) Exam effectively. You are welcome to explore sample free Tibco TCP-SP Exam questions below and also try Tibco TCP-SP Exam practice test software.

Page:    1 / 14   
Total 60 questions

Question 1

Which of the following join operators is not available in the Information Designer?



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


Question 2

Which of the following is not a statistical function?



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


Question 3

Identify the function of the Pivot transformation



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


Question 4

Transforming an underlying Data Table from Short/Wide to Tall/Skinny format is known as



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


Question 5

Which custom expression function is used by when you auto-bin a numeric column?



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


Page:    1 / 14   
Total 60 questions