TIBCO Data Connections and Data Sources 3

Question 1

Which authentication method allows TIBCO Spotfire to use a user's Windows credentials when connecting to a SQL Server database?

Accepted Answer

Windows Integrated Authentication (Kerberos/NTLM)

Answer

Basic (username/password) authentication

Answer

Token-based OAuth 2.0 authentication

Answer

Certificate-based mutual TLS authentication

Question 2

What is the key difference between the 'Add Rows' and 'Add Columns' operations in TIBCO Spotfire's data panel?

Accepted Answer

'Add Rows' appends records vertically from another table; 'Add Columns' joins tables horizontally on a key

Answer

'Add Rows' works only for numeric data; 'Add Columns' works only for text data

Answer

'Add Rows' requires an ODBC connection; 'Add Columns' requires JDBC

Answer

They are interchangeable and perform the same operation

Question 3

What is the role of ODBC drivers in TIBCO Spotfire data connections?

Accepted Answer

They provide a standardized interface that allows Spotfire to communicate with databases that support ODBC

Answer

They render ODBC-formatted charts in the visualization layer

Answer

They replace the need for a Spotfire Server when connecting to databases

Answer

They are only used for importing flat files like CSV and Excel

Question 4

When deploying TIBCO Spotfire Web Player (Spotfire Business Author), what must be configured on the server to allow web users to access data connections?

Accepted Answer

Data source connections and credentials must be configured and authorized on the Spotfire Server

Answer

A separate standalone database must be installed on each client machine

Answer

Each web user must install Spotfire Analyst locally to authenticate

Answer

Web users can only access embedded data; live connections are unavailable in the web client

Question 5

What is the main advantage of using Information Links over ad-hoc direct database connections in TIBCO Spotfire?

Accepted Answer

Information Links are reusable, centrally managed, and can be shared across the organization without exposing connection credentials to end users

Answer

Information Links execute queries faster because they bypass the Spotfire Server

Answer

Information Links automatically convert all data to an in-memory format

Answer

Information Links support only Excel files, making them more secure

Question 6

In TIBCO Spotfire, which data loading strategy provides the most current data at all times without manual user intervention?

Accepted Answer

In-database mode where queries run against the live source on every interaction

Answer

Embedded data with scheduled email exports

Answer

Linked data with automatic scheduled refresh configured in Spotfire Server

Answer

Manual refresh triggered by the user each morning

Question 7

What does Spotfire's column matching feature do when combining multiple data tables using 'Add Rows'?

Accepted Answer

It maps columns from the source table to corresponding columns in the target table by matching names and data types

Answer

It sorts all columns alphabetically before appending rows

Answer

It merges duplicate column names into a single averaged column

Answer

It requires the user to manually drag and drop each column pair to define the mapping