Number of questions: 64
Time allowed in minutes: 90
Required passing score: 64%
The IBM Certified Solution Developer – IBM InfoSphere Information Analyzer v9.1 exam certifies that the successful candidate has important knowledge, skills, and abilities necessary to conduct a baseline assessment of the data/information being analyzed. This included characterizing the data or information condition in terms of completeness, validity, structural integrity, relational integrity, technical standards, and business rule compliance including quality monitoring and information governance.
Section 1 – Environment (9%)
List key components and configuration steps
Given a scenario, describe how to plan for a large data environment
Identify the minimum requirements for installation
Section 2 – Data Setup (9%)
Identify steps necessary to make data sources available for analysis
Given a scenario, describe project activity security
Section 3 – Profiling Process (25%)
Identify the purposes of each analysis
Interpret system flag icons throughout the system
Identify the common steps that are needed to perform data profiling
Given a scenario, describe the process needed to assess and use data profiling results
Section 4 – Data Rules / Monitoring (36%)
Describe the purpose of data rule validation
Given a scenario, describe the process to implement and deploy the data rule
Identify the steps needed to implement data rule monitoring and baselining
Identify the steps needed to perform data rule execution
Describe the purpose and process of exception management (output tables, Data Quality Console)
Identify the steps necessary to deploy and execute a data rule in an external process
Section 5 – Populating / Reporting / Publishing (14%)
Demonstrate how to populate/report/publish
Demonstrate knowledge of content creation and scheduling
Given a scenario, describe the process to deliver outputs to a broad community
Section 6 – Troubleshooting / Tuning (6%)
Given a scenario, demonstrate troubleshooting techniques
Given a scenario, demonstrate system and process tuning techniques
IBM Certified Solution Developer – InfoSphere Information Analyzer v9.1
Job Role Description / Target Audience
The IBM Certified Solution Developer – InfoSphere Information Analyzer v9.1 is a Source System Analyst, Data Analyst, Business Analyst, Data Quality Analyst, Data Steward, Data Modeler, Data Architect, ETL Developer, and Data Scientist.
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
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
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’
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. -includeCommonMetadata; -includeCommonReports; -includeAIIDataClasses
B. -includeAssignedAssets; -includeProjectReports; -includeAIIDataSources
C. -includeCommonMetadata; -includeReports; -includeAIIDataClasses
D. -includeProjectMetadata; -includelAReports; -includeDependentClasses