Data Virtualization Flashcards

In TIBCO Data Virtualization, what is the primary role of a 'published resource'?

Answer: A resource exposed to consumers via a data service endpoint

Published resources in TDV are exposed through data service endpoints so that consumers can query them.

Which TDV feature allows administrators to control which users can access specific virtual views?

Answer: Role-Based Access Control (RBAC)

TDV uses Role-Based Access Control to grant or restrict user access to virtual views and resources.

What happens during the 'introspection' phase in TDV when connecting to a new data source?

Answer: TDV reads and imports the metadata schema of the data source

Introspection reads the schema metadata (tables, columns, data types) from a data source without copying the actual data.

Which type of TDV procedure is used to encapsulate complex business logic and return a result set to callers?

Answer: SQL Script procedure

SQL Script procedures in TDV allow developers to write procedural logic that can return result sets to calling applications.

In TDV, what does 'late binding' mean in the context of virtual views?

Answer: SQL queries against views are resolved and executed at runtime against the current source

Late binding means TDV resolves and pushes down the query to underlying sources at the time of execution, not at design time.

Which TDV capability allows a single virtual table to combine rows from two physically separate databases?

Answer: Union view

A union view in TDV merges row sets from multiple sources into a single virtual table without physically moving data.

What is the significance of the TDV 'query plan' in performance tuning?

Answer: It reveals how TDV decomposes and routes a query across data sources

The query plan shows the execution steps TDV uses to decompose, push down, and federate a query, which is key for performance optimization.