TIBCO Data Wrangling and Transformation 2

Question 1

In Spotfire, what is an 'On-demand data table'?

Accepted Answer

A table that fetches data from the database only when triggered by a filter or parameter change

Answer

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?

Accepted Answer

Converts row values into column headers, aggregating values

Answer

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?

Accepted Answer

Define how two data tables are linked so filtered selections propagate between them

Answer

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?

Accepted Answer

Union

Answer

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?

Accepted Answer

Waits for user input in a prompt dialog before executing the data query

Answer

This setting displays a parameter prompt to the user before issuing the query, allowing customized query input.

TIBCO - Spotfire Practice Test