IBM C2090-421 Online Practice Questions and Exam Preparation

IBM C2090-421 Online Questions & Answers

• Question 151:

  Which three actions can improve sort performance in a DataStage job? (Choose three.)

  A. Specify only the key columns which are necessary.
  B. Minimize the number of sorts used within a job flow.
  C. Adjust the "Restrict Memory Usage" option in the Sort stage.
  D. Run the job sequentially so that only one sort process is invoked.
  E. Use the stable-sort option to avoid the random ordering of non-key data.
  A. Specify only the key columns which are necessary.
  B. Minimize the number of sorts used within a job flow.
  C. Adjust the "Restrict Memory Usage" option in the Sort stage.

• Question 152:

  Which two statements are true for named node pools? (Select two)

  A. Using appropriately named node pools is only available in clustered environments.
  B. Using appropriately named node pools allow the separation of buffering from sorting disks.
  C. Using appropriately named node pools force DataStage jobs to use named pipes between stages.
  D. Named node pools are required for DataStage jobs to scale across multiple machines on a grid or cluster.
  E. Using appropriately named node pool constraints limit stages to be executed only on the nodes defined in the node pools.
  B. Using appropriately named node pools allow the separation of buffering from sorting disks.
  E. Using appropriately named node pool constraints limit stages to be executed only on the nodes defined in the node pools.

• Question 153:

  Which statement is true about the Web Services Pack?

  A. Web Services Pack generates a WSDL.
  B. Web Services Pack makes a service request using SOAP.
  C. Web Services Pack communicates by Enterprise Java Beans.
  D. Web Services Pack is configured from within the Information Services Director application.
  B. Web Services Pack makes a service request using SOAP.

• Question 154:

  You are given a job requirement that requires calculations based on the latest currency exchange rate. You decide to invoke a Web service to obtain the latest exchange rate.

  What are two ways that you can perform a Web service invocation in a DataStage job to obtain the latest exchange rate? (Select two)

  A. Use WISD Input stage.
  B. Use Web Services Transformer stage.
  C. Use Web Services Client stage as a lookup.
  D. Call a Web Service using a DSRoutine inside the Parallel Transformer stage.
  B. Use Web Services Transformer stage.
  C. Use Web Services Client stage as a lookup.

• Question 155:

  Which three data types can the ODBC Enterprise stage handle? (Choose three.)

  A. SQL_CLOB
  B. SQL_BIGINT
  C. SQL_TIMESTAMP
  D. SQL_VARBINARY
  E. SQL_SMALLDATETIME
  B. SQL_BIGINT
  C. SQL_TIMESTAMP
  D. SQL_VARBINARY

• Question 156:

  Your customer is using Source Code Control Integration for Information server and have tagged artifacts for version 1. You must create a deployment package from the version 1.

  Before you create the package you will have to ensure the project is up to date with version 1.

  What two things must you do to update the meta-data repository with the artifacts tagged as version 1? (Select two)

  A. Right-click the asset and click the Deploy command.
  B. Right-click the asset and click the Team Import command.
  C. Right-click the asset and click Replace From Source Control Workspace.
  D. Right-click the asset and click the Team command to update the Source Control Workspace with the asset.
  B. Right-click the asset and click the Team Import command.
  D. Right-click the asset and click the Team command to update the Source Control Workspace with the asset.

• Question 157:

  When you configure a domain for source code integration a source control workspace is created. What are two reasons for the source control workspace? (Choose two.)

  A. default directory for istool exports.
  B. directory for deployment package files
  C. local transfer area for assets being submitted to the source control system
  D. provides a place to store the archive created by IS source code control integration
  C. local transfer area for assets being submitted to the source control system
  D. provides a place to store the archive created by IS source code control integration

• Question 158:

  You are asked to identify the jobs and shared containers that use the ADDRESS column. The Size has changed from 50 to 120 characters in the source system so the jobs must be updated with the new size. What feature of the Designer will locate where a column is used in a DataStage project?

  A. Open the Table Definition properties,Select the ADDRESS column,then right click and select Find where used.
  B. Select a Table Definition,then right click and choose Find where column is used. Select the column to search for from the list.
  C. From Designer Tools open an Advanced Find dialog. Select Columns from the Type list and enter the column name in the Name To Find field.
  D. From Designer Tools,open an Advanced Find dialog. Enter the column name in the Name to find field. Select Jobs and Shared Containers from the Type to find list.
  C. From Designer Tools open an Advanced Find dialog. Select Columns from the Type list and enter the column name in the Name To Find field.

• Question 159:

  What are two ways to specify a stylesheet in an XML input stage? (Choose two.)

  A. On the output link columns properties tab,type the stylesheet in the XLST box.
  B. On the output link advanced properties tab,type the stylesheet in the Stylesheet box.
  C. On the output link columns properties tab,identify an input column that contains the stylesheet URL.
  D. On the output link advanced properties tab,load the content or path of a stylesheet that is stored on the engine tier host.
  B. On the output link advanced properties tab,type the stylesheet in the Stylesheet box.
  D. On the output link advanced properties tab,load the content or path of a stylesheet that is stored on the engine tier host.

• Question 160:

  Which three environment variables are valid job score environment variables? (Select three)

  A. APT_LOW_SCORE
  B. APT_DUMP_SCORE
  C. APT_THIN_SCORE
  D. APT_SAVE_SCORE
  E. APT JAVA SCORE
  A. APT_LOW_SCORE
  B. APT_DUMP_SCORE
  D. APT_SAVE_SCORE