IBM P2090-095 Exam Actual Questions

Topic 1 - Single Topic

Question #1 Topic 1

Which of the following rules will retain FIELD1 with the longest last name and TITLE equals 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")) AND b.TITLE="MR"
D. FIELD1: SIZEOF(TRIM(c."LASTNAME"))>= SIZEOF(TRIM(b."LASTNAME")) AND c.TITLE="MR"

Reveal Solution Discussion

Correct Answer: D 🗳️

Question #2 Topic 1

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.

Reveal Solution Discussion

Correct Answer: A 🗳️

Question #3 Topic 1

In Standardization Rule Sets, classification table contains what?

Reveal Solution Discussion

Correct Answer: B 🗳️

Question #4 Topic 1

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.

Reveal Solution Discussion

Correct Answer: C 🗳️