IBM InfoSphere Information Server Technical Mastery Test v2 - P2090-010 Exam Practice Test

A. A join operation cannot be included as part of a single mapping specification; it must be defined as part of a mapping composition.

B. In a mapping specification, source and target columns can be annotated with business terms from the Business Glossary.

C. A single mapping specification can contain columns from multiple source tables, but only columns from a single target table.

D. A single mapping specification cannot contain more than one lookup table.

A. InfoSphere Business Glossary and InfoSphere Metadata Workbench

B. InfoSphere DataStage and InfoSphere QualityStage

C. InfoSphere Business Glossary and InfoSphere Metadata Repository

D. InfoSphere Information Analyzer and InfoSphere DataStage

E. InfoSphere Information Analyzer and InfoSphere Discovery

A. Operational Metadata is automatically stored in the Metadata Repository when any job has run.

B. Operational Metadata doesn't need to be imported to become available in lineage.

C. Operational Metadata is created when any foundation tool has run.

D. Operational Metadata needs to be imported for it to be available in lineage.

A. InfoSphere QualityStage

B. InfoSphere Discovery

C. InfoSphere Metadata Workbench

D. InfoSphere Information Analyzer

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

F. InfoSphere Blueprint Director

A. Lack of information standards

B. Too many records containing the default value for a single domain

C. Data values appear on report in different format than stored

D. Too many data values for a single domain

A. The operational metadata is automatically stored in the Metadata Repository.

B. When running a DataStage job, you need to specify that the operational metadata must be kept, and it will automatically be stored in the Metadata Repository.

C. The Metadata Workbench administrator just needs to run the runtime binding services.

D. The Metadata Workbench administrator must run a utility to import the operational metadata about jobs into the Metadata Repository.

A. Yes, all the metadata related to the stored procedure can be imported into the Metadata Server using MetaBrokers and Bridges (Import/Export Manager). The data lineage diagram will contain a stored procedure icon linked to the table and files.

B. No, because the transformation from the 3 files to the DB2 table is not done via a DataStage job.

C. Yes, the Metadata Workbench administrator just needs to run the automated services.

D. Yes, but it requires the Metadata Workbench Administrator to create an extended mapping document, which contains mapping rows between the source files and the DB2 table along with the business rules used to perform the transformations. The data lineage diagram will contain an extended mapping icon linked to the table and files.