Download TIBCO Data Virtualization Certified Administrator Practice Exam and more Exams Technology in PDF only on Docsity!
Question 1. What is the primary benefit of using TIBCO Data Virtualization (TDV) in an enterprise environment? A) Data duplication B) Centralized physical data storage C) Real-time data integration without replication D) Increased hardware requirements Answer: C Explanation: TDV enables access to and integration of data from disparate sources in real-time, without needing to move or replicate data. Question 2. Which component of TDV is responsible for managing and executing queries against virtualized data? A) TDV Studio B) TDV Server C) TDV Web UI D) Metadata Repository Answer: B Explanation: The TDV Server manages resources, processes client queries, and executes them against the underlying data sources. Question 3. What is the main function of the TDV Metadata Repository? A) Storing user credentials B) Holding virtual database schemas and resource definitions C) Managing server logs D) Scheduling data cache refreshes
Answer: B Explanation: The Metadata Repository stores all virtual database schemas, resource definitions, and configuration information. Question 4. Which TDV component is primarily used by administrators and developers to design and configure data models? A) TDV Server B) TDV Studio C) Web UI D) Repository Utility Answer: B Explanation: TDV Studio is the desktop client used for modeling, configuration, and administrative tasks. Question 5. What does the term “resource” refer to in the TDV platform? A) Any client application B) A unit of metadata such as a data source, view, or procedure C) Operating system process D) A network port Answer: B Explanation: Resources in TDV include objects like data sources, views, procedures, and services defined in the metadata repository. Question 6. Which installation mode allows for automation and scripting during TDV Server deployment?
Question 9. Which protocol is typically used by TDV for secure web administration? A) FTP B) HTTP C) SSH D) HTTPS Answer: D Explanation: HTTPS (HTTP over SSL/TLS) is standard for secure web administration in TDV. Question 10. If the TDV HTTP base port is set to 9400, what is the default SSL port? A) 9443 B) 9500 C) 9401 D) 9000 Answer: A Explanation: By default, TDV sets the SSL port (HTTPS) to 9443 when the HTTP base port is 9400. Question 11. What is the primary purpose of user authentication in TDV? A) To mask sensitive data B) To verify the identity of users accessing the system C) To optimize query performance D) To schedule cache refreshes
Answer: B Explanation: Authentication ensures that only authorized users can access TDV resources. Question 12. What is a TDV “Composite domain”? A) A group of data sources B) The internal domain used for local user and group management C) A network domain controller D) The area where cache groups are defined Answer: B Explanation: The Composite domain in TDV is the built-in domain for managing users, groups, and roles internally. Question 13. Which of the following can be used for external authentication in TDV? A) Local file only B) LDAP, Active Directory, SAML, PAM C) Only Active Directory D) Only SAML Answer: B Explanation: TDV supports various external authentication mechanisms, including LDAP, Active Directory, SAML, and PAM. Question 14. What is the effect of implementing Row-Level Security (RLS) in TDV? A) Hides columns from all users
Question 17. What is a User Template in TDV? A) A predefined data source connection B) A template defining default rights and privileges for users C) A metadata backup file D) A cache configuration Answer: B Explanation: User Templates assign a standardized set of rights and privileges to users or groups. Question 18. How can TDV audit user access to resources? A) By reviewing operating system logs B) Through TDV’s built-in auditing and privilege tracking features C) By inspecting network traffic D) By querying source databases Answer: B Explanation: TDV includes auditing features to monitor access and privileges for compliance and security. Question 19. When is it necessary to change the Repository Password in TDV? A) When changing the base port B) When rotating credentials for security compliance C) When refreshing cache D) When enabling SSL Answer: B Explanation: Password changes are required periodically or when a security risk is identified.
Question 20. Which utility can be used for TDV repository backup and recovery? A) Web UI B) Repository Utility C) Data Source Wizard D) TDV Monitor Answer: B Explanation: The Repository Utility is designed for maintenance tasks like backup, restore, and testing of the metadata repository. Question 21. What is the recommended way to manage the growth of the Metadata Table in TDV? A) Ignore growth B) Regularly monitor and perform cleanup or archiving C) Delete all resources D) Disable repository auditing Answer: B Explanation: Proactive monitoring and scheduled cleanups help prevent performance issues due to metadata table bloat. Question 22. Why is the Java Keystore File important in TDV? A) It stores user passwords B) It holds encryption keys and certificates for secure communication C) It logs JDBC queries
B) To control and limit the number of concurrent or queued requests per user/group/claim C) To expand repository size D) To mask columns Answer: B Explanation: Request limit rules help manage server workload and avoid resource exhaustion. Question 26. How are connection pools used in TDV? A) To cache query results B) To manage and reuse connections to underlying data sources efficiently C) To store user privileges D) To log user activity Answer: B Explanation: Connection pooling improves performance by reusing database connections, reducing overhead. Question 27. Which component is used to monitor server status and resource usage in TDV? A) TDV Manager B) Data Source Wizard C) Cache Editor D) SQL Client Answer: A Explanation: TDV Manager provides tools for monitoring server status and resource activity.
Question 28. Which interface provides real-time and historical performance data in TDV? A) JDBC/ODBC B) TDV Monitor C) Web UI only D) Data Source Editor Answer: B Explanation: TDV Monitor offers insights into real-time and historical server performance metrics. Question 29. What is a thread dump used for in TDV diagnostics? A) To monitor data cache status B) To analyze the state of server threads for troubleshooting C) To optimize queries D) To backup metadata Answer: B Explanation: Thread dumps provide detailed information about running server threads, helping diagnose performance or deadlock issues. Question 30. How does TDV optimize query execution? A) By disabling indexes B) Via the Query Optimizer, which analyzes and rewrites queries for efficiency C) By running queries sequentially D) By increasing the HTTP port Answer: B
D) By restarting the operating system Answer: B Explanation: The Cache Group Editor or Monitor allows administrators to cancel or monitor ongoing cache refreshes. Question 34. What is the purpose of a cache refresh policy in TDV? A) To disable cache functionality B) To define when and how cache is refreshed for accuracy and timeliness C) To encrypt cache data D) To mask columns Answer: B Explanation: Cache refresh policies determine the schedule and rules for updating cached data. Question 35. Which protocol is NOT natively supported for TDV client connectivity? A) JDBC B) ODBC C) SOAP D) FTP Answer: D Explanation: TDV supports JDBC, ODBC, and web services, but not FTP for data access. Question 36. What must be configured to connect TDV to an Oracle database? A) FTP credentials
B) JDBC driver and connection parameters C) Web Service API key D) Windows Firewall rules Answer: B Explanation: JDBC drivers and correct connection parameters are needed for TDV to connect to Oracle databases. Question 37. What task does introspection perform in TDV? A) Encrypts metadata B) Pulls metadata definitions from underlying data sources C) Deletes old logs D) Schedules user audits Answer: B Explanation: Introspection extracts schema details from data sources into TDV for modeling and virtualization. Question 38. Which is a typical cause of introspection failure in TDV? A) Insufficient repository disk space B) Incorrect data source credentials or connection parameters C) Overloaded cache groups D) Disabled user templates Answer: B Explanation: Introspection fails if TDV cannot connect to the data source due to invalid credentials or parameters.
Explanation: The Manager and Cluster Admin interfaces provide real-time cluster status and health information. Question 42. What is required to join a new node to an existing TDV Active Cluster? A) Reinstall the entire cluster B) Synchronize repository and configuration with the cluster C) Delete old cache groups D) Change the repository password Answer: B Explanation: New nodes must synchronize repository and configuration data to function within the cluster. Question 43. Which process ensures disaster recovery for the TDV Metadata Repository? A) Regular repository backups B) Enabling user templates C) Disabling cache groups D) Increasing connection pool size Answer: A Explanation: Routine repository backups are essential for restoring operations in case of failure or disaster. Question 44. What is a recommended strategy for system migration with TDV? A) Manual recreation of all resources B) Exporting and importing repository metadata and configuration
C) Deleting and recreating user privileges D) Disabling cluster synchronization Answer: B Explanation: Export/import of repository and configuration data ensures smooth migration to new environments. Question 45. Which of the following is NOT a TDV resource type? A) Data Source B) View C) Procedure D) Thread Dump Answer: D Explanation: Thread dumps are for diagnostics and are not considered TDV resources. Question 46. What is the effect of increasing the connection pool size for a data source in TDV? A) Reduces available memory B) Allows more concurrent connections, improving throughput C) Disables introspection D) Prevents resource auditing Answer: B Explanation: Larger pools support more concurrent requests, boosting performance for high-traffic sources.
Question 50. What does the “Select” privilege permit in TDV? A) Modifying resources B) Reading resource data C) Executing administrative scripts D) Changing system ports Answer: B Explanation: The Select privilege allows users to read or query resource data without modification rights. Question 51. What is the main use of the TDV Web UI? A) System-level scripting B) Managing resources and monitoring server status via a browser C) Installing server binaries D) Running thread dumps Answer: B Explanation: The Web UI offers browser-based management and monitoring features for TDV. Question 52. Why is it important to monitor the “metrics_requests” table? A) It contains sensitive user passwords B) It provides performance and usage statistics for optimization C) It stores all user privileges D) It manages connection pools
Answer: B Explanation: The table offers insights into system performance and request patterns. Question 53. What happens if the TDV Metadata Repository is not regularly backed up? A) No impact B) Risk of permanent data loss and prolonged recovery in case of failure C) Increased query speeds D) Unaffected user authentication Answer: B Explanation: Without backups, repository failures can lead to unrecoverable data loss. Question 54. Which authentication mechanism allows for user credentials to be managed externally in TDV? A) Composite domain only B) LDAP/Active Directory C) Web UI only D) Local password file Answer: B Explanation: LDAP and Active Directory externalize credential management for user authentication. Question 55. What is the main advantage of column masking in TDV? A) Increases server memory B) Protects sensitive data by obfuscating or hiding column values for certain users
