TIBCO Data Wrangling and Transformation 2 — Questions and Answers
Question 1: In Spotfire, what is an 'On-demand data table'?
- A table that loads only when a user opens it
- A table that fetches data from the database only when triggered by a filter or parameter change (Correct answer)
- A cached static table
- A table that auto-refreshes every minute
Correct answer: A table that fetches data from the database only when triggered by a filter or parameter change
On-demand tables execute their query only when prompted by a filter, input control, or marking change, reducing unnecessary data loads.
Question 2: What does the 'Pivot' transformation accomplish in Spotfire?
- Rotates the chart 90 degrees
- Converts row values into column headers, aggregating values (Correct answer)
- Sorts rows alphabetically
- Filters rows based on a pivot value
Correct answer: Converts row values into column headers, aggregating values
Pivot reshapes data from long to wide format by turning distinct values in a category column into new column headers.
Question 3: In Spotfire, what is the purpose of 'Data relationships' between tables?
- Enforce referential integrity like a database
- Define how two data tables are linked so filtered selections propagate between them (Correct answer)
- Automatically join tables in queries
- Set primary key constraints
Correct answer: Define how two data tables are linked so filtered selections propagate between them
Data relationships tell Spotfire which columns link two tables so that markings and filters in one table affect the other.
Question 4: Which Spotfire feature lets you combine rows from two tables with the same columns vertically?
- Join
- Union (Correct answer)
- Pivot
- Merge
Correct answer: Union
A union appends rows from two tables with matching column structures into a single stacked dataset.
Question 5: What does 'Data on demand' setting 'Prompt for new data' mean in Spotfire?
- Asks the user to upload a new file
- Waits for user input in a prompt dialog before executing the data query (Correct answer)
- Automatically refreshes data from the source
- Enables streaming real-time data
Correct answer: Waits for user input in a prompt dialog before executing the data query
This setting displays a parameter prompt to the user before issuing the query, allowing customized query input.
Question 6: In Spotfire, what is 'Column matching' used for when combining data tables?
- Renames columns to match a naming convention
- Aligns columns by name or position when unioning or joining tables (Correct answer)
- Checks for duplicate column values
- Applies a matching algorithm for fuzzy joins
Correct answer: Aligns columns by name or position when unioning or joining tables
Column matching maps columns from one table to another by name or position when performing union or join operations.
TIBCO Data Wrangling and Transformation 2
In Spotfire, what is an 'On-demand data table'?