IBM P2090-095 - InfoSphere QualityStage Fundamentals Technical Mastery Test v1 Exam
Page: 1 / 8
Total 39 questions
Question #1 (Topic: )
Which of the following rules will retain FIELD1 with the longest last name and TITLEequals
to "MR"?
to "MR"?
A. FIELD1: SIZEOF(TRIM(c."LASTNAME"))<= SIZEOF(TRIM(b."LASTNAME")) AND c.TITLE="MR"
B. FIELD1: SIZEOF(TRIM(c."LASTNAME"))>= SIZEOF(TRIM(c."LASTNAME")) AND c.TITLE="MR"
C. FIELD1: SIZEOF(TRIM(c."LASTNAME"))>= SIZEOF(TRIM(b."LASTNAME")) ANDb.TITLE="MR"
D. FIELD1: SIZEOF(TRIM(c."LASTNAME"))>= SIZEOF(TRIM(b."LASTNAME")) AND c.TITLE="MR"
Answer: D
Question #2 (Topic: )
Which of the following is TRUE regarding the use of Critical Fields?
A. Critical Fields are used to identify fields that must agree in order for records to be linked.
B. Critical Fields do not have to match exactly.
C. Only critical fields of a record are used to calculate the composite weights of the record.
D. Critical Fields are fields with missing values.
Answer: A
Question #3 (Topic: )
Investigation of data using QualityStage is for _____________________
A. transforming the data from one data type to another.
B. discovering the actual values of missing data.
C. verifying the reliability of the data in the fields to be used as matching criteria.
D. identifying all the data sources for data consolidation.
Answer: C
Question #4 (Topic: )
What is DataStage/Quality Stage Administrator client used for?
A. Setting up project properties.
B. Scheduling jobs to execute.
C. Compiling all the jobs at once.
D. Exporting log messages for a job.
Answer: A
Question #5 (Topic: )
What does character discrete investigation examine?
A. Single domain fields.
B. Multiple domain fields.
C. Both single domain and multipledomain fields.
D. None of the above.
Answer: A
