TIBCO Trivia 3 — Questions and Answers
Question 1: In TIBCO Spotfire, which scripting language is natively embedded for writing custom scripts?
- IronPython (Correct answer)
- JavaScript
- R only
- Groovy
Correct answer: IronPython
IronPython is the natively embedded scripting language in Spotfire for automation and customization.
Question 2: What is the purpose of the Spotfire 'Information Link'?
- A reusable data query definition connecting Spotfire to a data source (Correct answer)
- A hyperlink embedded in a visualization
- A shared bookmark between users
- A connection between two data tables
Correct answer: A reusable data query definition connecting Spotfire to a data source
Information Links are named, reusable query definitions stored in the Spotfire library that connect to databases.
Question 3: Which Spotfire feature allows end users to view and interact with analyses through a web browser without installing the full client?
- Spotfire Web Player (Correct answer)
- Spotfire Cloud
- Spotfire Analyst Lite
- Spotfire Portal
Correct answer: Spotfire Web Player
Spotfire Web Player enables browser-based access to analyses without requiring the full Analyst client installation.
Question 4: What does the 'OVER' function do in Spotfire custom expressions?
- Computes an aggregation over a specified subset or grouping of data (Correct answer)
- Filters data over a time period
- Applies a calculation over all pages
- Overlays one chart on top of another
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 5: Which Spotfire feature enables real-time data refresh from a streaming source?
- Data on Demand with streaming connector
- Scheduled updates
- Live connection (Correct answer)
- SBDF streaming
Correct answer: Live connection
Live connections in Spotfire allow visualizations to query the data source in real time without importing data.
Question 6: In Spotfire, what is a 'calculated column'?
- A column derived from an expression evaluated row by row on the data table (Correct answer)
- A column imported from a database calculation
- A column that sums other columns automatically
- A column visible only in certain visualizations
Correct answer: A column derived from an expression evaluated row by row on the data table
A calculated column is a virtual column whose values are computed from a Spotfire expression applied to each row.
Question 7: Which library item type in TIBCO Spotfire stores shared color schemes for use across multiple analyses?
- Color scheme (Correct answer)
- Theme
- Style template
- Palette file
Correct answer: Color scheme
Color schemes can be saved to the Spotfire library and reused across different analyses and visualizations.
TIBCO Trivia 3
In TIBCO Spotfire, which scripting language is natively embedded for writing custom scripts?