P2090-045 Online Practice Questions and Answers

Where are Table Definitions stored?

A. Information Server metadata repository

B. In the file system as a binary file

C. In the file system as a csv file

D. None of the above

Which statement about Metadata Workbench is incorrect?

A. It can extend data lineage to display data integration flows that are outside of Information Server

B. It relies on the repository functions in DataStage Designer for impact analysis

C. It displays data lineage reports

D. It allows Metadata Workbench administrators to associate data stewards with data objects

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

Which of the following is a valid Write Mode action in the Connector Stages?

A. Insert

B. Update

C. Delete

D. All of the above

Which of the following stages is NOT a file data access stage?

A. Sequential File Stage

B. Transformer Stage

C. Dataset Stage

D. FileSet Stage

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

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

Which of the following statements is not a supported matching option of the Lookup Stage?

A. Equality match

B. Caseless match

C. Range on the Target Link

D. Range on the Reference Link

Which description below about the Sort Stage is invalid?

A. Sort Stage uses temporary disk space while performing sort

B. It has a property to create a Key Change Column

C. All the incoming records must have different values for sorting key

D. Sort can be executed in sequential mode or parallel mode

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.