IBM P2090-010 Actual Free Exam Questions & Community Discussion

Exam Code/Number: P2090-010
Exam Name/Title: IBM InfoSphere Information Server Technical Mastery Test v2
Certification Provider: IBM
Corresponding Certification: IBM Mastery

Exam Questions: 61
Updated On: Jun 14, 2026

Question #15

Manually populating the Business Glossary (BG) with all the business terms to support your organization would be too time-consuming. Fortunately a number of methods of import and export of business glossary content are available to greatly reduce that effort. Which of the following methods are valid?
-Transfer the full content of a glossary between an 8.1 version of BG and a later version of BG using the XMI format. -Use the XML file format to export and import an entire glossary, including the relationships
between categories and terms. -Use the XML file format to import only a partial glossary containing only selected subcategories. -Use the csv file format to import categories and terms, and all relationships between categories
and terms.

A. I, II, IV

B. I, II, III

C. I, III, IV

D. All methods are valid.

Discussion 0

Correct Answer: B Vote an answer

Question #16

Which statement about FastTrack is NOT TRUE?

A. Changes in mapping specification can be propagated as annotations.

B. In a FastTrack mapping specification involving a lookup, you cannot specify a file that will contain the reject records; this must be performed using the DataStage Designer.

C. When generating a job from a FastTrack specification, you can specify for the source and target the stage type desired (e.g. sequential file, ODBC connector, DB2 stage)

D. When a job is generated from a FastTrack specification, it can contain connection information to access the source and the target.

Discussion 0

Correct Answer: B Vote an answer

Question #17

Which functionality is supported by InfoSphere Discovery?
-Discover primary / foreign key relationships between tables -Discover statistics about usage of data by users -Discover matching source and target data -Discover transformations that, when applied to source columns, will accurately transform the
data to match the data in target columns

A. I, II, III, IV

B. I, II, IV

C. I, II, III

D. I, III, IV

Discussion 0

Correct Answer: D Vote an answer

Question #18

Which tool would you recommend to obtain a clear roadmap of the tasks required to deal with quality issues of data stored in your source databases?

A. InfoSphere QualityStage

B. InfoSphere Information Analyzer

C. InfoSphere Metadata Workbench

D. Use the native DBMS catalog tables, and retrieve the detailed statistics

E. InfoSphere Blueprint Director

F. InfoSphere Discovery

Discussion 0

Correct Answer: E Vote an answer

Question #19

Which type of parallelism does DataStage Parallel Engine support?

A. Partition Parallelism only

B. Explicit Parallelism only

C. Pipeline Parallelism only

D. Implicit Pipeline and Partition Parallelism

Discussion 0

Correct Answer: D Vote an answer

Question #20

FastTrack can be used to consolidate all mapping specifications; these mapping specifications do
not have to be specified from scratch. Which of the following capabilities are offered to accelerate
the definition of mapping specifications?
-Mapping specifications in .csv format files can be imported into FastTrack.
-Data mappings discovered with InfoSphere Discovery can be exported to csv file. These
mappings can then be imported into FastTrack. -Information Analyzer reports from cross-domain analysis can be imported into FastTrack. -DataStage jobs can be reverse-engineered into mapping specifications or mapping
compositions.

A. I, II, III, IV

B. Only I and II

C. I, II, IV

D. I, II, III

E. I, III, IV

Discussion 0

Correct Answer: C Vote an answer

Question #21

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. 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".

B. 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.

C. In Business Glossary, associate the term "Product Brand" with the table BRANDS

D. 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".

Discussion 0

Correct Answer: D Vote an answer

Download Free IBM P2090-010 Demo

Simply submit your e-mail address below to get started with our free demo of your IBM P2090-010 exam.