IBM InfoSphere Information Server for Data Integration Fundamentals Technical Mastery Test v1

Question 1

A file contains a very large number of records with unique groups based on a key. Which Grouping Method would you prefer to use in the Aggregate Stage for aggregating the data?

A. Round Robin

B. Hash

C. Sort

D. Random

Correct Answer: C

Question 2

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. II, III, IV

B. I, II, IV

C. I, II, III

D. I, II, III, IV

Correct Answer: C

Question 3

What capability does Information Services Director provide?

A. Information Services Director is the tool used to consume web services

B. Information Services Director is the tool used within Information Server to create and to deploy an application containing one or more services

C. Information Services Director is the tool used to create a service; the deployment of the service is performed by 3rdparty tools

D. Information Services Director is the tool used to schedule DataStage jobs and run job sequences

Correct Answer: B

Question 4

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

A. Degree of parallelism

B. Scratch disk dedicated for sorting

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

D. Compilation options for DataStage jobs

Correct Answer: D

Question 5

Which of the following is NOT an option for the Reject Mode setting of a Sequential File Stage?

A. Reject

B. Continue

C. Output

D. Fail

Correct Answer: A

Question 6

Which description below about the Sort Stage is invalid?

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

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

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

D. Sort Stage uses temporary disk space while performing sort

Correct Answer: C

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

Latest Update

Useful Links

Contact Us