TIBCO Data Virtualization 3

Question 1

In TDV, what is 'push-down optimization' and why is it beneficial?

Accepted Answer

Delegating query filtering and aggregation to the source system to reduce data transferred to TDV

Answer

Push-down optimization sends WHERE clauses, joins, and aggregations to the source engine, minimizing data movement and improving performance.

Question 2

Which TDV Studio feature lets developers visually join two virtual tables by dragging columns onto a canvas?

Accepted Answer

Query Modeler

Answer

The Query Modeler in TDV Studio provides a graphical interface for building join conditions and combining virtual resources.

Question 3

When a TDV view has caching enabled, what triggers a cache refresh by default?

Accepted Answer

On a configured schedule or when the cache is explicitly cleared

Answer

TDV cache refresh is driven by a configured time-based schedule or a manual/API-triggered invalidation, not real-time source change detection.

Question 4

What TDV concept describes organizing virtual resources into a hierarchical namespace similar to a file system?

Accepted Answer

Resource tree (catalog/schema/resource)

Answer

TDV organizes all virtual resources in a catalog-schema-resource hierarchy that mirrors relational naming conventions.

Question 5

In TDV, which protocol is most commonly used when exposing virtual data to BI tools like Tableau or MicroStrategy?

Accepted Answer

JDBC/ODBC

Answer

BI tools connect to TDV using JDBC or ODBC drivers, treating TDV like a standard relational database.

TIBCO - Assessment Test Practice Test