Number of questions: 63
Time allowed in minutes: 90
Required passing score: 71%
Languages: English, Japanese
This exam will certify that the successful candidate has important knowledge and skills necessary to professionally design and develop a QualityStage v9.1 solution to produce efficient and accurate results.
Section 1 – Methodology (5%)
Describe the steps in data quality methodology
Understand the impact of data integration preparsing
Section 2 – Design Considerations (13%)
Identify the steps for standardization
Demonstrate knowledge how to optimize QualityStage jobs using parallel concepts
Demonstrate knowledge how to handle data from multiple countries
Describe initial vs. delta vs. real-time design considerations
Section 3 – Investigation (8%)
Demonstrate knowledge of investigation types
Describe how investigation results can be used
Section 4 – Standardization / Adresses / Postal (14%)
Describe the differences between certification, vertification and standardization
Define what the standardization stages are and how to use them
Describe the purpose of standardization and what results are produced by the process
Section 5 – Rule Sets (16%)
Demonstrate knowledge of how to customize standardization rules
Demonstrate knowledge of the components of a rule and their functions
Demonstrate knowledge of managing standardizations rules
Demonstrate knowledge of user defined standardization rules
Section 6 – Matching (21%)
Demonstrate knowledge of match concepts
Describe the match job components
Describe how to review and tune a match
Demonstrate knowledge of managing match specification (re-usability)
Demonstrate knowledge of match job design to achieve optimal performance
Section 7 – Survive (10%)
Describe the purpose of the survive stage
Demonstrate knowledge of the different rule types for surviving data and when to use them
Describe how to implement a survive stage
Section 8 – Setup and Troubleshooting (14%)
Identify how to troubleshoot a QualityStage job
Describe how to configure data quiality environment functionality
Describe QualityStage deployment considerations
Demonstrate knowledge of NLS/non-NLS install and its impact on QualityStage stages
Explain the process necessary to run multiple copies of the job (job multi-instance)
IBM Certified Solution Developer – InfoSphere QualityStage v9.1
Job Role Description / Target Audience
The IBM Certified Solution Developer – InfoSphere QualityStage v9.1 is a data quality developer, analyst and architect and has important knowledge and skills necessary to professionally design and develop a QualityStage v9.1 solution to produce efficient and accurate results.
Recommended Prerequisite Skills
Must understand overall QualityStage functionality:
Possess detailed knowledge of QualityStage stages to develop an effective application
Postal Applications and Address Verification Interface (AVI)
Real-time design of QualityStage
Integration into InfoSphere DataStage solutions
Job design using the DataStage and QualityStage Designer interface
Assess the appropriateness and quality of data for data integration initiative
Ensures QualityStage solution meets business requirements
Monitors resolution of data quality issues
Provides metadata to create functional and technical specifications for data integration/cleansing applications
Design auditing processes to meet data integrity needs
Design data quality processes through a QualityStage application
Determine the appropriate tool to fulfill data quality and business requirements
How does QualityStage output the correct ISO code for a record?
A. ISO code functionality is not available.
B. ISO code supplied by the Country rule set.
C. ISO code supplied by the USPREP rule set.
D. ISO code supplied by the US Address rule set.
Explanation: The ISOterritorycode is appended to the domain preprocessor abbreviation (PREP).
You need to create a batch delta match process for transaction records against a very large
master file of existing clients.
Which QualityStage match option should be used?
A. Transitive One-source match
B. Two-source many-to-one match
C. Deterministic One-source match
D. Two-source many-to-many match
Explanation: Transitive One-source matchcan extend further than one-source-dependent
because it uses all the pairs that score above the match cutoff. It’s recommended if you want to
account forinconsistentdata entryin fields that assist in duplicate identification.
How can Word Investigation reports be used to modify a rule set?
A. Corrects spelling errors in the data field.
B. Adds tokens to allow identification of additional duplicates.
C. Identifies new tokens to allow additional words to be classified.
D. Identifies matched words to be used in match designer frequency distribution.
Which statement about the jobs used by the Match Specification Setup Wizard is true?
A. The jobs must be created.
B. The jobs must be imported.
C. The jobs exist for only One-source individual match.
D. The jobs are created in the repository at installation time.
When would you use the survive technique ‘Most Frequent’?
A. When more than one target field is required.
B. When the most frequent occurrence is required.
C. When the most frequently populated value is required.
D. When the most frequently populated value is required with two or more occurrences.