IBM C2090-421 Online Practice Questions and Exam Preparation

IBM C2090-421 Online Questions & Answers

• Question 11:

  How are Shared Table definitions created from the DataStage Client?

  A. This cannot be done from the DataStage Client
  B. Using the "Save" button on the "Table Properties" panel
  C. Using the "Save" button on the columns tab on the Stage/Link editor
  D. Using the "Shared Table Creation Wizard" from the DataStage Client.
  E. No need to,DataStage table definitions are automatically saved as shared metadata.
  D. Using the "Shared Table Creation Wizard" from the DataStage Client.

• Question 12:

  What are the three features of Information Server that allow you to deploy DataStage objects? (Select three)

  A. istool
  B. dscc.exe
  C. $APT_COPY_TRANSFORMER
  D. Designer Client Export
  E. Information Server Manager
  B. dscc.exe
  E. Information Server Manager

• Question 13:

  What conditions are necessary for a master record and an update record to merge?

  A. all of the columns in the input record match the columns in the update record
  B. some of the columns in the input record match the columns in the update record
  C. none of the columns in the input record match the columns in the update record
  D. both records have the same values for the merge key column(s) that you specify
  D. both records have the same values for the merge key column(s) that you specify

• Question 14:

  Which job design technique can be used to give unique names to sequential output files that are used in multi-instance jobs?

  A. Use parameters to identify file names.
  B. Generate unique file names by using a macro.
  C. Use DSJobInvocationID to generate a unique filename.
  D. Use a Transformer stage variable to generate the name.
  A. Use parameters to identify file names.

• Question 15:

  Which three statements are true about characteristics of shared containers? (Select three)

  A. Containers are used to execute jobs.
  B. Containers are a group of stages and links.
  C. Containers allow you to implement recurring logic.
  D. Containers allow multiple users to access a single job.
  E. Containers allow you to provide pre-configured job design logic.
  A. Containers are used to execute jobs.
  B. Containers are a group of stages and links.
  C. Containers allow you to implement recurring logic.

• Question 16:

  What two data sources support direct lookups? (Select two)

  A. DB2
  B. ODBC
  C. Oracle
  D. Teradata
  E. SqIServer
  A. DB2
  C. Oracle

• Question 17:

  You have been given operational requirements to introduce data recovery to one of your parallel job designs. Additionally, you have been told that you are to use flat files as your intermediate data structure. Which two tasks will accomplish these objectives? (Choose two.)

  A. Use the Sequential stage to export and import data between jobs.
  B. Enable checkpoint restartability in each of your parallel stages.
  C. Break up the design by splitting it into at least two parallel jobs.
  D. Use the Hash File stage to write and read data between parallel jobs.
  A. Use the Sequential stage to export and import data between jobs.
  C. Break up the design by splitting it into at least two parallel jobs.

• Question 18:

  What is the correct method to process a file containing multiple record types using a Complex Flat File stage?

  A. Manually break the file into multiple files by record type.
  B. Define record definitions on the Constraints tab of the Complex Flat File stage.
  C. Define record ID constraints on the Records ID tab of the Complex Flat File stage.
  D. Use a Modify stage to convert the output array from the Complex Flat File to a subrecord.
  C. Define record ID constraints on the Records ID tab of the Complex Flat File stage.

• Question 19:

  The purchase history record contains CustID, ProductID, ProductType and TotalAmount. You need to retain the record of greatest TotalAmount per CustID and ProductType using RemoveDuplicate stage. Which two statements accomplish this requirement? (Choose two.)

  A. Hash-partition on CustID;Sort on CustID,ProductType and TotalAmount.
  B. Hash-partition on ProductType;Sort on ProductType,CustID and TotalAmount.
  C. Hash-partition on CustID and ProductType;Sort on CustID,ProductType and TotalAmount.
  D. Hash-partition on CustID,ProductType and TotalAmount;Sort on CustID,ProductType and TotalAmount.
  A. Hash-partition on CustID;Sort on CustID,ProductType and TotalAmount.
  C. Hash-partition on CustID and ProductType;Sort on CustID,ProductType and TotalAmount.

• Question 20:

  Records in a source file must be copied to multiple output streams for further processing. Which two conditions would require the use of a Transformer stage instead of a Copy stage? (Choose two.)

  A. Renaming one or more output columns.
  B. Concatenating data from multiple input columns.
  C. Converting some input columns from integers to strings.
  D. Directing selected output records down one output link rather than another.
  B. Concatenating data from multiple input columns.
  D. Directing selected output records down one output link rather than another.