IBM InfoSphere Information Analyzer v9.1 - C2090-305 Exam Questions [2026]

QUESTION NO: 1
Which two can be used to identify exception descriptors of interest in the Data Quality Console?

A. View exception descriptors on the Data Rule Execution History page B. View rule definitions on the Data Quality tab C. Use the search criteria on the Exceptions page D. View rule exceptions on the All Quality Controls chart on the Home page E. View exception descriptors on the Home page

Correct Answer: B,E

QUESTION NO: 2
You are reviewing the summary of a data rule on the Information Analyzer Home Page dashboard and see a red exclamation mark.
What does it signify?

A. The job for the data rule failed to run successfully. B. The data rule result was not delivered to the Data Quality Console. C. The data rule failed to meet the target benchmark for two or more instances. D. The data rule was run via an external scheduler.

Correct Answer: D

QUESTION NO: 3
What are three of the analytical functions used in column analysis?

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

Correct Answer: D

QUESTION NO: 4
You are analyzing a known table with a five column primary key. You wish to confirm its uniqueness with minimal processing time.
Which steps should you take?

A. Select only the five columns and run Multi-column Primary Key Analysis with Composite Key Maximum Columns = 5. Review Primary Key Analysis on the Multi-column tab. B. Create a Virtual Column including only the five columns, select the Virtual Column and run Column Analysis. Review Primary Key Analysis for the Virtual Column on the Single column tab. C. Create a Virtual Table including only the five columns, select the Virtual Table and run Multi-column Primary Key Analysis with Composite Key Maximum Columns = 1. Review Primary Key Analysis on the Multi-column tab. D. Select only the five columns and run Multi-column Primary Key Analysis with Multi-column option = Concatenate. Review Primary Key Analysis on the Multi-column tab.

Correct Answer: D

QUESTION NO: 5
You are searching for an employee named Kristie Jones who has accounts on various applications, in which she has used the first names Kristie, Kristin, and Kristen as her first name.
Which is the correct rule logic for addressing this problem?

A. name contains ('KristieTKristinTKristen'^rJones' B. name matches_regex ('Kristie'l'KristinTKristen^j'Jones' C. name like ('KristieTKristinTKristen')[ ]'Jones' D. name matches (,KristieTKristinTKristen,)[]'Jones,

Correct Answer: A

QUESTION NO: 6
What are the three domain analysis methods?

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

Correct Answer: D

QUESTION NO: 7
You need to capture the results of a data rules execution so it can be used in subsequent data rules. Which approach will work?

A. When defining Output from the data rule, select System Table Only on the output tab, name your table, and select "Overwrite" for update method. B. Export system generated table from Information Analyzer Database, load the export into the Information Server repository, and select "Import" for the update method. C. When defining Output from the data rule, select ODBC DSN from drop down list for the target database for the results, name your table, and select "Overwrite" for update method. D. When defining Output from the data rule, select Simple User-Named table on the output tab, name your table, and select "Overwrite" for update method.

Correct Answer: A