IBM InfoSphere Information Server Technical Mastery Test v2 Sample Questions:

1. Which of the following statements is TRUE about mapping specification?

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) A single mapping specification can contain columns from multiple source tables, but only columns from a single target table.
C) A single mapping specification cannot contain more than one lookup table.
D) In a mapping specification, source and target columns can be annotated with business terms from the Business Glossary.

2. Two statements describe the role of DataStage in Information Analyzer. Which ones are they?
-DataStage can receive published results from Information Analyzer. -DataStage metadata import process must be used before Information Analyzer has access to the source data. -When an analysis is performed in Information Analyzer, one or more DataStage jobs are generated and executed. -DataStage user roles are defined to provide access to the source data being analyzed.

A) I and II
B) I and III
C) III and IV
D) II and III
E) II and IV

3. 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, III, IV
C) All methods are valid.
D) I, II, III

4. Which of the following sentences is NOT TRUE about the Information Services Director architecture?

A) Information Services can be deployed using the Information Server console.
B) Information Services Director is a set of EJBs running in the services tier of InfoSphere Information Server.
C) Information Services can be deployed using the ISDAdmin command line interface.
D) Most of the processing involved in the execution of a service operation is done in the services tier of InfoSphere Information Server.

5. Metadata Workbench can display operational metadata information. Which one of the following assertions is FALSE?

A) A single business lineage report can contain lineage information about design time and run time.
B) Operational metadata is only available for DataStage/QualityStage jobs.
C) The pre-defined query ?ob Operational run?displays statistical information about a DataStage job run, but does not show operational lineage.
D) Available statistics about the execution of a DataStage job include the number of records read and written by the DataStage job, the time the job started and ended; and the stages and links used in the job.

Solutions: