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

Question 1: In TIBCO Spotfire, what does adding a 'Trend Line' to a scatter plot provide?

Adds error bars to each point
Groups points into clusters
Fits a mathematical model (e.g., linear, polynomial) to show data trends (Correct answer)
Connects all points with a line

Correct answer: Fits a mathematical model (e.g., linear, polynomial) to show data trends

A trend line fits a regression model to the scatter plot data, visually indicating the overall direction and rate of change.

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

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

Correct answer: Network chart

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

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

The grid line colors
The color scheme used to encode a data column's values visually (Correct answer)
The background color of the entire page
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 4: What does Spotfire's column matching feature do when combining multiple data tables using 'Add Rows'?

It sorts all columns alphabetically before appending rows
It merges duplicate column names into a single averaged column
It maps columns from the source table to corresponding columns in the target table by matching names and data types (Correct answer)
It requires the user to manually drag and drop each column pair to define the mapping

Correct answer: It maps columns from the source table to corresponding columns in the target table by matching names and data types

Column matching automatically aligns columns from both tables by comparing names and compatible types, filling unmatched columns with null values.

Question 5: What does the 'OVER' function do in Spotfire custom expressions?

Filters data over a time period
Overlays one chart on top of another
Applies a calculation over all pages
Computes an aggregation over a specified subset or grouping of data (Correct answer)

Correct answer: Computes an aggregation over a specified subset or grouping of data

The OVER clause in Spotfire expressions computes aggregations scoped to a specified grouping, similar to SQL window functions.

Question 6: What is the purpose of the 'NodeId()' function in Spotfire's expression language?

Returns the internal row index identifier for each row (Correct answer)
Generates a unique UUID per row
Returns the network node ID in a graph chart
Returns the database primary key

Correct answer: Returns the internal row index identifier for each row

NodeId() returns Spotfire's internal zero-based row index, useful for uniquely identifying rows in expressions.

Question 7: In TIBCO Spotfire, which component manages user authentication, licenses, and access control for a multi-user deployment?

Spotfire Data Streams
Spotfire Server (Correct answer)
TERR engine
Spotfire Analyst client

Correct answer: Spotfire Server

The Spotfire Server handles user authentication (LDAP/AD or built-in), license allocation, and permission management across the deployment.

Question 8: 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 mobile app for Spotfire
A standalone offline viewer for DXP files

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 9: Which Spotfire visualization is best suited for displaying the distribution of a continuous variable using binned intervals?

Pie chart
Scatter plot
Bar chart
Histogram (Correct answer)

Correct answer: Histogram

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

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

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

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 11: In Spotfire, what does 'Freeze columns' in a cross-table do?

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

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 12: Which Spotfire visualization property, when enabled, allows a map chart to automatically zoom to the extent of the currently marked data?

Marked data extent lock
Zoom to marked rows (Correct answer)
Auto-fit axis
Dynamic scaling

Correct answer: Zoom to marked rows

'Zoom to marked rows' on a map visualization automatically adjusts the map viewport to fit the geographic extent of the currently marked data points.

Question 13: 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 14: In Spotfire, what is the 'Marking' feature used for in visualizations?

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

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 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. <br> 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 happens when a user clicks 'Refresh Data' in a TIBCO Spotfire analysis that uses linked data sources?

All linked data sources are re-queried to retrieve the latest data from the source (Correct answer)
Only the currently visible page is recalculated
Embedded data tables are overwritten from a local file
The analysis file is deleted and must be rebuilt from scratch

Correct answer: All linked data sources are re-queried to retrieve the latest data from the source

Refreshing data re-executes the queries for all linked data sources, pulling in any updates that have occurred since the last load.

Question 17: What is a 'linked' data connection in TIBCO Spotfire?

A connection shared between multiple users simultaneously
A connection that joins two data tables on a common key
A data source reference stored externally that can be refreshed to load updated data (Correct answer)
A hyperlink inside a visualization to an external URL

Correct answer: A data source reference stored externally that can be refreshed to load updated data

A linked data connection stores a reference to an external source, allowing users to refresh the analysis to pull in the latest data.

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

FilterValue
CheckBoxFilter
ListBoxFilter (Correct answer)
RangeFilter

Correct answer: ListBoxFilter

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

Question 19: Which Spotfire panel allows you to search for and browse all visualizations, filters, and pages within an open analysis?

Data Panel
Filters Panel
Details-on-Demand Panel
Navigator Panel (Correct answer)

Correct answer: Navigator Panel

The Navigator panel provides a hierarchical view of all pages, visualizations, and supporting objects in the current analysis.

Question 20: What is the role of 'Action Logs' in TIBCO Spotfire Server?

Record user activity events such as logins, Library access, and analysis opens for auditing (Correct answer)
Monitor server CPU and memory usage
Track IronPython script execution history
Log automated data refresh results

Correct answer: Record user activity events such as logins, Library access, and analysis opens for auditing

Action Logs capture user activity for compliance and auditing purposes, recording who accessed what analysis and when.

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

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

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 22: In Spotfire, what does the 'UniqueCount' aggregation function return?

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

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 23: What is the maximum number of rows that a Spotfire in-memory data table can typically handle before performance degrades significantly?

Unlimited with no performance impact
Exactly 10 million rows
Exactly 1 million rows
Around 100 million rows depending on RAM (Correct answer)

Correct answer: Around 100 million rows depending on RAM

Spotfire in-memory analytics can handle roughly 100 million rows depending on available RAM and data complexity.

Question 24: What language is used for scripting automation directly within TIBCO Spotfire analyses?

IronPython (Correct answer)
JavaScript
R
Lua

Correct answer: IronPython

Spotfire uses IronPython (.NET implementation of Python 2.7) as its built-in scripting language for automating analysis behavior.

Question 25: Which statistical curve type in Spotfire's trend line fits data that grows or decays exponentially?

Linear
Logistic
Polynomial
Exponential (Correct answer)

Correct answer: Exponential

An exponential curve fits data where the rate of change is proportional to the current value, such as population growth.

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

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

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 27: In Spotfire, what is a 'KPI chart' primarily used for?

Correlation analysis
Time-series forecasting
Detailed row-level data inspection
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 28: What is the purpose of the 'Size By' encoding in a Spotfire scatter plot?

Controls the font size of labels
Adjusts the axis scale
Maps a numeric column to the size of each data point marker (Correct answer)
Sets the chart canvas dimensions

Correct answer: Maps a numeric column to the size of each data point marker

'Size By' encodes a numeric measure as the physical size of each marker, creating a bubble-like effect.

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

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

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 30: In Spotfire Server, what is the purpose of setting 'Network Address Translation (NAT)' configuration?

Configures firewall rules for data source access
Encrypts traffic between Spotfire nodes
Enables IPv6 support for client connections
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 31: 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
The cleaning lady
Management
Every individual in the organization (Correct answer)

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. <br> 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 32: When combining two data tables using 'Add Rows' in TIBCO Spotfire, what must be true about the two tables?

They must have identical row counts
They must both be embedded, not linked
They must come from the same database connection
They must share at least one column with matching names and compatible data types for alignment (Correct answer)

Correct answer: They must share at least one column with matching names and compatible data types for alignment

When adding rows, Spotfire uses column matching by name and type to align data; columns that match are stacked, and non-matching columns get null values.

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

120 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