100% IBM C2090-305 Guaranteed Success With Testing Engine

IBM C2090-305 Exam Overview:

IBM C2090-305 Exam Syllabus Topics:

IBM InfoSphere Information Analyzer v9.1 Sample Questions:

Question #1
You are evaluating a Date of Birth field in a customer table. What are the three key steps in analyzing this field?

A. Ensure no skews in frequency; Ensure only numeric values; Evaluate as a primary key.
B. Ensure only binary values; Evaluate skews in frequency; Ensure no special characters.
C. Ensure no null values; Evaluate skews in frequency; Ensure consistency in format.
D. Ensure all unique values; Evaluate out-of-range in frequency; Ensure consistency in format.

Question #2
Which two can be used to identify exception descriptors of interest in the Data Quality Console?

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

Question #3
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 Multi-column option = Concatenate. Review Primary Key Analysis on the Multi-column tab.
B. 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.
C. 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.
D. 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.

Question #4
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 like ('KristieTKristinTKristen')[ ]'Jones'
B. name matches (,KristieTKristinTKristen,)[]'Jones,
C. name matches_regex ('Kristie'l'KristinTKristen^j'Jones'
D. name contains ('KristieTKristinTKristen'^rJones'

Question #5
What are the three domain analysis methods?

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

Solutions: