IBM C2090-303 Online Practice Questions and Exam Preparation

IBM C2090-303 Online Questions & Answers

• Question 31:

  Each row contains the CustID, ProductID, ProductType and TotalAmount columns. You want to retain the record with the largest value in the TotalAmount column for each CustID and ProductType using a RemoveDuplicates stage.

  How can this be accomplished?

  A. Hash-partition on CustID. Sort on CustID, ProductType and TotalAmount.
  B. Hash-partition on TotalAmount. Sort on CustID, ProductType and TotalAmount.
  C. Hash-partition on ProductType. Sort on ProductType, CustID and TotalAmount.
  D. Hash-partition on CustID, ProductType and TotalAmount. Sort on CustID, ProductType and TotalAmount.
  A. Hash-partition on CustID. Sort on CustID, ProductType and TotalAmount.

• Question 32:

  Which two pieces of information are required to be specified for the input link on a Netezza Connector stage? (Choose two.)

  A. Partitioning
  B. Server name
  C. Table definitions
  D. Buffering settings
  E. Error log directory
  A. Partitioning
  D. Buffering settings

• Question 33:

  The ODBC stage can handle which two SQL Server data types? (Choose two.)

  A. Date
  B. Time
  C. GUID
  D. Datetime
  E. SmallDateTime
  C. GUID
  E. SmallDateTime

• Question 34:

  You are asked to optimize the fork join job design in the exhibit. This job uses the sort aggregator and a left outer join on the ZIP code column. Currently all partitioning is set to "Auto" and automatic sort insertion is allowed.

  

  Which change will reduce the cost of partitioning that occurs in this job?

  A. Use Entire partitioning on the input links to the Aggregator and Join stages.
  B. Hash partition and sort on ZIP code column on the input links to the Aggregator and Join stages.
  C. Hash partition and sort on ZIP code column prior to the Copy stage and use entire partitioning on the Aggregator and Join stages.
  D. Hash partition and sort on ZIP code column prior to the Copy stage, and use same partitioning on the Aggregator and Join stages.
  D. Hash partition and sort on ZIP code column prior to the Copy stage, and use same partitioning on the Aggregator and Join stages.

• Question 35:

  Configuring the weighting column of an Aggregator stage affects which two options. (Choose two.)

  A. Sum
  B. Maximum Value
  C. Average of Weights
  D. Coefficient of Variation
  E. Uncorrected Sum of Squares
  A. Sum
  E. Uncorrected Sum of Squares

• Question 36:

  You are assigned to correct a job from another developer. The job contains 20 stages sourcing data from two Data Sets and many sequential files. The annotation in the job indicates who wrote the job and when, not the objective of the job. All link and stage names use the default names.

  One of the output columns has an incorrect value which should have been obtained using a lookup.

  What could the original developer have done to make this task easier for maintenance purposes?

  A. Name all stage and links the same.
  B. Name all stages and links based on what they do.
  C. Indicate all stage names within the job annotation.
  D. Name all stage and links with column names and ideas.
  B. Name all stages and links based on what they do.

• Question 37:

  What are two advantages of using Runtime Column Propagation (RCP)? (Choose two.)

  A. RCP forces a developer to define all columns explicitly.
  B. Only columns used in the data flow need to be defined.
  C. Sequential files don't require schema files when using RCP.
  D. Only columns that are defined as VarChar need RCP enabled.
  E. Columns not specifically used in the flow are propagated as if they were.
  B. Only columns used in the data flow need to be defined.
  E. Columns not specifically used in the flow are propagated as if they were.

• Question 38:

  What role must a user have to delete shared metadata assets from the repository?

  A. DataStage Administrator
  B. Business Glossary Administrator
  C. Common Metadata Administrator
  D. Information Analyzer Administrator
  C. Common Metadata Administrator

• Question 39:

  Click the Exhibit button.

  

  The job in the exhibit runs to successful completion with no warnings. However, a validation test identifies that the CUSTOMER_MASTER table is empty. You suspect the cause to be related to the NEW_CUSTOMERS table or a defect in the job. Examining runtime metadata may help you track down the problem.

  Which two product features will help you isolate the cause of the problem? (Choose two.)

  A. Director job monitor tool.
  B. Designer Performance Analyzer tool.
  C. Designer "Show performance statistics" option.
  D. The view data button in the target Connector stage.
  E. InfoSphere Metadata Asset Manager (IMAM) operational metadata reports.
  A. Director job monitor tool.
  C. Designer "Show performance statistics" option.

• Question 40:

  When using a Sequential File stage as a source what are the two reject mode property options? (Choose two.)

  A. Set
  B. Fail
  C. Save
  D. Continue
  E. Convert
  B. Fail
  D. Continue