Question 1
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(c."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(b."LASTNAME")) AND c.TITLE="MR"
Question 2
Which of the following is TRUE regarding the use of Critical Fields?
- Critical Fields are used to identify fields that must agree in order for records to be linked.
- Critical Fields do not have to match exactly.
- Only critical fields of a record are used to calculate the composite weights of the record.
- Critical Fields are fields with missing values.
Question 3
In Standardization Rule Sets, classification table contains what?
- Field name, data type, and position in record.
- Class, token, and standard form.
- Pattern of tokens, actions to execute, and the logic.
- Token, standard form, class, and override rules.
Question 4
Investigation of data using QualityStage is for _____________________
- transforming the data from one data type to another.
- discovering the actual values of missing data.
- verifying the reliability of the data in the fields to be used as matching criteria.
- identifying all the data sources for data consolidation.
Question 5
What is DataStage/Quality Stage Administrator client used for?
- Setting up project properties.
- Scheduling jobs to execute.
- Compiling all the jobs at once.
- Exporting log messages for a job.