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

A. determining the number and frequency of unique values in a single domain

B. identifying all the data sources for data consolidation

C. discovering the actual values of missing data

D. transforming the data from one data type to another

A. Export Job Logs

B. Improve Job Performance

C. Encapsulate job components for reuse

D. Import Metadata

A. Ability for Business Glossary to automatically use the terms defined in the IDA glossary model

B. Ability to create physical data model by reverse-engineering from DB2, Oracle, Sybase, Microsoft SQL Server and Teradata

C. Ability to import an Erwin model into Data Architect

D. Ability to import pre-built IBM industry models into Data Architect

A. Delivering information as a service

B. Addressing data quality

C. Removing duplicate records

D. Delivering trusted master data

E. Developing business driven Business Intelligence

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

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

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

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

A. You need to create a brand new warehouse, using the ETL tool of your choice; the target warehouse is Oracle

B. A new data source must be integrated in an Oracle warehouse environment; the customer insists that you continue using their current ETL tool which is DataStage

C. You need to create a brand new warehouse, using the ETL tool of your choice; the target warehouse is DB2

D. A new data source must be integrated in a DB2 warehouse environment; the customer insists that you continue using their current ETL tool which is not DataStage

A. There is a little icon associated to the element.

B. There is a little green arrow associated to the element.

C. You need to double click the element.

D. There is a littleicon associated to the element.