P2090-045 Online Practice Questions and Answers

A Job Sequence CANNOT contain __________.

A. Transformer Stages

B. Sequencer Stages

C. Triggers

D. Job Activity Stages

Which of the following components need to be up and running in order to use InfoSphere Discovery Studio?

A. WAS (WebSphere Application Server)

B. The ASB agent

C. The database holding the Information Server Metadata Repository

D. All of the above

E. None of the above

Which of the following CANNOT be defined in the DataStage configuration file?

A. Degree of parallelism

B. Scratch disk dedicated for sorting

C. Compilation options for DataStage jobs

D. A named pool including only part (some) of the nodes

Under which scenario may a user benefit from using InfoSphere Discovery?

A. Automate data relationship discovery

B. Prototype a data model for the first time

C. Automate transformation rule discovery

D. Automate business object identification

E. All of the above

Which of the following statements about InfoSphere Data Architect is correct?

A. You CANNOT create a logical model from a physical model

B. InfoSphere Data Architect can deploy physical data models directly to the database management system

C. Reverse engineering data models only works for DB2 databases

D. InfoSphere Data Architect is installed using the Information Server installation wizard

Which of the following statements about FastTrack is incorrect?

A. The only way to combine data in a FastTrack mapping specification is to create a lookup definition

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

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

D. Changes in mapping specifications are propagated to previously generated DataStage jobs as annotations

In which situation below can you use the Metadata Asset Manager with the MetaBrokers and Bridges (Import/Export Manager) to import metadata into the Metadata Repository?

A. To bring runtime information about DataStage jobs into the Metadata Repository

B. To bring FastTrack mapping specifications into the Metadata Repository

C. To bring Cognos BI reports and queries into the Metadata Repository

D. To bring a blueprint from Blueprint Director into the Metadata Repository

What are the file format types when you use DataStage Designer to export objects?

A. TXT and XML

B. DSX and CSV

C. DSX and XML

D. TXT and CSV

Information Services Director provides multiple binding options. Which of the following statements about bindings is correct?

A. Multiple bindings can be associated to the same service

B. The choice of binding depends on the information provider used

C. Bindings are set at the application level

D. Bindings are set at the individual operation level

A DataStage job can be executed from_______________

A. DataStage Administrator client only

B. DataStage Administrator or Director client

C. DataStage Director client only

D. DataStage Designer or Director client.