IBM C2090-421 Online Practice Questions and Exam Preparation

IBM C2090-421 Online Questions & Answers

• Question 131:

  What role must a user have to delete shared metadata assets from the repository?

  A. Common Metadata User
  B. DataStage Administrator
  C. Information Analyzer User
  D. Common Metadata Administrator
  E. Business Glossary Administrator
  D. Common Metadata Administrator

• Question 132:

  The given job processes large volumes of data using default partitioning, with sort/partition insertion enabled. Both source Data Sets are partitioned and sorted on the merge key. Assuming that the business logic allows all of the following actions, which design change would improve the performance of this job?

  

  A. Set the buffer mode to "no buffer" on the output links of both Data Sets.
  B. Use the Data Set Management Utility to combine both input Data Sets into a single source Data Set.
  C. Set the "Preserve Partitioning" option on both Data Sets and replace the Merge stage with a Sort Funnel stage.
  D. Before each input to the Merge stage,insert a Sort stage with "Don't Group,Previously Grouped" set on the merge key. Specify SAME partitioning on all inputs.
  D. Before each input to the Merge stage,insert a Sort stage with "Don't Group,Previously Grouped" set on the merge key. Specify SAME partitioning on all inputs.

• Question 133:

  Refer to the exhibit.

  

  You submit a job from DataStage Director and then log onto your DataStage Linux server to issue the command "ps-ef | grepds" and receive the following screen: Which process is the section leader for node2?

  A. 7216
  B. 7219
  C. 7220
  D. 7221
  D. 7221

• Question 134:

  Which two tasks can the Slowly Changing Dimensions (SCD) stage perform? (Choose two.)

  A. Look up whether a record with a matching business key value exists in a dimension table. If it does,add new values for selected fields to values lists for those fields.
  B. Look up whether a record with a matching business key value exists in a fact table. If it does not,retrieve a new surrogate key value and insert a new row into the fact table.
  C. Look up whether a record with a matching business key value exists in a dimension table. If it does not,retrieve a new surrogate key value and insert a new row into the dimension table.
  D. Look up whether a record with a matching business key value exists in a dimension table. If it does,mark the record as not-current,and generate a new record with new values for selected fields.
  C. Look up whether a record with a matching business key value exists in a dimension table. If it does not,retrieve a new surrogate key value and insert a new row into the dimension table.
  D. Look up whether a record with a matching business key value exists in a dimension table. If it does,mark the record as not-current,and generate a new record with new values for selected fields.

• Question 135:

  A job needs to split a single Data Set into three Data Sets based on conditions that are supplied at runtime. Which stage would allow you to parameterize the conditions for splitting the input data set?

  A. Filter stage
  B. Switch stage
  C. Transformer stage
  D. Split Vector stage
  A. Filter stage

• Question 136:

  The result of a performance review for one of your job designs indicated this job needs to be split into two separate jobs. You also have been given the requirement to ensure you maintain parallelism (no re- partitioning) between these two new jobs.

  Which single stage should you consider to accomplish maintaining parallelism and not introduce re- partitioning between these related jobs?

  A. Copy stage
  B. Data Set stage
  C. Named Pipe stage
  D. Sequential File stage
  D. Sequential File stage

• Question 137:

  Which Oracle data type conversion is correct?

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

• Question 138:

  A 100MB input dataset has even distribution across 400 unique key values.

  When run with a 4-node configuration file, which two changes could improve sort performance in this scenario? (Select two)

  A. Convert all numeric fields to varchars.
  B. Set $APT_TSORT_STRESS_BLOCKSIZE to 50MB.
  C. Alter the Sort stage properties to perform a stable sort.
  D. Specify Round Robin partitioning on the input link to the Sort stage.
  E. Specify "Restrict Memory Usage" to 60MB on the Sort stage properties.
  B. Set $APT_TSORT_STRESS_BLOCKSIZE to 50MB.
  E. Specify "Restrict Memory Usage" to 60MB on the Sort stage properties.

• Question 139:

  In a file defining a partial schema, which three properties define the record? (Choose three.)

  A. text
  B. delim
  C. intact
  D. record_length
  E. record_delim_string
  C. intact
  D. record_length
  E. record_delim_string

• Question 140:

  You are asked by management to document all jobs written to make future maintenance easier. Which two statements are true about annotations? (Choose two.)

  A. The full job description can be identified within the Description Annotation stage.
  B. The background for the Description Annotation stage can be changed for each unique stage.
  C. The Description Annotation stage contains both the short and full descriptions for the job.
  D. The Description Annotation stage can be added several times at different locations to identify business logic.
  A. The full job description can be identified within the Description Annotation stage.
  C. The Description Annotation stage contains both the short and full descriptions for the job.