How to Prepare For IBM InfoSphere QualityStage Fundamentals Technical Mastery Test v1

Preparation Guide for IBM InfoSphere QualityStage Fundamentals Technical Mastery Test v1

Introduction

This exam validates the technical knowledge required for the purpose of identifying, managing and closing sales opportunities.The test is applicable to sales representatives who demonstrate sales and technical knowledge of the software and targets the technical sales professional who can deliver a comprehensive business solution to customers through solution identification, product differentiation, and competitive positioning.

Passing this test counts towards PartnerWorld competency requirements and helps you attain higher membership levels. This test also entitles you to use the mastery qualification title on your business card. IBM P2090-95 practice exams and IBM P2090-95 practice test have all questions related to this.

Candidate should give this exam who want:

• Understand QualityStage commonly used components and processes
• Understand the algorithms used in QualityStage to improve data quality
• Understand general concept of data quality and QualityStage

Sample Questions

Which of the following rules will retain FIELD1 with the longest last name and TITLE equals to “MR”?

• FIELD1: SIZEOF(TRIM(c.“LASTNAME”))<= SIZEOF(TRIM(b.“LASTNAME”)) AND c.TITLE=“MR”
• FIELD1: SIZEOF(TRIM(c.“LASTNAME”))>= SIZEOF(TRIM(b.“LASTNAME”)) AND c.TITLE=“MR”
• FIELD1: SIZEOF(TRIM(c.“LASTNAME”))>= SIZEOF(TRIM(b.“LASTNAME”)) AND b.TITLE=“MR”
• FIELD1: SIZEOF(TRIM(c.“LASTNAME”))>= SIZEOF(TRIM(c.“LASTNAME”)) AND c.TITLE=“MR”

Which of the following is TRUE regarding the use of Critical Fields?

• Critical Fields do not have to match exactly.
• Critical Fields are fields with missing values.
• Critical Fields are used to identify fields that must agree in order for records to be linked.
• Only critical fields of a record are used to calculate the composite weights of the record.

In Standardization Rule Sets, classification table contains what?

• Class, token, and standard form.
• Field name, data type, and position in record.
• Pattern of tokens, actions to execute, and the logic.
• Token, standard form, class, and override rules.

Investigation of data using QualityStage is for _____________________

• discovering the actual values of missing data.
• identifying all the data sources for data consolidation.
• transforming the data from one data type to another.
• verifying the reliability of the data in the fields to be used as matching criteria.

What is DataStage/Quality Stage Administrator client used for?

• Compiling all the jobs at once.
• Scheduling jobs to execute.
• Setting up project properties.
• Exporting log messages for a job.

What does character discrete investigation examine?

• Multiple domain fields.
• None of the above.
• Both single domain and multiple domain fields.
• Single domain fields.

What is DataStage/QualityStage Director client used for?

• Enabling run time column propagation for parallel jobs.
• Clearing log messages of a job.
• Compiling and executing a job.
• Publishing and managing shared information services.

Which one of the following is NOT a survive technique?

• Probability based rule
• Most Frequent
• Longest Field
• Most Recent

Which of the following should be avoided regarding the use of Match Improvement Strategy?

• Add additional passes.
• Use only one Match Pass.
• Set critical values for important fields.
• Adjust weights using weight overrides.

A QualityStage investigate job will NOT ________________

• discover trends and anomalies.
• examine single domain and free-form text fields.
• identify invalid and default values.
• group records together that are considered duplicates.

What does the informational content of a QualityStage Match phase measure?

• The significance of discriminating value and frequency.
• The severity of false positives and false negatives.
• The degree of importance of a particular data field.
• The confidence of a match.

What does the QualityStage Standardization Rule Set contain?

• Rules for eliminating columns of data.
• Rules on which records to keep
• Logic for parsing, classifying, and pattern processing the data.
• Information on how to perform calculation with the data.

Which one of the following is NOT a necessary step in QualityStage to address data quality issues?

• Investigate
• Survive
• Standardize
• Transform

If data value AEJPA 5342G is investigated using an all-C mask, what would the result look like?

• CCCCBCCCCC
• AEJPA 5342G
• AEJPA G
• AEJPA XXXXG

Which of the following is NOT true regarding the use of Match Type?

• Reference Match has one-to-one correspondence.
• Unduplicate Match requires two source files.
• Reference Match has many-to-one correspondence.
• All of the above.

What will a QualityStage match job do?

• Create cross reference keys.
• Enforce business standards on data elements.
• Construct consolidated household views of individuals.
• Gain complete understanding of data within context.

Which of the following is Weight Override used to add or replace?

• Calculated weight
• Disagreement weight
• All of the above.
• Agreement weight

Which of the following is NOT a Match Stage comparison method?

• NAME_UNCERT
• UNCERT
• FREQUENCY
• CNT_DIFF

Which of the following will be generated by a QualityStage Word Investigate job?

• Sample report and detail report.
• Pattern report and token report.
• Sample report and token report.
• Pattern report and output report.

What is Character Concatenate method used for?

• To generate reports for frequency and pattern references.
• To investigate one or more fields to uncover any relationship between the field values.
• All of the above.
• To analyze data using one or more character masks.

For more info read reference:

IBM P2090-95 Official Certification Site