TIBCO Data Virtualization 3 — Questions and Answers
Question 1: In TDV, what is 'push-down optimization' and why is it beneficial?
- Storing query results on edge servers to reduce latency for remote users
- Delegating query filtering and aggregation to the source system to reduce data transferred to TDV (Correct answer)
- Compressing data before sending it to client applications
- Rewriting SQL into a proprietary TDV format for faster parsing
Correct answer: Delegating query filtering and aggregation to the source system to reduce data transferred to TDV
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?
- Procedure Editor
- Query Modeler (Correct answer)
- Cache Manager
- Metadata Importer
Correct answer: Query Modeler
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?
- Every time a new user connects to the server
- On a configured schedule or when the cache is explicitly cleared (Correct answer)
- Automatically whenever the source data changes
- Only when the TDV server restarts
Correct answer: On a configured schedule or when the cache is explicitly cleared
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?
- Data lineage graph
- Resource tree (catalog/schema/resource) (Correct answer)
- Adapter registry
- Execution pipeline
Correct answer: Resource tree (catalog/schema/resource)
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?
- REST over HTTP/JSON
- JDBC/ODBC (Correct answer)
- SOAP over HTTPS
- FTP file transfer
Correct answer: JDBC/ODBC
BI tools connect to TDV using JDBC or ODBC drivers, treating TDV like a standard relational database.
Question 6: What is the purpose of TDV's 'data lineage' feature?
- To track which users modified a view's SQL definition
- To trace the origin and transformation path of data from source to consumer (Correct answer)
- To log all failed query executions for audit compliance
- To measure network latency between TDV and each data source
Correct answer: To trace the origin and transformation path of data from source to consumer
Data lineage in TDV maps how data flows from physical sources through transformations to end consumers, supporting governance and impact analysis.
Question 7: Which TDV component is responsible for translating source-specific SQL dialects into TDV's internal query representation?
- Execution Engine
- Data Source Adapter (Correct answer)
- Cache Manager
- Publish Layer
Correct answer: Data Source Adapter
Data Source Adapters handle dialect translation, converting TDV's internal query into the specific SQL or API format required by each source.
TIBCO Data Virtualization 3
In TDV, what is 'push-down optimization' and why is it beneficial?