IBM IBM Certifications P2090-045 Questions & Answers

• Question 21:

  Which of the following statements about InfoSphere Data Architect is correct?

  A. You CANNOT create a logical model from a physical model

  B. InfoSphere Data Architect can deploy physical data models directly to the database management system

  C. Reverse engineering data models only works for DB2 databases

  D. InfoSphere Data Architect is installed using the Information Server installation wizard

  Correct Answer: B

• Question 22:

  Which of the following stages is NOT a file data access stage?

  A. Sequential File Stage

  B. Transformer Stage

  C. Dataset Stage

  D. FileSet Stage

  Correct Answer: B

• Question 23:

  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 green arrow associated to the element

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

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

  Correct Answer: C

• Question 24:

  With DataStage Designer you CANNOT __________.

  A. Design jobs that extract, integrate, and transform the data for data warehouse

  B. Create and reuse Table Definitions

  C. Compile and execute the DataStage jobs

  D. Configure the deployment model

  Correct Answer: D

• Question 25:

  Which of the following statements about the Lookup Stage is correct?

  A. It is a Real-Time Stage

  B. It combines data horizontally

  C. It can have only one input link defined

  D. The default partition method for Lookup is Hash

  Correct Answer: B

• Question 26:

  Which of the following statements about Collecting methods is correct?

  A. ROUND ROBIN is the fastest algorithm

  B. SORT MERGE never performs data sorting

  C. ORDERED ensures the collected data stream being sorted

  D. AUTO chooses the best method between ROUND ROBIN, SORT MERGE, and ORDERED

  Correct Answer: B

• Question 27:

  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. Hash

  B. Sort

  C. Random

  D. Round Robin

  Correct Answer: B

• Question 28:

  Which type of jobs can be compiled into Orchestrate Scripting Language (OSH)?

  A. Server jobs

  B. Parallel jobs

  C. Sequence Jobs

  D. Mainframe Jobs

  Correct Answer: B

• Question 29:

  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

  Correct Answer: C

• Question 30:

  Which tool below can be used to assign permissions to users for each DataStage project?

  A. Information Server Web Console

  B. DataStage Administrator

  C. DataStage Director

  D. DataStage Designer

  Correct Answer: B