TIBCO Data Virtualization 2 — Questions and Answers
Question 1: In TIBCO Data Virtualization, what is the primary role of a 'published resource'?
- A resource exposed to consumers via a data service endpoint (Correct answer)
- A resource stored in a physical relational database
- A resource used only for internal ETL transformations
- A resource that has been archived for audit purposes
Correct 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.
Question 2: Which TDV feature allows administrators to control which users can access specific virtual views?
- Data Source Adapters
- Role-Based Access Control (RBAC) (Correct answer)
- Procedure Caching
- Introspection Scheduler
Correct answer: Role-Based Access Control (RBAC)
TDV uses Role-Based Access Control to grant or restrict user access to virtual views and resources.
Question 3: What happens during the 'introspection' phase in TDV when connecting to a new data source?
- TDV copies all source data into its own cache
- TDV reads and imports the metadata schema of the data source (Correct answer)
- TDV runs performance benchmarks on the data source
- TDV creates a physical replica of the source tables
Correct 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.
Question 4: Which type of TDV procedure is used to encapsulate complex business logic and return a result set to callers?
- Trigger procedure
- SQL Script procedure (Correct answer)
- Adapter procedure
- Diagnostic procedure
Correct answer: SQL Script procedure
SQL Script procedures in TDV allow developers to write procedural logic that can return result sets to calling applications.
Question 5: In TDV, what does 'late binding' mean in the context of virtual views?
- Views are compiled at design time into a static query plan
- SQL queries against views are resolved and executed at runtime against the current source (Correct answer)
- Views are bound to a single fixed data source permanently
- Data is pre-fetched during off-peak hours
Correct 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.
Question 6: Which TDV capability allows a single virtual table to combine rows from two physically separate databases?
- Data replication
- Union view (Correct answer)
- Snapshot caching
- Data masking
Correct answer: Union view
A union view in TDV merges row sets from multiple sources into a single virtual table without physically moving data.
Question 7: What is the significance of the TDV 'query plan' in performance tuning?
- It shows how many users are connected to the server
- It reveals how TDV decomposes and routes a query across data sources (Correct answer)
- It lists all cached result sets currently in memory
- It displays the physical storage layout of source databases
Correct 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.
TIBCO Data Virtualization 2
In TIBCO Data Virtualization, what is the primary role of a 'published resource'?