IBM C2090-303 Online Practice Questions and Exam Preparation

IBM C2090-303 Online Questions & Answers

• Question 51:

  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. Convert
  E. Continue
  B. Fail
  E. Continue

• Question 52:

  Which statement is correct about the Data Rules stage?

  A. The Data Rules stage works with rule definitions only; not executable rules.
  B. As a best practice, you should create and publish new rules from the Data Rules stage.
  C. If you have Rule Creator role in InfoSphere Information Analyzer, you can create and publish rule definitions and rule set definitions directly from the stage itself.
  D. When a job that uses the Data Rules stage runs, the output of the stage is passed to the downstream stages and results are stored in the Analysis Results database (IADB).
  A. The Data Rules stage works with rule definitions only; not executable rules.

• Question 53:

  In your ETL application design you have found several areas of common processing requirements in the mapping specifications. These common logic areas found include: code validation lookups and name formatting. The common logic areas have the same logic, but the jobs using them would have different column metadata. Choose the action that gives you the best reusability design to effectively implement these common logic areas in your ETL application?

  A. Create parallel routines for each of the common logic areas and for each of the unique column metadata formats.
  B. Create separate jobs for each layout and choose the appropriate job to run within a job sequencer.
  C. Create parallel shared containers and define columns combining all data formats.
  D. Create parallel shared containers with Runtime Column Propagation (RCP) ON and define only necessary common columns needed for the logic.
  D. Create parallel shared containers with Runtime Column Propagation (RCP) ON and define only necessary common columns needed for the logic.

• Question 54:

  In the exhibit, a Funnel stage has two input links. Input 1 (Seq_File) comes from a Sequential File stage with "Readers per Node" set to "2". Input 2 (Dataset) comes from a dataset created with 3 partitions. In the Funnel stage, the funnel type is set to "Sequence".

  

  The parallel configuration file contains 4 nodes.

  How many instances of the Funnel stage run in parallel?

  A. 1
  B. 2
  C. 4
  D. 6
  C. 4

• Question 55:

  Which of following 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. Buffering settings
  D. Table definitions
  E. Error log directory
  A. Partitioning
  C. Buffering settings

• Question 56:

  A job design consists of an input Row Generator stage, a Sort stage, followed by a Transformer stage and an output Data Set stage. The job is run on an SMP machine with a configuration file defined with four nodes. The $APT_DISABLE_COMBINATION variable is set to True.

  How many player processes will this job generate?

  B. 16
  C. 13
  D. 16
  C. 13

• Question 57:

  A job design reads from a complex flat file, performs some transformations on the data, and outputs the results to a ISD output stage. How can the parameter values can be passed to this job at run-time?

  A. Include the parameter values in the data.
  B. Change the properties of the information provider.
  C. Pass the parameter values at the time of the service request.
  D. Execute a DSSetParam with the values at job execution time.
  C. Pass the parameter values at the time of the service request.

• Question 58:

  Which partitioning method requires a key?

  A. Same
  B. Modulus
  C. Sort Merge
  D. Round Robin
  B. Modulus

• Question 59:

  When you run a parallel job, any error messages and warnings are written to the job log and can be viewed from the Director client. What message handler level is available?

  A. stage level
  B. record level
  C. project level
  D. parameter level
  C. project level

• Question 60:

  You are using the Complex Flat File stage as a source in your job.

  What are two types of data specifically supported by the Complex Flat File stage for your job? (Choose two.)

  A. XML files.
  B. Mainframe data sets with VSAM files.
  C. Mainframe data files with DB2 tables.
  D. Data from files that contain Hadoop record types.
  E. Data from flat files that contain multiple record types.
  B. Mainframe data sets with VSAM files.
  E. Data from flat files that contain multiple record types.