TIBCO X Certified Professional 3 — Questions and Answers
Question 1: Which Spotfire expression function returns the number of distinct values in a column within the current aggregation context?
- UniqueCount() (Correct answer)
- Count()
- CountDistinct()
- DistinctValues()
Correct answer: UniqueCount()
UniqueCount() is Spotfire's built-in aggregation function that counts only distinct (non-duplicate) values in a column.
Question 2: In Spotfire, what is a 'Bookmark' primarily used for?
- Saving the current state of filters, markings, and visual settings for later recall (Correct answer)
- Storing a permanent copy of data in the library
- Pinning a specific row to always appear at the top of a table
- Sharing a dashboard link with external users
Correct answer: Saving the current state of filters, markings, and visual settings for later recall
Bookmarks capture the full interactive state of an analysis—filters, markings, zoom levels—so it can be restored instantly.
Question 3: Which Spotfire Server component is responsible for authenticating users against LDAP or Active Directory?
- Authentication module configured in the server configuration tool (Correct answer)
- Information Services
- Web Player service
- Automation Services
Correct answer: Authentication module configured in the server configuration tool
Authentication against external directories like LDAP or Active Directory is configured through the Spotfire Server's authentication module in the server configuration tool.
Question 4: A Spotfire action control is set to run an IronPython script on click. Where must this script be saved to be accessible across the organization?
- In the Spotfire Library as a shared script (Correct answer)
- In the local Windows file system of the analyst
- In the PostgreSQL metadata database
- In a TERR package repository
Correct answer: In the Spotfire Library as a shared script
Scripts intended for organization-wide reuse must be stored in the Spotfire Library so they can be referenced and shared across analyses.
Question 5: What does the 'OVER' clause accomplish in a Spotfire custom expression?
- Defines a grouping context for aggregation independent of the visualization's axes (Correct answer)
- Filters rows before aggregation
- Sorts the result of an aggregation
- Joins two columns together
Correct answer: Defines a grouping context for aggregation independent of the visualization's axes
The OVER clause lets you specify a custom grouping (e.g., OVER ([Category])) so the aggregation runs over that group rather than the visualization's default axis grouping.
Question 6: In Spotfire Web Player, which feature allows an administrator to pre-render analyses so users experience faster load times?
- Pre-caching (analysis pre-loading) (Correct answer)
- On-demand rendering
- Lazy evaluation
- Server-side bookmarks
Correct answer: Pre-caching (analysis pre-loading)
Pre-caching causes the Web Player to load and render specified analyses before users request them, reducing perceived load time.
Question 7: Which Spotfire visualization property, when enabled, allows a map chart to automatically zoom to the extent of the currently marked data?
- Zoom to marked rows (Correct answer)
- Auto-fit axis
- Dynamic scaling
- Marked data extent lock
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.
TIBCO X Certified Professional 3
Which Spotfire expression function returns the number of distinct values in a column within the current aggregation context?