Download TIBCO Data Virtualization Certified Associate Practice Exam and more Exams Technology in PDF only on Docsity!
Question 1. What is the primary purpose of TIBCO Data Virtualization (TDV)? A) Data replication B) Real-time data integration without data movement C) Data backup D) Data deletion Answer: B Explanation: TDV provides real-time integration and access to data from multiple sources without moving or replicating the data. Question 2. Which component acts as the central query engine in TDV architecture? A) Repository B) Studio C) TDV Server D) Web Service Layer Answer: C Explanation: The TDV Server is responsible for processing queries and integrating data from various sources. Question 3. What distinguishes data virtualization from traditional ETL processes? A) It stores data in a warehouse B) It moves data into staging tables C) It provides real-time access without data replication D) It only supports flat files Answer: C Explanation: Unlike ETL, data virtualization does not move or replicate data but provides on-demand access to source data.
Question 4. Which of the following is a key benefit of TDV? A) Increased data silos B) Data duplication C) Agility in data delivery D) Manual coding requirements Answer: C Explanation: TDV increases agility by allowing fast and flexible integration of disparate data sources. Question 5. In TDV, what is a "Resource"? A) Only a database B) Any physical or virtual object, such as data sources, views, or procedures C) Only a file D) Only a user Answer: B Explanation: Resources in TDV include data sources, views, procedures, and more, both physical and virtual. Question 6. Where is metadata stored in the TDV platform? A) TDV Server B) Repository C) Studio D) Output Panel Answer: B Explanation: The Repository stores all metadata, including configurations and resource definitions. Question 7. What is the function of the Studio in TDV?
B) A virtualized representation of a source object C) A user profile D) A security group Answer: B Explanation: Base Views are virtualized representations of tables or files from data sources. Question 11. What is introspection in TDV? A) Data compression B) Process of analyzing a data source to generate metadata and base views C) Running queries D) Encrypting data Answer: B Explanation: Introspection examines the structure of a data source and creates metadata objects like Base Views. Question 12. Which TDV component provides a web interface for end-users? A) TDV Server B) Web Service Layer C) Repository D) Console Panel Answer: B Explanation: The Web Service Layer exposes data and services to users through a web interface. Question 13. When exporting TDV resources, what is typically created? A) A physical table copy B) A .zip or .xml configuration file
C) A user account D) A database backup Answer: B Explanation: Exported resources are packaged as configuration files, often in .zip or .xml formats. Question 14. Which tab in TDV Studio is primarily used for resource modeling? A) Modeler B) Manager C) Discovery D) Output Answer: A Explanation: The Modeler tab is the primary interface for resource creation and manipulation. Question 15. What does the Workspace Editor allow you to do? A) Store metadata B) Edit and design resources C) Run server diagnostics D) Monitor user logins Answer: B Explanation: The Workspace Editor is used for designing and editing resource definitions and views. Question 16. Which of the following is a physical resource in TDV? A) Derived View B) Data Source C) Business View
Answer: B Explanation: Derived Views are used for SQL transformations and data manipulation logic. Question 20. What is a virtual resource in TDV? A) A user login B) A view or procedure based on one or more data sources C) A physical database D) An operating system process Answer: B Explanation: Virtual resources, like views or procedures, are built on top of physical sources. Question 21. Which of the following best describes the TDV Repository? A) A file system B) A metadata database C) A virtual view D) A server process Answer: B Explanation: The Repository is a dedicated storage space for all metadata in TDV. Question 22. What is the primary function of the Manager perspective in Studio? A) Writing SQL B) Managing users, roles, and server settings C) Editing resource logic D) Viewing output logs Answer: B
Explanation: The Manager perspective is used for administrative tasks like user management. Question 23. What is a "Procedure" in TDV? A) A user manual B) A parameterized virtual resource that can execute complex logic C) A physical table D) A network protocol Answer: B Explanation: Procedures are reusable logic modules, often with parameters, for advanced operations. Question 24. How does TDV enable security at the resource level? A) Using only firewalls B) Assigning permissions to resources for users and roles C) Disabling access D) Encrypting files only Answer: B Explanation: Resource-level security is managed via permissions assigned to users and roles. Question 25. Which source system is NOT natively supported by TDV adapters? A) Relational databases B) Flat files C) Hadoop/Big Data D) Mainframe tapes Answer: D Explanation: TDV supports many sources, but mainframe tapes are not directly supported.
Question 29. What must be defined to connect to a SOAP-based Web Service in TDV? A) JSON schema B) WSDL endpoint C) FTP server D) SMTP address Answer: B Explanation: SOAP Web Services connections require the WSDL (Web Services Description Language) URL. Question 30. Which layer exposes TDV resources as RESTful endpoints? A) Repository B) Web Service Layer C) Modeler D) Data Source Answer: B Explanation: The Web Service Layer publishes resources as REST or SOAP web services. Question 31. What is the main difference between a Base View and a Derived View? A) Base Views are physical, Derived Views are virtual B) Base Views are introspected, Derived Views are user-defined C) Base Views cannot be edited, Derived Views can D) Base Views are for files, Derived Views for tables Answer: B Explanation: Base Views are auto-generated via introspection, while Derived Views are created by users. Question 32. Which TDV feature allows moving resources between environments?
A) Manual scripting B) Export/Import utility C) Query caching D) User impersonation Answer: B Explanation: The Export/Import utility enables moving resources between different TDV environments. Question 33. What does the Output panel show in Studio? A) Resource hierarchy B) Results of operations, errors, and execution logs C) Server status D) User activity Answer: B Explanation: The Output panel displays logs, errors, and messages from executed operations. Question 34. How are resources organized in TDV Modeler? A) Random list B) In a hierarchical folder structure C) By server process D) By user group Answer: B Explanation: Resources are organized in folders and subfolders for clarity and management. Question 35. What is a mandatory parameter when configuring any new TDV Data Source? A) Owner name
C) REST endpoint D) WSDL file Answer: A Explanation: ODBC connections require a Data Source Name (DSN) specific to ODBC. Question 39. Which TDV Studio feature helps track changes to resources? A) Output panel B) Version history C) Web Service Layer D) CSV export Answer: B Explanation: Version history allows users to review and revert changes to resources. Question 40. What is the first step when creating a new virtual resource in TDV? A) Running a query B) Selecting the parent folder C) Defining user access D) Setting up caching Answer: B Explanation: The parent folder must be selected to organize the new resource appropriately. Question 41. Which TDV resource can be parameterized for reusable logic? A) Base View B) Procedure C) Data Source
D) Output log Answer: B Explanation: Procedures can have parameters for flexible, reusable data logic. Question 42. Which of the following best describes TDV’s approach to data integration? A) Batch loading B) Federated, real-time access C) Periodic replication D) Flat file transfers Answer: B Explanation: TDV uses a federated approach for real-time integration across sources. Question 43. What does "delegation" mean in TDV query processing? A) Assigning user roles B) Pushing operations down to the source systems C) Archiving resources D) Creating folders Answer: B Explanation: Delegation refers to offloading query operations to the underlying source systems for efficiency. Question 44. Which tool in TDV Studio is used to create new Views? A) Output panel B) Modeler C) Manager D) Console
Explanation: The Workspace Editor displays the outcome of executed queries and view results. Question 48. Which of the following is a required step after creating a new Data Source? A) Setting up a user group B) Testing the connection C) Rebooting the server D) Deleting the old source Answer: B Explanation: Testing ensures the Data Source is configured and accessible before use. Question 49. Which TDV feature supports development-to-production migration? A) Output panel B) Export/Import resources C) Query caching D) Manual scripting Answer: B Explanation: Export/Import functionality is key for moving resources between environments. Question 50. What is the primary method for restricting access to sensitive data in TDV? A) View-only mode B) Resource-level permissions C) Output panel D) Hiding folders Answer: B Explanation: Access control is managed through assigning permissions at the resource level.
Question 51. What is a Derived View in TDV used for? A) Storing raw data B) Transforming and combining data from multiple sources C) Managing users D) Server configuration Answer: B Explanation: Derived Views enable data transformation and integration across sources. Question 52. What type of source is NOT typically virtualized in TDV? A) Relational database B) Flat file C) Printer output D) Hadoop system Answer: C Explanation: Printer outputs are not data sources; the others are commonly virtualized. Question 53. What does the TDV query engine do with unsupported functions? A) Ignores them B) Processes them locally C) Fails the query D) Translates to SQL Answer: B Explanation: Unsupported functions are processed by TDV’s engine, not pushed down to sources.
A) Base View B) Derived View C) Data Source D) User Answer: B Explanation: Derived Views can aggregate and join data from multiple underlying resources. Question 58. What is the minimum privilege needed to edit a resource? A) View permission B) Edit permission C) Delete permission D) No permission Answer: B Explanation: Edit privilege is required to modify an existing resource. Question 59. Which adapter allows TDV to connect to Oracle databases? A) ODBC B) JDBC C) FTP D) HTTP Answer: B Explanation: JDBC is the preferred adapter for connecting to Oracle and other relational databases. Question 60. What does the Resource Properties editor allow you to do? A) Set server time
B) Edit resource metadata and configuration C) Run queries D) Monitor network traffic Answer: B Explanation: The Properties editor is used to configure and update resource settings. Question 61. Which of the following is an example of a non-relational data source in TDV? A) MySQL database B) JSON file C) SQL Server D) Oracle Answer: B Explanation: JSON files are non-relational; the others are relational databases. Question 62. What does caching in TDV accomplish? A) Deletes old data B) Stores query results for faster access C) Encrypts data D) Changes user permissions Answer: B Explanation: Caching saves query results to improve performance on repeated requests. Question 63. Which TDV resource would you use for complex, parameterized SQL logic? A) Base View B) Procedure
