IBM IBM Certifications P2090-045 Questions & Answers

• Question 41:

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

  A. Continue

  B. Reject

  C. Fail

  D. Output

  Correct Answer: B

• Question 42:

  Which of the following statements is an INVALID description of the Sort Stage Option Create Key Change Column?

  A. Adds a column which holds a value of 0 or 1

  B. 1 indicates the key value has changed

  C. 0 indicates the key value has not changed

  D. Adds a column which holds a value of true/false

  Correct Answer: D

• Question 43:

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

  A. Oracle database

  B. Teradata database

  C. DB2 database

  D. All of the above

  Correct Answer: D

• Question 44:

  Which of the following components need to be up and running in order to use InfoSphere Discovery Studio?

  A. WAS (WebSphere Application Server)

  B. The ASB agent

  C. The database holding the Information Server Metadata Repository

  D. All of the above

  E. None of the above

  Correct Answer: E

• Question 45:

  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

  Correct Answer: C

• Question 46:

  A Job Sequence CANNOT contain __________.

  A. Transformer Stages

  B. Sequencer Stages

  C. Triggers

  D. Job Activity Stages

  Correct Answer: A

• Question 47:

  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

  Correct Answer: B

• Question 48:

  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

  Correct Answer: B

• Question 49:

  Using a Job Sequence, which of the following tasks CANNOT be performed?

  A. Define specific user variables and make them available within a Job Sequence

  B. Drop a database table using a script, then start two different parallel jobs in sequence when a file appears in a specific directory

  C. Run two different parallel jobs in sequence and use job parameters to pass different $APT_CONFIG _FILE values for each of them

  D. Create multiple Exception Handlers stages to handle different types of failures

  Correct Answer: D

• Question 50:

  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

  Correct Answer: B