IBM P2090-010 Exam Overview:
| Certification Vendor: | IBM |
| Exam Name: | IBM InfoSphere Information Server Technical Mastery Test v2 |
| Exam Number: | 000-N10 |
| Related Certifications: | IBM InfoSphere Information Server Technical Mastery Test v2 (P2090-010) |
| Real Exam Qty: | 61 |
| Available Languages: | English |
| Exam Format: | Multiple Choice Questions |
| Recommended Training: | IBM Training |
| Exam Registration: | IBM Training and Certification |
| Sample Questions: | IBM P2090-010 Sample Questions |
| Exam Way: | IBM online assessment / mastery test delivery |
| Pre Condition: | No formal prerequisite listed. Intended for professionals with knowledge of IBM InfoSphere Information Server solutions. |
| Official Syllabus URL: | https://www.ibm.com/training/certification |
IBM P2090-010 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| IBM InfoSphere Information Server | - Metadata Workbench
|
IBM InfoSphere Information Server Technical Mastery Test v2 Sample Questions:
1. In Business Glossary, you have defined a term named "Product Brand". The names of these product brands are in an operational database table named BRANDS. Some of these brands are not valid. What would be the best way to enable BG users to see an up-to-date list of valid product brands?
A) In Business Glossary, associate the term "Product Brand" with the table BRANDS
B) Create a reference table of valid brands with Information Analyzer. Create a service which returns the list of valid brands from the reference table. Then, in Business glossary, invoke the service from a custom attribute named VALIDBRANDS, and associate this attribute with the term "Product Brand".
C) Create a new table VALIDBRANDS in the operational database, and copy only the valid values in that table. Then, in Business Glossary, associate the term "Product Brand" with the table VALIDBRANDS.
D) Create a reference table of valid brands with Information Analyzer. Then, in Business Glossary, create a custom attribute named VALIDBRANDS, and write the values of the valid brands, using the reference table data. Associate the custom attribute with the term "Product Brand".
2. Regarding Metadata Workbench, which of the following statements is TRUE?
A) It creates operational and data lineage reports.
B) It creates business, data and operational lineage reports.
C) It creates business and data lineage reports.
D) It creates architectural, data and operational lineage reports.
3. What are the steps required in Information Analyzer before you can investigate the output generated by running a data rule?
A) Select Data Quality from the Develop tab; create a data rule definition; generate a data rule; run the data rule
B) Select Data Quality from the Develop tab; generate a data rule; run the data rule
C) Select Data Quality from the Investigate tab; create a data rule definition; generate a data rule; run the data rule
D) Select Data Quality from the Develop tab; create a data rule definition; generate a data rule
4. In Version 8.5 of Metadata Workbench, the concept of business lineage was introduced. Which capability does business lineage provide?
A) Specific assets may be selected for exclusion from business lineage reports
B) A DataStage job can be used as a source asset type when creating a business lineage report
C) A business lineage report displays the jobs involved in the lineage but not the individual stages in each job
D) Business lineage shows the hierarchy of users, groups and roles
5. Which type of analysis in Information Analyzer can create a sample set of data for on-going analysis?
A) Table analysis
B) Column analysis
C) Cross-table analysis
D) Baseline analysis
Solutions:
| Question # 1 Answer: B | Question # 2 Answer: C | Question # 3 Answer: A | Question # 4 Answer: A | Question # 5 Answer: B |
We're so confident of our products that we provide no hassle product exchange.


By Bonnie

