IBM C2090-421 Online Practice Questions and Exam Preparation

IBM C2090-421 Online Questions & Answers

• Question 51:

  You are setting up a clustered environment. Each node in the cluster has public and private network adapters. The private network uses fast Ethernet. Which two statements are true? (Select two)

  A. Host name alias is not allowed for conductor node.
  B. You must use APT_PM_CONDUCTOR_HOSTNAME variable for optimal environment.
  C. Using the host names on the private network for 'fastname' makes better performance.
  D. The client machines on the public network must use the host name for the engine on the private network to connect.
  B. You must use APT_PM_CONDUCTOR_HOSTNAME variable for optimal environment.
  C. Using the host names on the private network for 'fastname' makes better performance.

• Question 52:

  You have been asked to delete a shared container from the project by your customer. Before you do this you want to make sure it will not impact other objects in the project. How will you ensure that deleting the shared container will not cause a failure when jobs are recompiled?

  A. Select the shared container,Right-click on the Where used command.
  B. Select the shared container,Right-click on the Where used (deep) command.
  C. Select the shared container,Right-click on the Dependencies (deep) command.
  D. Advanced find,set Dependencies Of field equal to the container name,and Check the Option to Include nested results for Dependency searches.
  B. Select the shared container,Right-click on the Where used (deep) command.

• Question 53:

  A job validates credit card numbers with a reference file using a Join stage, which is hash partitioned by card number. Examination of Job Monitor reveals that some partitions process many more rows than others. Assuming adequate hardware resources, which action can be used to improve the performance of the job?

  A. Replace the Join with a Merge stage.
  B. Break the input file into multiple files.
  C. Alter the number of partitions in the $APT_CONFIG_FILE.
  D. Use Round Robin partitioning on the stream and Entire partitioning on the reference.
  C. Alter the number of partitions in the $APT_CONFIG_FILE.

• Question 54:

  Which three methods can be used to import metadata from a Web Services Description Language (WSDL) document? (Choose three.)

  A. XML Table Definitions
  B. Web Services WSDL Definitions
  C. Orchestrate Schema Definitions
  D. Web Service Function Definitions
  E. Job Stage Column tab properties entered using "Load" feature
  A. XML Table Definitions
  B. Web Services WSDL Definitions
  D. Web Service Function Definitions

• Question 55:

  How is Runtime Column Propagation (RCP) enabled for use in DataStage Jobs?

  A. Use the Info Server web console to enable RCP
  B. Set the APT_ENABLE_RCP environment variable to TRUE.
  C. RCP is by default available for all DataStage Projects.
  D. Use RCP definition wizard to initialize RCP for project use.
  E. Use the DataStage Administrator to enable RCP for the project.
  E. Use the DataStage Administrator to enable RCP for the project.

• Question 56:

  The Teradata Enterprise stage uses a distributed FastExport to access data. What is a limitation to distributed FastExport?

  A. Multiple-AMP requests are allowed.
  B. The use of the USING modifier is allowed.
  C. Non-data access (e.g.,pseudo-tables like DATE or USER) is allowed.
  D. Aggregates and most arithmetic operators in the SELECT statement are allowed.
  A. Multiple-AMP requests are allowed.

• Question 57:

  Which two statements are correct when referring to an Aggregator Stage? (Choose two.)

  A. Use Sort method for a limited number of distinct key values
  B. Use Hash method for a limited number of distinct key values
  C. Use Sort method with a large number of distinct key-column values
  D. Use Hash method with a large number ofdistinct key-column values
  B. Use Hash method for a limited number of distinct key values
  C. Use Sort method with a large number of distinct key-column values

• Question 58:

  How must the input data set be organized for input into the join stage? (Choose two.)

  A. Unsorted
  B. Key partitioned
  C. Hash partitioned
  D. Entire partitioned
  E. Sorted in ascending order
  B. Key partitioned
  E. Sorted in ascending order

• Question 59:

  You have a job that reads in Sequential File followed by a Transformer stage. When you run this job, which partitioning method will be used by default?

  A. Hash
  B. Same
  C. Random
  D. Round Robin
  D. Round Robin

• Question 60:

  Which two of the following derivations for an output column named OutCol can be used to generate a unique sequence of integers across multiple partitions?

  A. @INROWNUM
  B. NextSurrogateKey()
  C. 1 + @NUMPARTITIONS * @INROWNUM
  D. @PARTITIONNUM + @NUMPARTITIONS
  D. @PARTITIONNUM + @NUMPARTITIONS