PR000005 practice question 6 of 25
Which of the following is not true when it comes to creating and updating Reference Tables?
Full set: 140 questionsThe statement that is not true is C. The Informatica Analyst and Developer tools are clients that connect to the same, shared Model Repository Service (MRS). The MRS acts as a central repository for storing metadata for all projects and objects, including Reference Tables. An object, such as a Reference Table, created or maintained in the Analyst tool is stored in the MRS and is accessible from the Developer tool, and vice versa (subject to permissions). They do not use separate repositories.
A. Reference Tables can be updated from a Value Frequency list in the Developer This is a true statement. The Developer tool allows users to create or append data to a reference table directly from the value frequency results of a column profile, which is a common method for populating reference data.
B. All except Un-Managed Reference Tables can be updated through the Reference Table Manager in the Analyst This is a true statement. The Analyst tool's Reference Table Manager is designed to create, edit, and manage the content of managed reference tables (stored in the MRS). It can only view the content of unmanaged reference tables (external database tables).
D. Reference Tables can be imported and exported using the Developer Tool This is a true statement. Reference tables are standard objects within the Model Repository and can be imported and exported using the Developer tool's object management features or infacmd command-line utilities, facilitating migration between environments. ---
1. Informatica 10.5 Application Service Guide, "Model Repository Service," Page 11.
This guide states, "The Model Repository Service is a relational database that stores the metadata for projects and objects that you create in the Developer tool and the Analyst tool." This directly refutes option C by confirming both tools use a single, shared repository.
2. Informatica 10.5 Data Quality Analyst Guide, "Reference Tables," Page 10.
This document clarifies, "You can use the Reference Table Manager to create, view, edit, and delete managed reference tables... You can view the data in an unmanaged reference table, but you cannot edit the data or delete the table." This confirms that option B is a true statement.
3. Informatica 10.5 Data Quality Developer Tool Guide, "Create a Reference Table from Profile Results," Page 513.
This section provides instructions on how to populate a reference table from profiling results: "You can create a reference table from the value frequency statistics in a column profile. You can also add the value frequency statistics to an existing reference table." This confirms that option A is a true statement.
4. Informatica 10.5 Developer Tool Guide, "Object Import and Export," Page 50.
This chapter details the process for moving assets between repositories. It states, "You can import and export repository objects between repositories in the same domain or in different domains." Reference tables are repository objects and are included in this functionality, confirming option D is a true statement.
Keep practicing
Take the free PR000005 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other PR000005 practice questions
- Question 1When you select Suggestion List mode what statement is true?
- Question 2How much data can DQA handle?
- Question 3What is the primary purpose of grouping data?
- Question 4Which definition describes Column Profiling?
- Question 5Which parameter function is supported in IDQ 9.1?
- Question 7Which of the following will Impact the total amount of time it takes to execute a column …
