TCP-SP Practice Questions

In TIBCO Spotfire, action controls are interactive elements placed within a Text Area visualization that allow users to trigger predefined operations. The user interface elements that can be configured to function as action controls are Buttons, Links, and Images. When a user clicks on one of these elements, it can execute an action such as navigating to another page, applying a bookmark, or running an IronPython script.

B. Scripts: A script is an action that is executed by an action control; it is not the control element itself. The control is the UI element (e.g., a button) that the user clicks.

1. TIBCO Spotfire® Analyst User's Guide (Version 12.0 LTS)

Chapter: Visualizations

Section: Text Area.

Page/Section: "Adding an Action Control to the Text Area". This section explicitly states: "You can add action controls to a text area

which allow end users of the analysis to perform actions... by clicking on a button or a link in the text area." This directly supports options A (Links) and D (Buttons).

2. TIBCO Spotfire® Analyst User's Guide (Version 12.0 LTS)

Chapter: Visualizations

Section: Text Area.

Page/Section: "Inserting an Image in the Text Area". The procedure for inserting an image allows adding a link to it. This link can be an action link that triggers a script or other Spotfire actions

effectively making the image a type of action control. This supports option C (Images).

3. TIBCO Spotfire® Analyst User's Guide (Version 12.0 LTS)

Chapter: Visualizations

Section: Text Area.

Page/Section: "Details on Insert Link". When inserting a link (which can be applied to text or an image)

the dialog box provides an "Actions" section. This section allows the configuration of various actions

including "Execute a script"

confirming that a script is the result of an action control

not the control itself. This supports the reasoning for excluding option B.

TIBCO Spotfire's IronPython scripting engine allows various components of an analysis file to be passed as input parameters to a script. This enables dynamic and context-aware script execution. According to the official TIBCO Spotfire documentation, the types of objects that can be passed as script parameters include Markings and Filtering Schemes. These are fundamental for creating scripts that interact with the user's data selection and filtering state, which are core functionalities in Spotfire for interactive analysis.

B. Visualizations: This is technically a valid parameter type. However, Markings and Filtering Schemes represent the direct state of data interaction, which is a more common and foundational scripting use case.

D. Pages: This is also a valid parameter type, often used for scripts that control navigation or page properties. Like visualizations, it is a structural element, whereas Markings and Filtering Schemes relate to the data state.

1. TIBCO Spotfire® Analyst User's Guide (Version 12.0.3): In the section on scripting

the "Details on Edit Script Parameters" dialog is described. The documentation explicitly lists the available parameter types that can be passed to a script. This list includes "Marking" and "Filtering Scheme" among others like Data Table

Data Column

Page

and Visualization.

Reference: TIBCO Spotfire® Analyst User's Guide

Chapter: "Scripting in Spotfire"

Section: "Details on Edit Script Parameters". The "Type" dropdown in this dialog confirms that Marking and Filtering Scheme are selectable options.

2. TIBCO Spotfire® API Reference: The API documentation for the Spotfire.Dxp.Application.Scripting namespace underpins the functionality seen in the user interface. The methods for adding scripts and defining their parameters accommodate various document model objects. The API supports passing Spotfire.Dxp.Data.DataMarking (Marking) and Spotfire.Dxp.Application.Filters.FilteringScheme (Filtering Scheme) objects as script arguments.

Reference: TIBCO Spotfire® API Reference

Spotfire.Dxp.Application.Scripting.ScriptParameter class and its usage with the ScriptManager class. The documentation shows that parameters can be defined for different types of objects within the Spotfire Document Model.

Linear regression is the statistical algorithm used within TIBCO Spotfire's Data Relationships tool to model and evaluate the relationship between two continuous, numerical variables. It fits a straight line to the data points to quantify the strength and direction of the association between an independent variable and a dependent variable. The tool calculates an R-squared value to indicate how well the model explains the variability of the response data around its mean, which is a key measure for comparing two numerical columns.

A. Chi-square: This test is used to determine if there is a significant association between two categorical variables, not numerical ones.

B. Anova: Analysis of Variance (ANOVA) is used to compare the means of a numerical variable across different groups defined by a categorical variable.

D. Kruskal-Wallis: This is a non-parametric alternative to ANOVA, used for comparing a numerical variable across groups when the assumptions for ANOVA are not met.

1. TIBCO Spotfire® Analyst User's Guide

Version 12.0 LTS. In the section "Details on Data Relationships

" the guide explicitly states the statistical methods used for different column types:

"Comparison of two continuous columns: A linear regression model is fitted to the data. The R-squared value is used as a measure of how well the model fits the data."

"Comparison of two categorical columns: A chi-square test is performed..."

"Comparison of a continuous and a categorical column: An ANOVA test is performed..."

"If the assumptions for the ANOVA test are not met

a Kruskal-Wallis test is performed instead."

(This information is consistently found in user guides for various Spotfire versions

including 10.x

11.x

and 12.x).

TIBCO Spotfire provides a specific set of functions to embed and execute TIBCO Enterprise Runtime for R (TERR) scripts directly within its expression language. These functions are TERRReal(), TERRInteger(), TERRString(), and TERRBoolean(). They allow for row-by-row data processing by passing column values as inputs to the embedded R script.

A primary application for these custom expressions is on the axes of visualizations. This enables dynamic, on-the-fly calculations using the power of R without the need to pre-calculate a new column or run a separate data function. For example, an expression like TERRReal("output <- log(input1)", [Sales]) could be used directly on a visualization's value axis.

A. Register R scripts as data functions: Data functions are a separate, powerful mechanism for executing R scripts, but they are not used within a custom expression. They are registered objects that run independently.

B. In a property control: A property control is a user interface element (e.g., a slider, drop-down) used to modify a document property's value, not to execute an R script.

C. In an action control's actions: An action control (e.g., a button) can be configured to trigger a data function, but this is an event-based execution, not an inline evaluation within a custom expression.

1. TIBCO Spotfire® Analyst 12.0 LTS User's Guide

"Statistical Functions"

Page 429. The guide lists and describes the TERRBoolean

TERRInteger

TERRReal

and TERRString functions. It explicitly states

"You can use these functions when you create a calculated column

or you can use them on a visualization axis." This directly supports options D and E.

2. TIBCO® Enterprise Runtime for R - A TIBCO® Data Science Component Version 1.7

"Using TERR in TIBCO Spotfire®"

Section: "TERR in Spotfire expressions"

Page 11. This document details the usage of TERR functions and provides examples. It clarifies that "You can use these functions anywhere you can use Spotfire's expression language

such as in calculated columns or on visualization axes." This confirms that using these functions (Option E) on an axis (Option D) are correct methods.

3. TIBCO Spotfire® Analyst 12.0 LTS User's Guide

"What are Data Functions?"

Page 503. This section describes data functions as a method to "pass data to a statistical engine... and bring back the results

" which is a distinct process from embedding scripts in expressions. This confirms why option A is incorrect.

The Spotfire.Dxp.Application.Visualizations namespace is the correct location within the TIBCO Spotfire API for classes that represent and allow interaction with visualizations. This namespace contains the specific classes for each visualization type (e.g., BarChart, ScatterPlot, TablePlot) as well as base classes and interfaces that define the common behavior and properties of all visualizations. Developers use these classes to programmatically create, configure, and manipulate visualizations within a Spotfire analysis file.

A. Spotfire.Dxp.Application.Tools: This namespace contains classes for user interaction tools like the Lasso or Rectangle selection tools, not the visualization objects themselves.

B. Spotfire.Dxp.Application.VisualCollection: This is a class, not a namespace. The VisualCollection class, found in the Spotfire.Dxp.Application namespace, represents a collection of Visual objects on a page.

C. Spotfire.Dxp.Application.AnalyticItems: This namespace is used for managing analytic items such as bookmarks, data functions, and information links, not for the core visualization types.

E. Spotfire.Dxp.Application.Visuals: This namespace does not exist. The correct and official namespace is Spotfire.Dxp.Application.Visualizations.

1. TIBCO Spotfire® API Reference: The official documentation explicitly defines the Spotfire.Dxp.Application.Visualizations namespace. The namespace summary states

"Contains classes and interfaces for visualizations." It lists key classes such as BarChart

ScatterPlot

Table

and the base Visualization class.

Source: TIBCO Spotfire® API Reference

Spotfire.Dxp.Application.Visualizations Namespace documentation. (Accessible via the TIBCO documentation portal for registered users/developers).

2. TIBCO Spotfire® Developer Documentation: In the "Getting Started with the TIBCO Spotfire API" guide

examples of manipulating visualizations consistently import and use classes from the Spotfire.Dxp.Application.Visualizations namespace.

Source: TIBCO Spotfire® Developer Documentation

"Getting Started with the TIBCO Spotfire API

" Section on "Working with Visualizations." (e.g.

from Spotfire.Dxp.Application.Visualizations import BarChart).

The TIBCO Spotfire library employs a hierarchical permission model for folders. The Browse permission is the most basic level, allowing a user to see the folder's existence in the library tree. The Access permission allows the user to open that folder and view its contents (e.g., analyses, data files). According to official TIBCO documentation, the Access permission explicitly requires the Browse permission. This combination (Browse + Access) constitutes the standard "read-only" access level, which is a fundamental and correct permission setting for consumers of content within the library.

A. Access + Full Control: This is incorrect because the Full Control permission is the highest level and implicitly includes all lower-level permissions, including Access, making the combination redundant.

B. Browse + Modify: This is incorrect because the Modify permission (to save or delete items) requires the Access permission as a prerequisite, which is missing from this combination.

D. Access + Modify: This is incorrect because the Access permission requires the Browse permission as a prerequisite, which is missing. A user cannot access a folder they cannot see.

1. TIBCO Spotfire® Server and Environment - Installation and Administration Manual

Version 12.0 LTS.

Reference: Chapter 6: Administration Manager

Section: "Folder permissions".

Details: The documentation explicitly outlines the permission hierarchy and dependencies:

"Access folder: Grants permission to open the folder and see its contents. This permission requires the Browse folder permission."

"Modify folder contents: Grants permission to save

rename

and delete items in the folder. This permission requires the Access folder permission."

This confirms that Browse + Access is a valid and required combination for viewing content

and that options B and D are missing necessary prerequisite permissions. It also confirms the redundancy in option A

as Full Control requires Modify

which requires Access.

An information link is a predefined database query stored in the TIBCO Spotfire library. The entire process of creating an information link begins with establishing a connection to the underlying database. This is accomplished by setting up a data source in the Information Designer tool. Without a configured data source, Spotfire has no access to the database schema, and therefore, it is impossible to define any of the subsequent elements required for an information link, such as columns, joins, or filters. The data source is the foundational prerequisite upon which all other information model elements are built.

A. Create Columns: Creating column elements is a necessary step, but it can only be performed after a data source has been set up to expose the available tables and columns.

B. Create Join: Creating a join is an optional step, only required if the information link needs to retrieve data from two or more related tables.

D. Create Multiple Columns: This is a specific instance of creating columns and is subject to the same prerequisite of having a data source configured first.

E. Create Filter: Creating a filter is an optional step used to apply conditions (a WHERE clause) to the query; it is not a mandatory prerequisite.

1. TIBCO Spotfire® Information Designer User's Guide

Version 12.0

Chapter: "Workflow in Information Designer"

Page 10. The documentation explicitly outlines the creation process: "The first thing you must do is to set up one or more data sources. Once a data source is in place

you can start creating the column

join and filter elements that will be the building blocks of your information links." This confirms that setting up a data source is the initial

required step.

2. TIBCO Spotfire® Analyst User's Guide

Version 12.0

Chapter: "Adding Data Connections"

Section: "What is an Information Link?". This section explains that information links are based on data sources that have been set up in Information Designer. It states

"An information link is a database query

specified in the Information Designer... It is built from building blocks such as columns and filters

which have been created from an underlying data source." This reinforces that the data source is the origin for all other components.

TIBCO Streaming is a comprehensive platform for developing and deploying real-time streaming analytics applications. The platform's core components are TIBCO StreamBase Server, the high-performance runtime engine that executes the streaming logic; TIBCO StreamBase Studio, an Eclipse-based integrated development environment (IDE) for building, debugging, and testing applications; and TIBCO LiveView Server, which provides a real-time, push-based data mart and dashboarding system for visualizing and interacting with the streaming data. These three products are bundled together to form the TIBCO Streaming platform.

A. TIBCO Spotfire Server: This is a separate TIBCO product for advanced data visualization and analytics. While it can integrate with TIBCO Streaming, it is not an included component of the TIBCO Streaming installation.

1. TIBCO Streaming 10.6.1 Documentation

Overview Guide

Chapter 1

"Introduction to TIBCO Streaming": This chapter explicitly describes the main components. It states

"TIBCO Streaming is a platform for building systems that analyze and act on streaming data. At its core is the TIBCO StreamBase Server... You develop applications for the server in TIBCO StreamBase Studio... TIBCO LiveView is a component of TIBCO Streaming that provides a real-time

push-based data warehouse and dashboarding system."

2. TIBCO Streaming 10.6.1 Documentation

Installation Guide

Chapter 2

"TIBCO Streaming Product Files": This section details the directory structure created by the installer

which includes distinct top-level directories for streambase (containing the server)

liveview (containing its server)

and studio

confirming they are the primary installed components.

3. TIBCO Streaming 10.6.1 Documentation

What Is TIBCO Streaming? page: The introductory page states

"TIBCO Streaming is the full-featured

enterprise-grade TIBCO solution for streaming analytics... TIBCO Streaming includes TIBCO StreamBase®

TIBCO LiveView™

and the TIBCO® Artifact Management Server." This confirms StreamBase and LiveView are the foundational product lines within the TIBCO Streaming offering.

The TIBCO Spotfire normalization transformation provides several built-in statistical methods. The available options include calculating the Z-score, which is a standardizing formula that subtracts the mean and divides by the standard deviation. Additionally, Spotfire allows for centering the data by subtracting either the column mean or the column median. Using the median provides a robust alternative for centering data that may contain outliers. These three options represent a complete standardization method and the two primary methods for data centering.

B. Normalize by standard deviation: While dividing by the standard deviation is an available method, the chosen set (A, C, E) better represents the most distinct normalization goals: a full standardization (Z-score) and the two alternative centering methods.

D. Normalize by mode: Normalizing by the mode is not a standard statistical technique for scaling continuous data and is not an available method within the TIBCO Spotfire normalization transformation tool.

1. TIBCO Spotfire® Analyst User's Guide

Version 12.0 LTS

"Details on Normalize" section.

This official guide details the methods available in the Normalization transformation dialog. It explicitly lists "Z-score"

"Subtract mean"

and "Subtract median" as distinct options in the "Method" dropdown menu. The guide states:

Z-score: "Calculates the Z-score (standard score) for all values... by first subtracting the column mean and then dividing by the column standard deviation."

Subtract mean: "Subtracts the column mean from all values in the selected columns."

Subtract median: "Subtracts the column median from all values in the selected columns."

Note: The guide also lists "Divide by standard deviation"

making four options from the question technically correct. However

the combination of Z-score and the two centering methods (mean/median) represents the most functionally distinct set of choices for an analyst.

The Pivot transformation in TIBCO Spotfire is used to restructure a data table from a "tall/narrow" format to a "wide/short" format. It accomplishes this by taking the unique values from a single categorical column and converting them into multiple new columns. The values for these new columns are populated from a separate value column, often using an aggregation method. This process effectively pivots data from a row-oriented structure to a column-oriented one.

B. Pivots column values into rows of data: This describes the function of the Unpivot transformation, which is the inverse of Pivot, converting a wide data format into a tall one.

C. Pivots row values to eliminate duplicates: While aggregation during a pivot can handle multiple values for a given intersection, the primary purpose is data restructuring, not duplicate elimination.

D. Pivots column values to summarize correlated data: This is an overly general and imprecise description. The core function of Pivot is a specific structural transformation, not just general summarization.

1. TIBCO Spotfire Analyst User's Guide

Version 12.0 LTS

"Pivoting data" section: "Pivoting is a way to turn data from a 'tall/narrow' format to a 'wide/short' format. It is done by turning the unique values in one column into multiple new columns."

2. TIBCO Spotfire Analyst User's Guide

Version 12.0 LTS

"Details on Pivot Data" dialog: This section details the configuration

requiring the user to specify "Columns to pass through"

"Column to pivot"

and "Columns to transfer and aggregate with"

confirming the mechanism of turning row values into new columns.

3. TIBCO Spotfire Analyst User's Guide

Version 12.0 LTS

"Unpivoting data" section: "Unpivoting is a way to turn data from a 'wide/short' format to a 'tall/narrow' format... This can be seen as the reverse of a pivot transformation." This reference explicitly contrasts the two functions

confirming why option B is incorrect.