IBM C2090-421 Online Practice Questions and Exam Preparation

IBM C2090-421 Online Questions & Answers

• Question 71:

  Click the Exhibit button.

  

  These three Sequential Files shown in the exhibit need to be joined. Join_1 is on Columns CustID and OrderID. Join_2 is on CustID and LocationID. What is the most efficient hash partitioning strategy for each link?

  A. For LinkA Hash Partition on CustID;For LinkB Hash Partition on CustID;For LinkC Same Partition;For LinkD Hash Partition on CustID.
  B. For LinkA Hash Partition on OrderID and CustID;For LinkB Hash Partition on OrderID and CustID;For LinkC Hash Partition on LocationID and CustID;For LinkD Hash Partition on LocationID and CustID.
  C. For LinkA Hash Partition on CustID and OrderID;For LinkB Hash Partition on CustID and OrderID;For LinkC Hash Partition on CustID and LocationID;For LinkD Hash Partition on CustID and LocationID.
  D. For LinkA Hash Partition on CustID,OrderID and LocationID;For LinkB Hash Partition on CustID,OrderID and LocationID;For LinkC Hash Partition on CustID,OrderID and LocationID;For LinkD Hash Partition on CustID,OrderID and LocationID.
  A. For LinkA Hash Partition on CustID;For LinkB Hash Partition on CustID;For LinkC Same Partition;For LinkD Hash Partition on CustID.

• Question 72:

  What is the correct restructure stage to extract data from four input columns (three of which carry vectors) and output them into two columns with one vectors in a subrecord and the non-vector carrying column being passed through the stage?

  A. Column Export Stage
  B. Column Import Stage
  C. Split Subrecord Stage
  D. Make Subrecord Stage
  B. Column Import Stage

• Question 73:

  How does the Complex Flat File stage (CFF) support the use of "OCCURS DEPENDING ON" clause?

  A. CFF does not support this clause.
  B. The related elements are output as arrays.
  C. The related elements are output as subrecords.
  D. The related elements are output as denormalized fields.
  B. The related elements are output as arrays.

• Question 74:

  External data conversions fall in two major types - automatic and manual. What are the three automatic conversions? (Select three)

  A. SAS data
  B. Relational data
  C. Flat Text files
  D. Modify operator
  E. Sequential File stage
  A. SAS data
  B. Relational data
  C. Flat Text files

• Question 75:

  Which Information Server client application must be used to manage project-level roles for DataStage?

  A. Director client
  B. Designer client
  C. WebSphere Information Services Director
  D. Web console for IBM Information Server
  D. Web console for IBM Information Server

• Question 76:

  Using a DB2 for z/OS source database, a 200 million row source table with 30 million distinct values must be aggregated to calculate the average value of two column attributes. What would provide optimal performance while satisfying the business requirements?

  A. Select all source rows using a DB2 API stage. Aggregate using a Sort Aggregator.
  B. Using custom SQL with AVG functions and a DISTINCT clause,select all source rows using a DB2 Enterprise stage.
  C. Using custom SQL with an ORDER BY clause based on key columns,select all source rows using the DB2 API stage. Aggregate using a Hash Aggregator.
  D. Select all source rows using a DB2 Enterprise stage,use a parallel Sort stage with the specified sort keys,calculate the average values using a parallel Transformer with stage variables and output link constraints.
  A. Select all source rows using a DB2 API stage. Aggregate using a Sort Aggregator.

• Question 77:

  What three types of links are supported by the Lookup Stage? (Select three)

  A. A reference link
  B. A single input link
  C. A single output link
  D. Multiple Input Links
  E. Multiple reject links
  A. A reference link
  B. A single input link
  C. A single output link

• Question 78:

  What would help debug the run-time environment?

  A. $APT_VERBOSE
  B. $OSH_PRINT_SCHEMAS
  C. Check the message filters for the job.
  D. View detailed runtime stats through Job monitor in Director Client.
  B. $OSH_PRINT_SCHEMAS

• Question 79:

  What stage allows for more than one reject link?

  A. Peek stage
  B. Join stage
  C. Merge stage
  D. Lookup stage
  E. Funnel stage
  C. Merge stage

• Question 80:

  In the job fragment shown in the exhibit, there are two Sort stages: the first (Sort1) sorts the data by state, the second (Sort2) sorts the data by state and area, No repartitioning occurs between the stages. You have been asked to reduce the number of sorts to improve the performance of the job.

  

  Which two ways might be used to accomplish this without changing how the job functions? (Select two)

  A. Remove the second Sort stage. Add area as an additional sort key.
  B. Remove the first Sort stage. Retain the existing sort keys in the second Sort stage.
  C. In the second Sort stage change the Sort Mode property of the area column to "Don't sort, previously sorted.".
  D. In the second Sort stage change the Sort Mode property of the state column to "Don't sort, previously sorted.".
  B. Remove the first Sort stage. Retain the existing sort keys in the second Sort stage.
  C. In the second Sort stage change the Sort Mode property of the area column to "Don't sort, previously sorted.".