IBM C2090-305 - IBM InfoSphere Information Analyzer v9.1 Exam

Page:    1 / 13   
Total 64 questions

A company is starting an Information Analysis project to assess the data quality of Key
Performance Indicators (KPIs). They also want to setup on-going monitoring of the data quality and have no tolerance for error.
Which two statements are true when considering what data to analyze?

  • A. Sample the source data.
  • B. Analyze all rows in the source data.
  • C. Analyze all columns in the source data.
  • D. Analyze only those columns that support the KPIs.
  • E. Create a virtual column containing only those columns that support the KPIs.


Answer : A,D

Which rule definition logic will ensure that no value in a column appears more than three times in the data?

  • A. testvalue EXISTS <= 3
  • B. testvalue OCCURS <= 3
  • C. testvalue APPEARS <= 3
  • D. testvalue CONTAINS <= 3


Answer : D

When viewing Column Analysis Summary information, a comment will be indicated by which of the following?

  • A. 'Note'icon
  • B. 'Red flag' icon
  • C. 'Green check' icon
  • D. 'Yellow question mark' icon


Answer : A

Reference:https://www.scribd.com/doc/125259952/IBM-infoSphere-information-analyzer- v8-7-User-guide(page 88)

What are the three domain analysis methods?

  • A. Value, range, completeness
  • B. Value, range, reference table
  • C. Format, range, reference table
  • D. Value, pattern, reference table


Answer : B

Reference:https://www.scribd.com/doc/125259952/IBM-infoSphere-information-analyzer- v8-7-User-guide(page 82)

You need to check multiple columns for duplicates. How does changing the column sequence in Run Duplicate Analysis affect the duplicate check analysis results?

  • A. It has no effect on the results.
  • B. It may result in more duplicates.
  • C. It may result in fewer duplicates.
  • D. You can only run duplicate check analysis on single columns.


Answer : A

Reference:http://www-
01.ibm.com/support/knowledgecenter/SSZJPZ_11.3.0/com.ibm.swg.im.iis.ia.faq.doc/topics/ ia_faq_running_table_analysis.html?cp=SSZJPZ_11.3.0%2F12-15-1-1-3

Page:    1 / 13   
Total 64 questions