IBM IBM Certifications P2090-045 Questions & Answers

• Question 31:

  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, IV

  B. II, III, IV

  C. I, II, III

  D. I, III, IV

  Correct Answer: D

• Question 32:

  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 to create a service; the deployment of the service is performed by 3rdparty tools

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

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

  Correct Answer: C

• Question 33:

  Which of the following is NOT possible with a Transformer Stage?

  A. Generate multiple output records for each single record

  B. Create and compile a custom function to be used in output link derivations

  C. Define variables that can be referenced only within the Transformer Stage

  D. Use system variables and job parameters within derivations

  Correct Answer: B

• Question 34:

  Which Stage requires identical metadata in order to combine data?

  A. Lookup Stage

  B. Funnel Stage

  C. Join Stage

  D. Transformer Stage

  Correct Answer: B

• Question 35:

  Which of the following statements about partitioning algorithms is correct?

  A. MODULUS and HASH ensure balanced data volumes in all the partitions

  B. For the Lookup reference stage, DataStage always uses the MODULUS method

  C. SAME partitioning method is the fastest algorithm because it does not require additional processing

  D. The grouping methods available in the Aggregator stage are MODULUS and HASH

  Correct Answer: C

• Question 36:

  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

  Correct Answer: E

• Question 37:

  Which of the following statements about Blueprint Director is incorrect?

  A. Blueprint Director will display the time needed to perform individual tasks

  B. You can browse and search Information Server metadata assets

  C. You can create new blueprints from standard reference architecture templates

  D. Reference architectures contain detailed method guidance for required activities

  Correct Answer: A

• Question 38:

  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

  Correct Answer: D

• Question 39:

  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

  Correct Answer: D

• Question 40:

  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

  Correct Answer: D