IBM C2090-422 Online Practice Questions and Exam Preparation

IBM C2090-422 Online Questions & Answers

• Question 71:

  You have to design a batch match delta process. Match candidate records selection from the target database needs to be performed in order to execute reference match. What would be an optimal solution to retrieve the candidates?

  A. Perform Lookup one record at a time to retrieve candidates
  B. Perform Sparse Lookup one record at a time to retrieve candidates
  C. Load fully standardized data into database and perform matching on a database level
  D. Load unduplicated blocking keys into temporary table and extract candidates by joining temporary table and target database.
  D. Load unduplicated blocking keys into temporary table and extract candidates by joining temporary table and target database.

• Question 72:

  Which of the following two tasks are required for the matching process? (Choose two)

  A. Create frequency files for each input file used
  B. Standardize the frequency file used in the process
  C. No Standardization is required for the matching process
  D. Standardize each data file to be used in the match process
  E. Only Standardize the data file and no frequency files are required
  A. Create frequency files for each input file used
  C. No Standardization is required for the matching process

• Question 73:

  If a specific codepage is required to process double byte data at the Project level, where would be two appropriate places to incorporate the change? (Choose two)

  A. Define the codepage required in the Manager
  B. Define the codepage required in the repository
  C. Define the codepage required in the Administrator
  D. Add an Environment Variable and define the codepage required
  E. Open Job Properties and select NLS Tab and select codepage required
  C. Define the codepage required in the Administrator
  D. Add an Environment Variable and define the codepage required

• Question 74:

  If the incoming records in a group have 3 records and 2 of those records contained the same value, which of the following rules would allow that field's value to survive?

  A. Most Often (Non-null)
  B. Most Frequent (Non-null)
  C. Most Frequent (Non-blank)
  D. Most Common (Non-blank)
  C. Most Frequent (Non-blank)

• Question 75:

  You are required to analyze source system data with an Investigate stage. Which two functions can this stage perform? (Choose two)

  A. Classifying tokens
  B. Identifying duplicates
  C. Changing invalid data
  D. Creating reference tables
  E. Creating pattern distributions
  A. Classifying tokens
  E. Creating pattern distributions

• Question 76:

  Customer data is being processed in a single file. Among the fields present for matching are social security number and birth date both of which are inconsistently populated. Which of the match type would be best used to match this data?

  A. Unduplicate Cognitive
  B. Unduplicate Transitive
  C. Unduplicate Dependent
  D. Unduplicate Independent
  B. Unduplicate Transitive

• Question 77:

  Which of the following is true for a group of records to be contained in a match group?

  A. the composite weight calculated during the match procedure is less than the match cutoff threshold
  B. the composite weight calculated during the match procedure is less than the clerical cutoff threshold
  C. the composite weight calculated during the match procedure is equal or greater than the match cutoff threshold
  D. the composite weight calculated during the match procedure is equal or greater than the clerical cutoff threshold
  D. the composite weight calculated during the match procedure is equal or greater than the clerical cutoff threshold

• Question 78:

  Which statement is true with regards to QualityStage sources and targets?

  A. They are the same as DataStage.
  B. They are completely different from DataStage.
  C. They are a subset of what is available with DataStage.
  D. They are a superset of what is available with DataStage.
  A. They are the same as DataStage.

• Question 79:

  You need to design delta process where a batch of new/changed records will have to be compared to the large database of existing customers. Which of the following would satisfy this requirement?

  A. Transitive Match
  B. Unduplicate Match
  C. Unduplicate and Transitive Match
  D. Reference and Unduplicate Match
  D. Reference and Unduplicate Match

• Question 80:

  You are running a complex QualityStage match job on a two CPU server. Your job is running very slow. The parallel engine configuration file contains 6 nodes. What would you do to improve performance?

  A. Reduce scratch space in configuration file
  B. Increase scratch space in configuration file
  C. Reduce number of nodes in configuration file
  D. Increase number of nodes in configuration file
  C. Reduce number of nodes in configuration file