IBM C2090-421 Online Practice Questions and Exam Preparation

IBM C2090-421 Online Questions & Answers

• Question 101:

  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 two levels of message handlers are there? (Choose two.)

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

• Question 102:

  You need to find the differences between the jobs in the Test project and theit older version in the Production project. You discover that the Production project is on another domain. What feature would find the differences in a job that is in a project on a different domain?

  A. Cross Domain Compare
  B. Cross Project Compare
  C. DataStage Version Control
  D. Export from the other domain and import into a project in the same domain as the one you are working in.
  B. Cross Project Compare

• Question 103:

  Refer to the exhibit.

  

  You are responsible for improving performance for a given job. From reviewing the job dump score, you notice that many tsort operators are inserted. Join_1 is on columns "account", "po_date" and "hdr_number". Join_2 is based on "account", "hdr_number", "paid_date".

  Which two actions will help you improve the performance without changing the business logic? (Select two)

  A. Insert sort stage between Join_1 and Join_2, subsort ("Don't sort, previously sorted") on "account", sort "hdr_number" and "paid_date".
  B. Partition on "account" and "hdr_number" for all joins. Change Join_1 to join on "account", "hdr_number" and "po_date". Add Add $APT_SORTJNSERTION_CHECK_ONLY to job parameter list and set it to "True".
  C. Partition on account and hdr_numberfor all joins. Change Join_1 to join on "account", "hdr_number" and "po_date". Insert Sort between Join_1 and Join_2 and subsort ("Don't sort previously sorted") on "account".
  D. Partition on account and hdrnumber for all joins. Change Join_1 to join on "account", "hdrnumber" and "po_date". Insert Sort between Join_1 and Join_2 and subsort ("Don't sort previously sorted") on "account" and "hdr_number" and sort on "paid_date".
  B. Partition on "account" and "hdr_number" for all joins. Change Join_1 to join on "account", "hdr_number" and "po_date". Add Add $APT_SORTJNSERTION_CHECK_ONLY to job parameter list and set it to "True".
  D. Partition on account and hdrnumber for all joins. Change Join_1 to join on "account", "hdrnumber" and "po_date". Insert Sort between Join_1 and Join_2 and subsort ("Don't sort previously sorted") on "account" and "hdr_number" and sort on "paid_date".

• Question 104:

  You are setting up user roles on Information Server Web console. Which two roles are required to allow a user to edit DataStage jobs? (Select two)

  A. Suite User role
  B. DataStage Developer
  C. DataStagesuper operator
  D. Information Analyzer Data Administrator
  B. DataStage Developer
  C. DataStagesuper operator

• Question 105:

  Your job uses the MQ connector stage to read messages from an MQ queue. The job should retrieve the message ID into the MessageID field and parse the payload into two fields: Name is to get the first ten characters, Description is to get the remaining characters.

  What will accomplish this?

  A. First column is MessageID; select the WSMQ.MSGID data element for the Message ID field; column is Description as VarBinary 200; third column is Name as Binary 10.
  B. First column is MessageID; select the WSMQ.MSGID data element for the Message ID field; second column is Name as Binary 10; third column is Description as VarBinary 200.
  C. First column is MessageID as Binary 24; second column is Name as Binary 10; select WSMG. MSPAYLOAD data element; third column is Description as VarBinary 200; select WSMG.MSPAYLOAD data element.
  D. First column is MessageID; select the WSMQ.MSGID data element for the Message ID field; second column is Name; select WSMG.MSPAYLOAD data element; third column is Description; select WSMG.MSPAYLOAD data element.
  A. First column is MessageID; select the WSMQ.MSGID data element for the Message ID field; column is Description as VarBinary 200; third column is Name as Binary 10.
  C. First column is MessageID as Binary 24; second column is Name as Binary 10; select WSMG. MSPAYLOAD data element; third column is Description as VarBinary 200; select WSMG.MSPAYLOAD data element.

• Question 106:

  A dataset was created earlier with one partition, with the Preserve Partitioning flag set. A subsequent job using a 2-node configuration file reads from that dataset, passing data to a Transformer stage with "Same" partitioning.

  Which two statements are true? (Select two)

  A. The DataStage job will abort.
  B. DataStage will repartition the data and run one instance of the Transformer stage.
  C. Inserting a Sort stage prior to the Transformer stage will force its parallel execution.
  D. Setting the Preserve Partitioning flag to "Set" will run one instance of the Transformer stage.
  E. Setting the Preserve Partitioning flag to "Clear" will generate two instances of the Transformer stage.
  B. DataStage will repartition the data and run one instance of the Transformer stage.
  E. Setting the Preserve Partitioning flag to "Clear" will generate two instances of the Transformer stage.

• Question 107:

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

  A. the IBM Metadata repository
  B. the local operating system directory
  C. the IBM Information Server user directory
  D. the IBM Suite User Configuration file specified within the dsenv file
  B. the local operating system directory
  C. the IBM Information Server user directory

• Question 108:

  Which three environment variables are used for reporting on DataStage jobs? (Select three)

  A. $APT_DISABLE_ROOT_FORKJOIN
  B. $APT_DUMP_SCORE
  C. $OSH_PRINT_SCHEMAS
  D. $APT_PM_PLAYER_MEMORY
  E. $APT_PM_STARTUP_CONCURRENCY
  B. $APT_DUMP_SCORE
  C. $OSH_PRINT_SCHEMAS
  D. $APT_PM_PLAYER_MEMORY

• Question 109:

  You have a 3TB dataset hash-partitioned on CustID in a clustered environment. You need to join this dataset with 1GB of reference data on OrderID. Which technique is most appropriate?

  A. Use Lookup stage,select auto partitioning for both link.
  B. Use Join stage,hash-partition and sort both link on OrderID.
  C. Use Lookup stage,select auto partitioning for the stream link and entire partitioning for the reference link.
  D. Use Lookup stage,select auto partitioning for the stream link and hash-partition the reference link on CustID.
  C. Use Lookup stage,select auto partitioning for the stream link and entire partitioning for the reference link.

• Question 110:

  A job design consists of an input sequential file, a Modify stage, followed by a Filter stage and an output SequentialFile stage. The job is run on an SMP machine with a configuration file defined with three nodes. No environment variables were set for the job. How many osh processes will this job create?

  A. 8
  B. 9
  C. 11
  D. 16
  B. 9