IBM C2090-303 Online Practice Questions and Exam Preparation

IBM C2090-303 Online Questions & Answers

• Question 121:

  What two binding types are supported by Information Services Director (ISD) for a parallel job that is designed to be used as a service? (Choose two.)

  A. EJB
  B. SQL
  C. HDFS
  D. SOAP
  E. STREAMS
  A. EJB
  D. SOAP

• Question 122:

  When using the loop functionality in a transformer, which statement is true regarding Transformer processing.

  A. Stage variables can be referenced in loop conditions.
  B. Stage variables can be executed after loop variable expressions.
  C. Loop variable expressions are executed before input link column expressions.
  D. Output links can be excluded from being associated with a True loop condition.
  A. Stage variables can be referenced in loop conditions.

• Question 123:

  You are responsible for deploying objects into your customers production environment. To ensure the stability of the production system the customer does not permit compilers on production machines. They have also protected the project and only development machines have the required compiler.

  What option will enable jobs with a parallel transformer to execute in the customers production machines?

  A. Add $APT_COMPILE_OPT=-portable
  B. Set $APT_COPY_TRANSFORM_OPERATOR
  C. Use protected projects in the production environment.
  D. Create a package with Information Server Manager and select the option to include executables.
  D. Create a package with Information Server Manager and select the option to include executables.

• Question 124:

  Which method is used to specify when to stop a job because of too many rejected rows with an ODBC Connector?

  A. In the Abort when field, select Max
  B. In the Abort when field, select Rows
  C. In the Abort when field, select Count
  D. In the Abort when field, select Amount
  B. In the Abort when field, select Rows

• Question 125:

  Which Oracle data type conversion is correct?

  A. Oracle data type RAW converts to RAW in Oracle Connector stage.
  B. Oracle data type NUMBER(6,0) converts to INT32 in Oracle Connector stage.
  C. Oracle data type NUMBER(15,0) converts to INT32 in Oracle Connector stage.
  D. Oracle data type NUMBER converts to DECIMAL(38,0) in Oracle Connector stage.
  B. Oracle data type NUMBER(6,0) converts to INT32 in Oracle Connector stage.

• Question 126:

  The effective use of naming conventions means that objects need to be spaced appropriately on the DataStage Designer canvas. For stages with multiple links,expanding the icon border can significantly improve readability. This approach takes extra effort at first, so a pattern of work needs to be identified and adopted to help development.

  Which feature of Designer can improve development speed?

  A. Palette Layout
  B. Repository Layout
  C. Snap to Grid Feature
  D. Show Performance Statistics Feature
  C. Snap to Grid Feature

• Question 127:

  Identify the two statements that are true about the functionality of the XML Pack 3.0. (Choose two.)

  A. XML Stages are Plug-in stages.
  B. XML Stage can be found in the Database folder on the palette.
  C. Uses a unique custom GUI interface called the Assembly Editor.
  D. It includes the XML Input, XML Output, and XML Transformer stages.
  E. A single XML Stage, which can be used as a source, target, or transformation.
  C. Uses a unique custom GUI interface called the Assembly Editor.
  E. A single XML Stage, which can be used as a source, target, or transformation.

• Question 128:

  Which two data repositories can be used for user authentication within the Information Server Suite? (Choose two.)

  A. IIS Web Console
  B. IBM Metadata repository
  C. Standalone LDAP registry
  D. Operations Console database
  E. IBM Information Server user directory
  C. Standalone LDAP registry
  E. IBM Information Server user directory

• Question 129:

  Two new columns have been deleted from a sequential file that a number of DataStage jobs write to. You have imported a table definition for the changed file. How can you determine what jobs might be affected by this change?

  A. Select the new table definition, right-click, then click on the Where used command.
  B. Select the original table definition, right-click, then click on the Where used command.
  C. Select the original table definition, right-click, then click on the Find dependencies command.
  D. Select the new table definition, right-click, click on the Compare against command, then select original table definition.
  B. Select the original table definition, right-click, then click on the Where used command.

• Question 130:

  Identify the two delimiter areas available to be configured in the Sequential File format tab properties? (Choose two.)

  A. File delimiter
  B. Null delimiter
  C. Final delimiter
  D. Field delimiter
  E. End of group delimiter
  C. Final delimiter
  D. Field delimiter