TIBCO Data Virtualization 4 — Questions and Answers
Question 1: In TIBCO Data Virtualization, what does 'data masking' accomplish for sensitive columns?
- Encrypts data at rest in the TDV cache storage
- Replaces real sensitive values with obfuscated values for unauthorized users (Correct answer)
- Deletes sensitive columns from the virtual view permanently
- Compresses sensitive data to reduce bandwidth consumption
Correct answer: Replaces real sensitive values with obfuscated values for unauthorized users
Data masking in TDV substitutes real values (e.g., SSNs, credit card numbers) with masked equivalents for users who lack access to the raw data.
Question 2: What is the TDV 'Business Directory' used for?
- Storing LDAP credentials for authentication
- Providing a searchable catalog of published data assets for business users (Correct answer)
- Scheduling batch ETL jobs across data sources
- Managing TDV server cluster node registrations
Correct answer: Providing a searchable catalog of published data assets for business users
The Business Directory is a self-service catalog that lets business users discover and understand available published data resources.
Question 3: When TDV performs a federated join between an Oracle source and a Salesforce source, where does the join computation occur by default if neither source can handle the full query?
- In the Oracle database as the primary source
- In TDV's in-memory execution engine on the server (Correct answer)
- In the client application after both result sets are streamed
- In Salesforce since it is the cloud source
Correct answer: In TDV's in-memory execution engine on the server
When push-down is not fully possible, TDV retrieves partial result sets from each source and performs the join in its own in-memory engine.
Question 4: Which TDV configuration setting limits the maximum number of rows returned by a virtual view to prevent runaway queries?
- Query Timeout
- Row Limit Governor (Correct answer)
- Cache Threshold
- Adapter Connection Pool Size
Correct answer: Row Limit Governor
The Row Limit Governor in TDV caps the number of rows a query may return, protecting source systems and server memory from unbounded result sets.
Question 5: In TDV's SOAP web service publishing, what document defines the operations and data types exposed by a TDV service?
- JSON Schema
- WSDL (Web Services Description Language) (Correct answer)
- OpenAPI Specification
- GraphQL Schema
Correct answer: WSDL (Web Services Description Language)
TDV generates a WSDL document that describes the SOAP service interface, including input/output message schemas and operation names.
Question 6: What TDV feature allows a virtual view to automatically substitute a backup data source if the primary source becomes unavailable?
- Query Modeler fallback
- Source failover / redundant data source configuration (Correct answer)
- Cache-as-primary mode
- Adapter hot-swap
Correct answer: Source failover / redundant data source configuration
TDV supports redundant data source configuration so that if the primary source fails, queries automatically route to a designated backup source.
Question 7: Which TDV mechanism allows row-level security so that different users querying the same view receive only their authorized rows?
- Column masking policies
- Row-level security filters tied to user identity (Correct answer)
- Separate physical views per user group
- Encrypted query parameters
Correct answer: Row-level security filters tied to user identity
TDV supports row-level security by injecting user-identity-based filters into queries so each user sees only their permitted rows from the same view.
TIBCO Data Virtualization 4
In TIBCO Data Virtualization, what does 'data masking' accomplish for sensitive columns?