IBM InfoSphere Information Server for Data Integration Fundamentals Technical Mastery Test v1 (P2090-045) Free Practice Test

Question 1

Which description below about the Sort Stage is invalid?

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

B. Sort Stage uses temporary disk space while performing sort

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

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

Correct Answer: C

Question 2

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 reject link, 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 or more reject links, one otherwise link, one or more output links

Correct Answer: C

Question 3

A DataStage job can be executed from_______________

A. DataStage Designer or Director client.

B. DataStage Director client only

C. DataStage Administrator client only

D. DataStage Administrator or Director client

Correct Answer: A

Question 4

In Blueprint Director, how do you easily recognize that an element contains a subdiagram?

A. There is a little ?icon associated with the elementThere is a little ??icon associated with the element

B. There is a little ??icon associated with the element

C. Double clicking the element is the only way to find out

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

Correct Answer: B

Question 5

With Information Services Director, you can deploy services that package the following information provider types: I.DataStage and QualityStage jobs II.SOAP over HTTP III.DB2 and Oracle SQL statements IV.Federation Server queries

A. I, II, III

B. I, II, IV

C. I, III, IV

D. II, III, IV

Correct Answer: C

Question 6

The ODBC Connector Stage can be used to connect to __________.

A. All of the above

B. Oracle database

C. Teradata database

D. DB2 database

Correct Answer: A

Welcome to TestSimulate

IBM InfoSphere Information Server for Data Integration Fundamentals Technical Mastery Test v1 (P2090-045) Free Practice Test