TCP-SP TIBCO Spotfire Certified Professional Exam Questions and Answers

Action control scripts are written in IronPython, which is an implementation of the Python programming language that runs on the .NET Framework.  IronPython allows you to access the Spotfire API and create custom actions or tools for your analysis 1 .  You can add action control scripts to a text area and link them to buttons, links, or images 2 .  You can also use JavaScript in HTML mode to add interactivity to your text area 3 .  References :

Using Scripts in the Text Area - TIBCO Software

Scripting - TIBCO Spotfire 7.6 - BEGINNER - Skillsoft

Details on Insert JavaScript and JavaScript Example Scripts - TIBCO Software

BinByEvenDistribution() is a binning function that creates a binned column where each bin has the same number of unique values as the others. The last bin may have more unique values than the others. The first argument is the column to bin and the second argument is the number of bins. This function can be used on a numeric type column to group the values into equal frequency bins. The other binning functions are either not valid (BinByTimeSpan(), BinByNumbers()) or not applicable to a numeric type column (BinByDateTime(), BinBySubstring()).  References :  Binning Functions ,  How to Use Binning

According to the documentation, you can define script parameters for IronPython scripts in action controls and JavaScript parameters when you edit HTML of a text area. The type of parameter can be a simple data type such as a text string, an integer, etc., or it can be a visualization, page or data table in the current analysis. Therefore, visualizations and pages are two valid types of parameters that can be passed to a script. Markings and filtering schemes are not listed as possible parameter types.  References :  Details on Add/Edit Script Parameter ,  Using Scripts in the Text Area

The expression shortcut “Cumulative Sum” uses the expression  Sum([Column]) THEN Sum([Value] ) OVER (AllPrevious([Axis.X])) . This expression calculates the sum of the values in a column, and then calculates the cumulative sum of those values over all previous values on the X-axis.  This is equivalent to option C in the image you sent 1 .  References :

Cumulative Sum

 One way to edit a text area is to click on the  Edit Text Area  button, , in the text area title bar.  This will open the Text Area editor, where you can type text, or add any type of dynamic controls by clicking on the corresponding button in the text area toolbar 1 .  You can also right-click on the text area and select  Edit Text Area  from the pop-up menu 2 .  References :  How to Use the Text Area ,  Text Area Pop-up Menus

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 Control 1 2 . 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 contents 1 .  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 folder 1 .  References :  1 : Setting Folder Permissions - TIBCO Software 1 ,  2 : Permissions - TIBCO Software 2

 A text area is a component that can be added to a page in Spotfire to provide text, images, links, buttons, property controls, filters, and dynamic items 1 .  A dynamic item is a small visualization that can display an aggregated view of some data, such as a calculated value, a sparkline, an icon, or a bullet graph 2 .  A dynamic item can be inserted into a text area by using the Insert Dynamic Item option in the text area toolbar 3 . The other options are not valid items that can be inserted into a text area.  A calculated column, a data table, and a custom expression are data-related concepts that can be used in Spotfire to create or manipulate data tables and columns 4 .  A visualization is a graphical representation of data that can be added to a page as a separate component 5 .  References :  How to Use the Text Area ,  Dynamic Items - TIBCO Software ,  How to Insert a Dynamic Item ,  Data in Analysis - TIBCO Software ,  Visualizations - TIBCO Software

The Information Designer is a tool for setting up data sources and creating and opening information links in Spotfire. An information link is a database query specifying the columns to be loaded and any filters needed to narrow down the data table prior to creating visualizations in Spotfire.  The Information Designer can be accessed from the Tools menu in the main toolbar, but it is only available to users who have been granted a TIBCO Spotfire Information Modeler license 1 .  References :

Information Designer in Spotfire®

CountSmall() is not a valid statistical function in TIBCO Spotfire. It is not listed among the  statistical functions  that 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.  References :  Statistical Functions - TIBCO Software

TIBCO Streaming is an enterprise-grade, cloud-ready streaming analytics platform for quickly building real-time applications at a fraction of the cost and risk of alternatives 1 .  TIBCO Streaming enables you to analyze, continuously query, and act on IoT and other streaming data at lightning fast speeds 2 .  TIBCO Streaming is an assembly of TIBCO software technologies in a single licensable collection, which includes TIBCO StreamBase, TIBCO LiveView, TIBCO LiveView Web, TIBCO LiveView Desktop, and TIBCO Artifact Management Server 3 .  TIBCO Streaming provides a full-featured Eclipse-based IDE, a visual programming language, and development tools that support a full development cycle 4 .  References :  TIBCO Streaming ,  TIBCO Streaming Trial - Windows ,  What is TIBCO Streaming? ,  TIBCO Streaming Software - Runtime Overview

A treemap visualization is a way of displaying large amounts of hierarchically structured data. The space in the visualization is split up into rectangles that are sized and ordered by a quantitative variable. The treemap in Spotfire uses a squarified algorithm, which means that the rectangles in the treemap range in size from the top left corner of the visualization to the bottom right corner, with the largest rectangle positioned in the top left corner and the smallest rectangle in the bottom right corner. For hierarchies, that is, when the rectangles are nested, the same ordering of the rectangles is repeated for each rectangle in the treemap.  References :  What is a Treemap? ,  Creating a treemap

 A Spotfire analysis is saved as a file with the extension  .dxp , which stands for Data eXploration Project. This file contains the data, visualizations, pages, filters, markings, and other settings of the analysis. A .dxp file can be opened in Spotfire Analyst or Spotfire Web Player, or uploaded to Spotfire Server for sharing and collaboration.  References :  Extending Spotfire® - TIBCO Software ,  File data sources - TIBCO Software ,  Extensions - TIBCO Software

The variable [CategoryIndex.X] can be used along with the THEN keyword to pick out a node of interest in an expression. This variable represents the index of the node on the X axis, starting from zero. For example, to get the value from node number five on the X axis and put it on all other nodes, you could use an expression like this:

Sum ( [Sales]) THEN Sum (if ( [CategoryIndex.X] =4, [Value],0)) OVER (All ( [Axis.X] ))

The other variables, [Axis.Color], [Axis.X] , and [X.LevelName], are not used to pick out a specific node, but rather to refer to the color, value, or level name of the node, respectively 1 .  References :  Using Expressions on Aggregated Data (the THEN Keyword)

An input field is a property control type that adds a text box where users can type a new value for the linked property. An input field can be used with any property type, such as string, integer, real, or date. An input field allows users to enter custom values that are not predefined in a list or a slider.  An input field can also be used to filter data based on partial string matching 1 2 .  References :

Details on Property Control - TIBCO Software

Adding a property control to a text area - TIBCO Software

Comparison circles are a way to display whether or not the mean values for various categories (boxes in the box plot) are significantly different from each other. The circles are drawn with their centers at the mean value for the box to which they correspond. If the circles for different groups do not overlap, the means of the two groups are generally significantly different. If the circles have a large overlap, the means are not significantly different.  References :  What are Comparison Circles? - TIBCO Software