Online Access Free P2090-010 Exam Questions

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

• A.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.
• B.A single business lineage report can contain lineage information about design time and run time.
• C.The pre-defined query ?ob Operational run?displays statistical information about a DataStage job run, but does not show operational lineage.
• D.Operational metadata is only available for DataStage/QualityStage jobs.

Which project below will benefit less from using the full range of Foundation Tools products?

• A.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
• B.You need to create a brand new warehouse, using the ETL tool of your choice; the target warehouse is Oracle
• C.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
• D.You need to create a brand new warehouse, using the ETL tool of your choice; the target warehouse is DB2

Which kind of interaction are supported between infoSphere Discovery and the other infoSphere foundation tools?

• A.infoSphere Discovery mapping specifications can be saved in a csv format and be imported into FastTrack.
• B.In infoSphere Discovery, you can generate a Datastage job from a mapping specification.
• C.In infoSphere Discovery, you can associate target columns in the mapping specification with business terms from the Business glossary.
• D.The result from a column analysis in infoSphere Discovery can be exported to the ladb database of information Analyzer for future analysis.

For which tool do you need to install the Business Glossary Eclipse plug-in in order to associate a business term to a physical asset such as a column in a relational table?

• A.Blueprint Director
• B.InfoSphere Discovery
• C.Data Architect
• D.Information Analyzer
• E.FastTrack

InfoSphere Data Architect is not part of the Information Server Suite. So, can metadata from this tool be brought into the Metadata Repository?

• A.Both a physical model and a glossary model can be exported from Data Architect to the Metadata Server.
• B.Only a physical model can be exported from Data Architect to the Metadata Server.
• C.No, metadata cannot be imported into the Metadata Repository from InfoSphere Data Architect.
• D.Only a glossary model can be exported from Data Architect to the Metadata Server.