IBM C2090-423 Online Practice Questions and Exam Preparation

IBM C2090-423 Online Questions & Answers

• Question 41:

  Which three analytical functions are used in column analysis?

  A. data type, domain, selectivity
  B. baseline, domain, valid values
  C. completeness, domain, format
  D. completeness, data type, foreign key
  C. completeness, domain, format

• Question 42:

  There is a requirement to test a numeric column ID against a desired output of "(15)". What is the correct rule logic to test for this situation?

  A. val(ID, '(%c)') = '(15)'
  B. tostring(ID, '(nn)') = '(15)'
  C. tostring(ID, '(%i)') = '(15)'
  D. to_char(ID, '(\(nn\))') = '(15)'
  C. tostring(ID, '(%i)') = '(15)'

• Question 43:

  During profiling, you found a column called 'Month' with the values 1 thru 12. You know from experience that these numbers represent the corresponding months, January - December. You want the new system to use a three character abbreviation for the month. How should you document this finding regarding what each numeric value represents?

  A. Add a new column to the source table with the new values
  B. From the Note palette, select New, add Subject, set Type to 'Mapping Specification', type in the new character value, then choose Create New Mapping Specification
  C. From the Frequency Distribution tab, select Month column, click in the 'Transformation Value' column, type in new character value, then choose create New Reference Table and choose type Mapping (all values)
  D. From the Frequency Distribution tab, select Month column, under Data Value, click in the 'Definition' column, type in new character value, then choose create New Reference Table and choose type Mapping (all values)
  C. From the Frequency Distribution tab, select Month column, click in the 'Transformation Value' column, type in new character value, then choose create New Reference Table and choose type Mapping (all values)

• Question 44:

  Where would you set the validity benchmark for data rules?

  A. During data rule updates to IADB
  B. During data rule definition process
  C. During data rule field binding process
  D. During data rule output results review process
  B. During data rule definition process

• Question 45:

  Which column analysis function facilitates segregating and organizing columns categorically?

  A. Format
  B. Quintile
  C. Properties
  D. Classification
  D. Classification

• Question 46:

  A data rule is required to detect and report carriage return ASCII unprintable characters embedded within a character string field called Codefield. Which rule definition logic will correctly test this condition?

  A. Codefield like '\r'
  B. Codefield equals '\r'
  C. Codefield includes '\r'
  D. Codefield contains '\r'
  D. Codefield contains '\r'

• Question 47:

  What are two properties of global logical variables? (Choose two.)

  A. Global logical variables cannot be changed once created.
  B. Global logical variables can be reused by other rule definitions.
  C. Global logical variables need rebinding when generating a data rule.
  D. Global logical variables hold parameters which are valid system wide.
  E. Global logical variables cannot be found to a physical source column.
  B. Global logical variables can be reused by other rule definitions.
  D. Global logical variables hold parameters which are valid system wide.

• Question 48:

  After multiple runs of data rules were completed, where can you see and evaluate data exception trends?

  A. Checking data rule view Trend?workspaceChecking data rule view Trend?workspace
  B. Checking data rule view Graph?workspaceChecking data rule view Graph?workspace
  C. Checking data rule view Incline?workspaceChecking data rule view Incline?workspace
  D. Checking data rule view Output?workspaceChecking data rule view Output?workspace
  D. Checking data rule view Output?workspaceChecking data rule view Output?workspace

• Question 49:

  If there is a need to run data rules on a daily basis, which two of the following are the options? (Choose two.)

  A. Create a bundle and run IAJob command
  B. Schedule IAJob runs using DataStage Director
  C. Run IAJob command pointing to data rule executable
  D. Create shell script with data rule associated bindings
  E. Submit IAJob command on a daily basis from Information Server Web console
  A. Create a bundle and run IAJob command
  C. Run IAJob command pointing to data rule executable

• Question 50:

  The results of a column analysis can be further utilized in additional InfoSphere Information Server tools. Which item can be used to enforce domain requirements and completeness requirements or to control data conversion?

  A. Reference table
  B. Relationship table
  C. Reference column
  D. Relationship column
  A. Reference table