TIBCO Spotfire Certified Professional (TCP-SP) — Questions and Answers

Question 1: In TIBCO Spotfire, what does a 'Trellis' visualization do?

Combines two axes into a 3D view
Adds a secondary Y-axis
Splits a visualization into panels based on a category (Correct answer)
Overlays multiple chart types

Correct answer: Splits a visualization into panels based on a category

Trellis (small multiples) splits one chart into a grid of panels, each filtered by a category value.

Question 2: What is the native file format for saving TIBCO Spotfire analyses?

.sfa
.tbx
.dxp (Correct answer)
.spf

Correct answer: .dxp

TIBCO Spotfire saves analyses in the .dxp format, which can contain embedded data, visualizations, and settings.

Question 3: When was Spotfire first released?

1997
1996 (Correct answer)
1995
1998

Correct answer: 1996

Spotfire, now referred to as TIBCO Spotfire, was created by Spotfire Inc. and was made available in 1996. The software transformed the way data might be explored and analyzed by introducing extensive visual analytics features. Users were able to extract insights from their data in a more straightforward and effective way because to Spotfire's dynamic visualizations and user-friendly interface. It offered strong capabilities for data discovery, interactive analysis, and visualization, enabling users to make data-driven decisions.

Question 4: The two filter types that permit the selection of one or more distinct values should be noted.

Check Box (Correct answer)
List Box (Correct answer)
Radio Button
Item

Correct answer: Check Box

To allow the selection of one or more distinct values, user interfaces frequently use the filter types Check Box and List Box. However, not only Check Box and List Box types of filters provide this functionality. Other filter types can also allow the selection of one or more distinct values.

Question 5: In Spotfire IronPython, what is the 'OnDemandSettings' object used for?

Configure server on-demand scaling
Set scheduled refresh intervals
Control on-demand data table query settings such as enabled state and limit expressions (Correct answer)
Manage on-demand rendering of visualizations

Correct answer: Control on-demand data table query settings such as enabled state and limit expressions

OnDemandSettings controls the behavior of on-demand data tables, including whether on-demand mode is active and what trigger expressions to use.

Question 6: In Spotfire, what does the 'UniqueCount' aggregation function return?

Count of columns in the dataset
Count of distinct non-null values in a column (Correct answer)
Count of all rows including nulls
Count of rows where value equals a specified unique value

Correct answer: Count of distinct non-null values in a column

UniqueCount counts only distinct values, ignoring duplicates and nulls, useful for measuring cardinality.

Question 7: What role in Spotfire grants users the ability to publish analyses to the Library?

Author (Correct answer)
Administrator
Library Editor
Consumer

Correct answer: Author

The Author license allows users to create, edit, and publish analyses to the Spotfire Library.

Question 8: In Spotfire, what is the difference between a 'Row filter' and a 'Column filter' transformation?

Row filter applies only to aggregated data
Row filter removes columns; column filter removes rows
They are identical operations
Row filter keeps or removes rows based on criteria; column filter keeps or removes columns (Correct answer)

Correct answer: Row filter keeps or removes rows based on criteria; column filter keeps or removes columns

A row filter removes rows not meeting a condition, while a column filter removes unwanted columns from the dataset.

Question 9: What does Spotfire's 'Confidence interval' band around a trend line represent?

The standard deviation of residuals
The range of all data points
The uncertainty range within which the true regression line likely falls (Correct answer)
The prediction range for new individual data points

Correct answer: The uncertainty range within which the true regression line likely falls

The confidence interval band shows the range where the true mean response line falls with a specified probability (e.g., 95%).

Question 10: In Spotfire, what does 'Correlation coefficient' as a trend line statistic measure?

The number of data points used in the fit
The slope of the regression line
The average prediction error
The strength and direction of the linear relationship between X and Y (Correct answer)

Correct answer: The strength and direction of the linear relationship between X and Y

The correlation coefficient (r) ranges from -1 to +1 and quantifies how strongly and in which direction two variables are linearly related.

Question 11: Integration, event processing, analytics, cloud, and customer loyalty are among the product categories.

True (Correct answer)
False

Correct answer: True

Product categories from TIBCO include Customer Loyalty, Analytics, Cloud, and Event Processing. These groups handle various facets of data administration, processing, analysis, and client engagement, representing diverse areas of focus for TIBCO's software and solutions.

Question 12: These are the several categories of business analytics, with the exception of

Dynamic Analytics (Correct answer)
Prescriptive Analytics
Predictive Analytics
Descriptive Analytics

Correct answer: Dynamic Analytics

Business analytics encompasses various approaches and techniques to analyze data and extract insights for business decision-making. While dynamic analytics is not a commonly recognized term in the field

Question 13: What year did TIBCO purchase Spotfire?

2005
2006
2007 (Correct answer)
2010

Correct answer: 2007

Spotfire, the data visualization and analytics software, was indeed acquired by TIBCO Software Inc. in 2007. TIBCO is a global software company that provides integration, analytics, and event processing solutions for businesses. The acquisition of Spotfire by TIBCO expanded the company's portfolio of data analytics and visualization tools, strengthening its position in the business intelligence and analytics market.

Question 14: What happens when a user opens a '.dxp' file that references an Information Link?

The server rejects the file if the link is not in the Library
Spotfire queries the data source through the Information Link to populate the analysis (Correct answer)
The file prompts to convert the link to an embedded dataset
The analysis opens with no data until the user loads a local file

Correct answer: Spotfire queries the data source through the Information Link to populate the analysis

Opening an analysis with an Information Link causes Spotfire to execute the defined query against the configured data source.

Question 15: You may discover hidden relationships in your data with TIBCO Spotfire.

True (Correct answer)
False

Correct answer: True

TIBCO Spotfire can help you find hidden correlations in your data. You may thoroughly explore and analyze your data with TIBCO Spotfire's powerful analytics and data visualization features. You may find patterns, correlations, and trends in your data by using Spotfire's interactive visualizations, statistical tools, and machine learning algorithms. You can visually explore your data, build dynamic dashboards, and conduct in-depth data analysis using its user-friendly interface.

Question 16: What exactly are Details-On-Demand visualizations?

A window that displays details in a bar chart visualization
Raw data of marked items in a visualization (Correct answer)
An on-demand pivot table visualization
A drill down of scatter plot visualization

Correct answer: Raw data of marked items in a visualization

Details-On-Demand visualization works by responding to user interactions, such as hovering over or clicking on data points or regions of interest within the visualization. Upon interaction, the visualization dynamically displays additional information related to the selected data point or element.

Question 17: Big data analytics software built for self-service that will enable __________ to make data-driven decisions. The most comprehensive set of analytics are provided by TIBCO Spotfire, which unifies them on a single, centrally-managed platform.

A select group
Management
Every individual in the organization (Correct answer)
The cleaning lady

Correct answer: Every individual in the organization

Self-service big data analytics software called TIBCO Spotfire seeks to enable employees of a business to make data-driven decisions. On a single, centrally-managed platform, it offers a complete set of analytics tools and capabilities. Regardless of their level of technical expertise, users may access, analyze, and display vast amounts of data from a variety of sources with Spotfire. A variety of individuals inside the business can use it thanks to its drag-and-drop capabilities and user-friendly layout

Question 18: What is the primary purpose of a Box Plot in Spotfire?

Visualize network connections
Display distribution, median, and outliers of a dataset (Correct answer)
Show correlation between two variables
Compare proportions of categories

Correct answer: Display distribution, median, and outliers of a dataset

A box plot summarizes a dataset's distribution showing median, quartiles, and outliers.

Question 19: What does the OVER function in Spotfire expressions allow you to compute?

Aggregations scoped to a specific set of columns (window/grouping context) (Correct answer)
Loop over rows in a script
Reference values from another table
Filter rows dynamically

Correct answer: Aggregations scoped to a specific set of columns (window/grouping context)

OVER performs an aggregation partitioned by specified columns, similar to SQL window functions, without collapsing rows.

Question 20: What does 'Color By' configuration in a Spotfire visualization control?

The color scheme used to encode a data column's values visually (Correct answer)
The background color of the entire page
The grid line colors
The axis label colors

Correct answer: The color scheme used to encode a data column's values visually

'Color By' maps a data column to color, letting you visually distinguish categories or encode continuous values.

Question 21: Which Spotfire chart allows you to display both bars and a line on the same visualization?

Waterfall chart
Combination chart (Correct answer)
Parallel coordinate plot
Scatter plot

Correct answer: Combination chart

A combination chart lets you layer bar series and line series on the same axes.

Question 22: In Spotfire IronPython, what does 'Document.Properties' provide access to?

Custom document properties that act as analysis-level variables readable/writable by scripts (Correct answer)
Server-side document metadata only
File system properties of the .dxp file
Read-only analysis title and author fields

Correct answer: Custom document properties that act as analysis-level variables readable/writable by scripts

Document properties are custom key-value pairs defined in the analysis that scripts can read and modify to pass data between actions.

Question 23: You may refer to a data analytics software-as-a-service created for data mining as

Spotfire platform
Spotfire desktop
Spotfire cloud (Correct answer)
Spotfire Manager

Correct answer: Spotfire cloud

"Spotfire Cloud" is the name of a data analytics software-as-a-service (SaaS) created for data mining. The cloud-based version of TIBCO Spotfire, a potent data analytics and visualization tool, is called Spotfire Cloud. It includes a variety of advanced analytics tools in addition to data mining capabilities.

Question 24: In Spotfire, what is the purpose of 'Data relationships' between tables?

Define how two data tables are linked so filtered selections propagate between them (Correct answer)
Enforce referential integrity like a database
Automatically join tables in queries
Set primary key constraints

Correct answer: Define how two data tables are linked so filtered selections propagate between them

Data relationships tell Spotfire which columns link two tables so that markings and filters in one table affect the other.

Question 25: Which Spotfire function returns the value of a column from the previous row when data is ordered by a specific column?

Previous
Prior
Lag (Correct answer)
Offset

Correct answer: Lag

Lag retrieves the value from a preceding row by a specified offset, useful for period-over-period calculations.

Question 26: Which Spotfire visualization is best suited for displaying the distribution of a continuous variable using binned intervals?

Pie chart
Histogram (Correct answer)
Bar chart
Scatter plot

Correct answer: Histogram

A histogram groups continuous data into bins to show frequency distribution.

Question 27: In Spotfire, what does 'Replace values' transformation do?

Replaces an entire column's data type
Swaps column positions
Renames column headers
Substitutes specific cell values matching a condition with a new value (Correct answer)

Correct answer: Substitutes specific cell values matching a condition with a new value

Replace values scans a column for matching values or patterns and overwrites them with a specified replacement value.

Question 28: In Spotfire, what does 'Prediction band' show on a trend line chart?

The model's R² value visually
The range within which a new individual data observation is expected to fall (Correct answer)
The confidence interval for the mean
The historical variance of the training data

Correct answer: The range within which a new individual data observation is expected to fall

A prediction band is wider than a confidence interval and shows where individual future data points are expected to land.

Question 29: Which Spotfire visualization is purpose-built for displaying data on a geographic map?

Scatter plot
Heat map
Tree map
Map chart (Correct answer)

Correct answer: Map chart

A map chart plots data points on geographic maps using latitude/longitude or regional boundaries.

Question 30: What statistic does Spotfire display as R² on a trend line, and what does it indicate?

Pearson correlation coefficient
Coefficient of determination showing how much variance in Y is explained by X (Correct answer)
Root mean square error of the fit
Regression coefficient showing slope steepness

Correct answer: Coefficient of determination showing how much variance in Y is explained by X

R² (coefficient of determination) ranges from 0 to 1 and indicates what fraction of the dependent variable's variance the model explains.

Question 31: What is the function of 'Reference lines' in Spotfire charts?

Show trend-line forecasts
Connect data points sequentially
Display confidence intervals
Add fixed or calculated horizontal/vertical lines as benchmarks or thresholds (Correct answer)

Correct answer: Add fixed or calculated horizontal/vertical lines as benchmarks or thresholds

Reference lines draw fixed or aggregated lines (e.g., average, target) on the chart to provide context benchmarks.

Question 32: Which Spotfire chart type is most effective for displaying the composition of a whole across categories?

Box plot
Scatter plot
Stacked bar chart (Correct answer)
Histogram

Correct answer: Stacked bar chart

A stacked bar chart shows part-to-whole relationships by stacking category segments within each bar.

Question 33: You can enter values using one of the upcoming bin techniques.

Even distribution of unique values
Even intervals
Substring
Specific limits (Correct answer)

Correct answer: Specific limits

The ability to specify exact values or thresholds for particular characteristics or settings within the software is referred to as "specific limits" in the context of TIBCO software. Depending on the context, this phrase may be used in a variety of TIBCO products and solutions.

Question 34: Which TIBCO Spotfire tool allows administrators to define reusable, shareable data source connections and queries?

Data Canvas
Spotfire Analyst
Node Manager
Information Designer (Correct answer)

Correct answer: Information Designer

Information Designer is used to create Information Links — reusable, parameterized queries stored in the Spotfire Library for shared use.

Question 35: Which of the following claims about scatter plot is false?

Change the shape of the markers
Determine correlation
Double click the marker and replace its value (Correct answer)
Discover clustering

Correct answer: Double click the marker and replace its value

Regarding Scatter Plot visualization, the adage "Double click the marker and replace its value" is untrue. The main goal of a scatter plot is to show the correlation between two numerical variables. A particular combination of values for the two variables is represented by each data point on the scatter plot. When double-clicking a marker in a standard Scatter Plot, nothing happens to change the marker's value. In a scatter plot, double-clicking is not a typical interaction for changing the data. Instead, depending on the software or tool being used, double-clicking is frequently utilized for a variety of tasks like zooming in or out, opening a tooltip with more information, or carrying out other specified activities.

Question 36: What is the role of 'Data functions' in TIBCO Spotfire?

R or Python scripts that accept Spotfire data tables as input and return results (Correct answer)
Spotfire's custom chart rendering engine
API calls to external web services
Built-in SQL functions for queries

Correct answer: R or Python scripts that accept Spotfire data tables as input and return results

Data functions are R or Python (via TERR or external engines) scripts integrated into Spotfire that process data tables and return new tables or values.

Question 37: The Data Functions Properties dialog is accessible from which menu?

Visualizations
Data (Correct answer)
File
Tools

Correct answer: Data

Depending on the software program or tool you are using, the Data Functions Properties dialog's accessibility and position may change. However, you can often locate the parameters or options relating to data functions within the "Data" or "Formulas" menu in many data analysis or spreadsheet programs.

Question 38: What does a 'Calculated Column' in Spotfire allow you to do?

Filter rows based on conditions
Summarize data at aggregate level only
Join two tables together
Create a new column derived from an expression evaluated per row (Correct answer)

Correct answer: Create a new column derived from an expression evaluated per row

A calculated column computes a new per-row value using Spotfire's expression language and stores it as an additional column.

Question 39: In Spotfire Data Canvas, what does the 'Sample' transformation do?

Generates synthetic data rows
Reduces the dataset to a random or first-N subset for faster development (Correct answer)
Splits data into train and test sets
Creates a statistical sample for hypothesis testing

Correct answer: Reduces the dataset to a random or first-N subset for faster development

The Sample transformation limits rows to a specified count or percentage, useful for prototyping with large datasets.

Question 40: An American firm called TIBCO Software Inc. offers __________ for businesses to utilize either on-premises or as a component of cloud computing environments.

Database cleaning software
Integration, analytics and events processing software (Correct answer)
Data warehousing software
Data modeling software

Correct answer: Integration, analytics and events processing software

An American corporation called TIBCO Software Inc. offers integration, analytics, and event processing software for businesses to use either on-site or in cloud computing settings. The software solutions from TIBCO are made to assist businesses in integrating various systems, analyzing data, and processing events in real-time so they can drive digital transformation.

Question 41: Which of the following claims concerning tree map visualization is accurate?

It usually shows large amounts of hierarchically structured data (Correct answer)
It summarizes a set of categorical data
Levels of hierarchy are visualized as rectangles of different sizes
It often to shows trends over time

Correct answer: It usually shows large amounts of hierarchically structured data

A style of information visualization known as a "tree map" presents hierarchical data in a rectangular format. It is very helpful for displaying hierarchical relationships between vast volumes of data and their representation. The size and color of each nested rectangle in a Tree Map correspond to various data properties, representing the hierarchical structure. Rectangular tiles that can be further subdivided into smaller tiles depending on the data hierarchy levels make up the visualization's general layout.

Question 42: Which standard driver interface does TIBCO Spotfire commonly use to connect to relational databases?

GraphQL
SOAP
ODBC/JDBC (Correct answer)
REST API

Correct answer: ODBC/JDBC

Spotfire supports both ODBC and JDBC drivers to connect to a wide range of relational databases.

Question 43: In Spotfire IronPython, which class is used to programmatically set a list box filter's selected values?

ListBoxFilter (Correct answer)
FilterValue
RangeFilter
CheckBoxFilter

Correct answer: ListBoxFilter

ListBoxFilter is the Spotfire filter class for list/categorical selections and provides methods to set which items are checked.

Question 44: Which chart type in Spotfire is specifically designed to show hierarchical data as nested rectangles?

Sunburst chart
Heat map
Box plot
Tree map (Correct answer)

Correct answer: Tree map

A tree map displays hierarchical data as proportionally sized nested rectangles.

Question 45: In Spotfire, what is a 'KPI chart' primarily used for?

Correlation analysis
Detailed row-level data inspection
Time-series forecasting
Displaying high-level key performance metrics with status indicators (Correct answer)

Correct answer: Displaying high-level key performance metrics with status indicators

A KPI chart displays aggregated metrics with visual status indicators (e.g., green/yellow/red) to quickly communicate performance.

Question 46: In Spotfire, what does enabling 'Show data points' on a line chart do?

Adds individual data markers at each measured point along the line (Correct answer)
Converts the chart to a scatter plot
Shows raw data in a table below the chart
Enables drill-down to row level

Correct answer: Adds individual data markers at each measured point along the line

Enabling 'Show data points' overlays dot markers at each data measurement on the line, making individual observations visible.

Question 47: In Spotfire, what is the 'Marking' feature used for in visualizations?

Adding text annotations to charts
Interactively selecting and highlighting data points across multiple visualizations (Correct answer)
Sorting axis values
Changing the color scale

Correct answer: Interactively selecting and highlighting data points across multiple visualizations

Marking lets users select data points in one visualization and see those same rows highlighted across all linked visualizations.

Question 48: What is a 'Spotfire Web Player'?

A JavaScript library for embedding Spotfire
A server component that renders analyses in a browser without requiring a local Spotfire installation (Correct answer)
A standalone offline viewer for DXP files
A mobile app for Spotfire

Correct answer: A server component that renders analyses in a browser without requiring a local Spotfire installation

The Web Player is a server-side component that serves Spotfire analyses to browsers, eliminating the need for client-side installation.

Question 49: Which Spotfire Server component handles routing analysis requests to available Spotfire nodes?

The database connection pool
The routing service / load balancer within the server (Correct answer)
The Library service
The TERR service

Correct answer: The routing service / load balancer within the server

Spotfire Server includes a built-in routing service that directs client analysis sessions to available web player or analyst nodes.

Question 50: What does the 'Replace Column' transformation do in Spotfire Data Canvas?

Replaces all values in a column with a constant
Renames a column header
Moves a column to a different position
Substitutes an existing column with a new computed expression (Correct answer)

Correct answer: Substitutes an existing column with a new computed expression

Replace Column substitutes an existing column's values with a new expression result, effectively overwriting it in place.

Question 51: What does the 'Percentile([Value], 0.75)' expression compute in Spotfire?

75% of the maximum value
75th row of the dataset
The value below which 75% of the data falls (3rd quartile) (Correct answer)
The average of the top 75% of values

Correct answer: The value below which 75% of the data falls (3rd quartile)

Percentile(column, 0.75) returns the 75th percentile — the value at or below which 75% of observations fall.

Question 52: Which file format is used to save and share a full Spotfire analysis including data?

.sdf
.dxp (Correct answer)
.stdf
.spf

Correct answer: .dxp

The .dxp (Data Exchange Package) format is Spotfire's native analysis file that bundles visualizations, settings, and optionally embedded data.

Question 53: When would you use a 'Waterfall chart' in Spotfire?

To display time-series forecasting
To show geographical distribution
To illustrate cumulative effect of sequential positive/negative values (Correct answer)
To compare category frequencies

Correct answer: To illustrate cumulative effect of sequential positive/negative values

Waterfall charts show how an initial value is affected by a series of intermediate positive or negative values.

Question 54: In Spotfire, which visualization type is most appropriate for showing relationships between nodes in a network?

Network chart (Correct answer)
Combination chart
Waterfall chart
Scatter plot

Correct answer: Network chart

A network chart (graphical table) is designed specifically to display relationships between connected entities.

Question 55: In Spotfire, what is 'Column matching' used for when combining data tables?

Renames columns to match a naming convention
Applies a matching algorithm for fuzzy joins
Checks for duplicate column values
Aligns columns by name or position when unioning or joining tables (Correct answer)

Correct answer: Aligns columns by name or position when unioning or joining tables

Column matching maps columns from one table to another by name or position when performing union or join operations.

Question 56: Which Spotfire feature enables running R or Python statistical models directly integrated with visualizations?

Spotfire Information Links
Custom queries
Spotfire Macros
TIBCO Enterprise Runtime for R (TERR) data functions (Correct answer)

Correct answer: TIBCO Enterprise Runtime for R (TERR) data functions

TERR (TIBCO Enterprise Runtime for R) allows R scripts to be embedded as data functions, processing Spotfire data and returning results back to visualizations.

Question 57: In Spotfire Server, what is the purpose of setting 'Network Address Translation (NAT)' configuration?

Configures firewall rules for data source access
Enables IPv6 support for client connections
Encrypts traffic between Spotfire nodes
Ensures the server advertises the correct external address when behind a load balancer or proxy (Correct answer)

Correct answer: Ensures the server advertises the correct external address when behind a load balancer or proxy

NAT configuration tells Spotfire Server its externally visible address so that client redirect URLs are correct when the server is behind a proxy.

Question 58: The fiscal year of an organization starts in December. What should the "Fiscal Year Offset" be set to?

-1 (Correct answer)
12
1
0

Correct answer: -1

The "Fiscal Year Offset" should typically be set to -1 if an organization's fiscal year starts in December. The adjustment required to bring the fiscal year into line with the calendar year is referred to as the "Fiscal Year Offset." The fiscal year begins one year before the equivalent calendar year when the offset is set to -1. When the fiscal year does not coincide with the conventional calendar year, which starts in January, an adjustment must be made.

Question 59: In Spotfire, what does 'Freeze columns' in a cross-table do?

Locks the leftmost columns so they remain visible when scrolling horizontally (Correct answer)
Disables sorting on those columns
Prevents columns from being deleted
Applies fixed aggregation to frozen columns

Correct answer: Locks the leftmost columns so they remain visible when scrolling horizontally

Freezing columns pins them on the left so they stay in view as you scroll right through wide cross-tables.

Question 60: In Spotfire, what is a 'Parallel Coordinate Plot' primarily used for?

Showing time series trends
Visualizing multi-dimensional data across multiple axes (Correct answer)
Comparing two categorical variables
Displaying geographic data

Correct answer: Visualizing multi-dimensional data across multiple axes

A parallel coordinate plot renders each variable as a vertical axis and draws a polyline per data row to reveal multivariate patterns.

TIBCO Spotfire Certified Professional (TCP-SP)

The TIBCO Spotfire Certified Professional exam validates skills in data connectivity, visualization, analysis, and collaboration using the TIBCO Spotfire analytics platform. It covers data wrangling, chart creation, advanced analytics, and administration tasks.

Questions

35 min

Time Limit

70%

To Pass

Checking for saved progress...

Exam Rules

You can skip questions and return to them later
Flag questions for review before submitting
No feedback shown until you submit the entire exam
Unanswered questions count as wrong — answer everything
10 pretest questions are mixed in and don't affect your score
Timer auto-submits when time runs out
Your progress is auto-saved every 30 seconds

These practice questions were written with AI tools. They are not real exam questions. Exam facts are checked against the official sources listed below. Not reviewed by a subject-matter expert. Editorial policy

Sources & references

Exam facts on this page (fees, format, dates, passing scores) are checked against these official sources; the date is our last check. Editorial policy

credly.com — Eligibility · verified Oct 2026
spotfire.com — Test delivery, eligibility, exam format, passing score · verified Oct 2026