P2090-045 Online Practice Questions and Answers

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

A. Append

B. Replace

C. Truncate

D. All of the above

In DataStage, which client can be used to set environment variables at project level?

A. DataStage Designer

B. DataStage Administrator

C. DataStage Director

D. Information Server Web Console

What action will a Lookup Stage take when "Drop" is selected as the Lookup Failure Option?

A. Stage reports an error

B. Stage skips the input record

C. Stage rejects the Input record

D. Job gets aborted

In DataStage Sequential File Stage, how is a NULL value represented?

A. By a space character

B. By a 'NULL' string

C. A -1 for an integer field and an empty string for a VARCHAR field

D. As defined by the Developer in the extended properties of the field

How can FastTrack speed up the process of creating new source-to-target mapping specifications?

I.Reverse engineer existing DataStage jobs II.Automatically discover column mappings using matches on column names III.Leverage metadata imported from other Information Server modules IV.FastTrack automatically converts data lineage reports into mapping specifications

A. I, II, III, IV

B. II, III, IV

C. I, II, IV

D. I, II, III

Which Stage requires identical metadata in order to combine data?

A. Lookup Stage

B. Funnel Stage

C. Join Stage

D. Transformer Stage

A Transformer Stage can have __________.

A. One input link, one or more reject links, one otherwise link, one or more output links

B. One or more input links, one or more reject links, one otherwise link, one or more output links

C. One input link, one reject link, one otherwise link, one or more output links

D. One or more input links, one reject link, one otherwise link, one or more output links

InfoSphere Data Architect is not part of the Information Server Suite. Which statement about sharing metadata with the Metadata Repository is correct?

A. Metadata CANNOT be imported into the Metadata Repository from Data Architect

B. Only a physical model can be exported from Data Architect to the Metadata Repository

C. Only a logical model can be exported from Data Architect to the Metadata Repository

D. Both, a physical model and a logical model can be exported from Data Architect to the Metadata Repository

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 DataStage, Table Definitions can be imported through __________.

A. DataStage Administrator

B. Information Server Web Console

C. DataStage Designer

D. DataStage Director

Which of the following is NOT a function provided by the DB2 Connector Stage?

A. Deletes rows from a DB2 table

B. Reads a DB2 table

C. Automatically updates table definitions when a SQL type mismatch is detected

D. Performs a lookup directly on a DB2 table

Queries in Metadata Workbench offer an easy way to investigate specific metadata in Metadata Repository. Which of the following statements is correct?

A. In a query, the criteria used for filtering the desired metadata can be based on different asset types

B. Queries can be saved in XML format

C. You can only use existing, predefined queries

D. Queries can report on objects that are not stored in the Metadata Repository

Consider a Parallel Job including a Join Stage with HASH partitioning algorithm followed by an Aggregator stage. Which of the following statements about the Aggregator stage partition algorithm is correct?about the Aggregator stage? partition algorithm is correct?

A. If the Aggregator groups on the same key column(s) as Join, SAME ensures groups of rows stays together

B. If the Aggregator groups on different key column(s) from Join, SAME ensures groups of rows stay together

C. If the Aggregator groups on the same key column(s) as Join, repartitioning must be done in order to have correct results

D. ROUND ROBIN ensures correct results

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.