TIBCO Introduction To TIBCO Spotfire 5 — Questions and Answers
Question 1: In TIBCO Spotfire, what does the 'Unpivot' transformation accomplish?
- It rotates rows into columns to create a wide-format table
- It converts multiple value columns into two columns—one for the attribute name and one for the value—creating a long-format table (Correct answer)
- It removes duplicate rows based on a key column
- It sorts rows in descending order by a selected column
Correct answer: It converts multiple value columns into two columns—one for the attribute name and one for the value—creating a long-format table
Unpivot converts wide-format data (many value columns) into long format with an attribute column and a value column, which is often needed for Spotfire visualizations.
Question 2: Which Spotfire color scheme type assigns colors based on predefined ranges or thresholds of a continuous numerical column?
- Categorical color scheme
- Gradient color scheme with fixed segment points (Correct answer)
- Single-color scheme
- Random color scheme
Correct answer: Gradient color scheme with fixed segment points
A segmented or fixed-point gradient color scheme in Spotfire assigns distinct color bands to specific value ranges on a continuous scale.
Question 3: What is the purpose of a 'Spotfire Library' in the server environment?
- A local folder on the user's desktop for storing DXP files
- A centralized repository on the Spotfire Server for storing and sharing analyses, templates, data connections, and information links (Correct answer)
- A package manager for installing Spotfire extensions
- A read-only archive of historical data snapshots
Correct answer: A centralized repository on the Spotfire Server for storing and sharing analyses, templates, data connections, and information links
The Spotfire Library is a server-side repository where teams store, version, and share analyses, data connections, and other Spotfire objects.
Question 4: In a Spotfire map chart, what is the role of a 'feature layer'?
- It defines the color gradient for heat maps
- It overlays geographic shapes (polygons, points, lines) from a spatial data source onto the base map (Correct answer)
- It sets the zoom level and map center coordinates
- It converts address strings to latitude/longitude coordinates
Correct answer: It overlays geographic shapes (polygons, points, lines) from a spatial data source onto the base map
A feature layer in Spotfire's map chart renders geographic features (regions, boundaries, routes) from a spatial file or WMS service on top of the base map.
Question 5: Which Spotfire expression function would you use to count the number of distinct values in a column named [CustomerID] within a calculated column or custom expression?
- Count([CustomerID])
- CountDistinct([CustomerID]) (Correct answer)
- UniqueCount([CustomerID])
- Sum(If([CustomerID]<>Null,1,0))
Correct answer: CountDistinct([CustomerID])
CountDistinct() is the Spotfire expression function that returns the number of unique non-null values in the specified column.
Question 6: What does enabling 'Include empty rows' in a Spotfire cross table or pivot table do?
- Adds blank rows at the bottom of the table for manual data entry
- Ensures that category values with no data still appear as rows with null or zero values (Correct answer)
- Hides rows where all measures are zero
- Exports empty rows to Excel for formatting purposes
Correct answer: Ensures that category values with no data still appear as rows with null or zero values
Including empty rows forces Spotfire to show every category value in the grouping dimension, even if that category has no matching data rows.
Question 7: In TIBCO Spotfire, which component manages user authentication, licenses, and access control for a multi-user deployment?
- Spotfire Analyst client
- Spotfire Server (Correct answer)
- TERR engine
- Spotfire Data Streams
Correct answer: Spotfire Server
The Spotfire Server handles user authentication (LDAP/AD or built-in), license allocation, and permission management across the deployment.
TIBCO Introduction To TIBCO Spotfire 5
In TIBCO Spotfire, what does the 'Unpivot' transformation accomplish?