IBM C2090-305 Certification Exam Material - Free Download and Guaranteed Pass

IBM C2090-305 Certification Exam Material - Free Download and Guaranteed Pass



Exam code : C2090-305
Exam name : IBM InfoSphere Information Analyzer v9.1

What feature permits the addition of data from one or more columns into one column
allowing column analysis on this newly formed concatenated column?
A. Virtual table
B. Logical table
C. Virtual column
D. Logical column
Answer: A
When importing published analysis results into a different Information Analyzer project
which two contents are included?
A. Median value
B. Frequency values
C. Data Classification
D. Cardinality Percent
E. Uniqueness Code
Answer: A,D
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 contains ('KristieTKristinTKristen'^rJones'
D. name matches_regex ('Kristie'l'KristinTKristen^j'Jones'
Answer: C
You are working with a System Administrator who must move an Information Analyzer
project to a new Information Server environment using the command line tools. You need
to ensure that the project is established with the same metadata and reports as in the
original environment.
Which parameter must be included to successfully complete the export?
A. -indudeCommonMetadata; -includeCommonReports; -includeAIIDataClasses
B. -includeAssignedAssets; -includeProjectReports; -includeAIIDataSources
C. -indudeCommonMetadata; -includeReports; -includeAIIDataClasses
D. -includeProjectMetadata; -includelAReports; -includeDependentClasses
Answer: C
You are working with a database administrator (DBA) who would like to create a revised
format for a database based on your data profiling results. The DBA wants to directly
create the resulting tables from the analysis.
What steps are necessary to provide usable output to the DBA?
A. Select lnvestigate>Publish Analysis Results; select the relevant Table; select Generate
Physical Model; select Create DDL File option; enter file location; click Submit.
B. Select lnvestigate>Column Analysis; select the relevant Table; select Export Data
Model; select Create ANSI Standard DDL option; enter file location; click Submit.
C. Select lnvestigate>Publish Analysis Results; select the relevant Table; choose the
Generate Database DDL option; select the database-specific DDL type; enter file location;
click Submit.
D. Select lnvestigate>Publish Analysis Results; select the relevant Table; choose the
InfoSphere
Metadata Asset Manager option; click Submit; create New Import Area; select the
InfoSphere Data Architect Metabroker; select the created PDR model; select generate
ANSI standard DDL; click Submit.
Answer: A
If there is a need to run data rules on a daily basis, which two options are valid?
A. Create a bundle and run lAJob command
B. Schedule lAJob runs using DataStage Director
C. Run lAJob command pointing to data rule executable
D. Run lABundle command pointing to all rules to be executed
E. Submit lAJob command on a daily basis from Information Server Operation console
Answer: C,D