TIBCO X Certified Professional 2 — Questions and Answers
Question 1: In TIBCO Spotfire, which data function language allows you to run R scripts directly within an analysis?
- TERR (TIBCO Enterprise Runtime for R) (Correct answer)
- Python 3.x engine
- JavaScript API
- MATLAB integration
Correct answer: TERR (TIBCO Enterprise Runtime for R)
TERR is TIBCO's own R-compatible runtime that lets analysts execute R scripts as data functions within Spotfire.
Question 2: When configuring a Spotfire Information Link, what is the primary purpose of a 'Join' element?
- Combine columns from multiple data source tables (Correct answer)
- Filter rows based on a condition
- Aggregate numeric columns
- Sort result rows before loading
Correct answer: Combine columns from multiple data source tables
A Join element in an Information Link defines how two or more tables from a data source are combined on matching key columns.
Question 3: Which Spotfire feature enables end-users to interact with a visualization by selecting items that automatically filter all other visualizations on the page?
- Marking (Correct answer)
- Bookmarks
- Details-on-Demand
- Filters Panel
Correct answer: Marking
Marking allows users to select data points in one visualization and have that selection propagate as a filter to all linked visualizations.
Question 4: A calculated column in Spotfire that references a column from a different data table must use which syntax?
- [TableName].[ColumnName] (Correct answer)
- ${TableName.ColumnName}
- TableName::ColumnName
- Ref([TableName],[ColumnName])
Correct answer: [TableName].[ColumnName]
Cross-table column references in Spotfire expressions use the bracket notation [TableName].[ColumnName].
Question 5: In Spotfire Server, what role grants users the ability to author and publish analyses to the library?
- Author (Correct answer)
- Consumer
- Analyst
- Administrator
Correct answer: Author
The Author role in Spotfire Server provides the license level required to create and publish analyses to the library.
Question 6: Which visualization type in Spotfire is best suited for displaying hierarchical, part-to-whole relationships across multiple levels?
- Treemap (Correct answer)
- Bar chart
- Scatter plot
- Box plot
Correct answer: Treemap
A Treemap displays hierarchical data as nested rectangles sized by a value measure, making it ideal for part-to-whole comparisons across levels.
Question 7: When a Spotfire data table is configured with 'On-demand loading', what triggers the actual data retrieval?
- A user marking or filtering that changes the active data subset (Correct answer)
- Opening the analysis file
- Publishing to the library
- Refreshing the server license
Correct answer: A user marking or filtering that changes the active data subset
On-demand loading defers data retrieval until the user interacts with the analysis in a way that defines a specific data subset, such as applying a filter or marking.
TIBCO X Certified Professional 2
In TIBCO Spotfire, which data function language allows you to run R scripts directly within an analysis?