P2090-078 Online Practice Questions and Answers

Which of these is NOT a valid input for deriving data (assuming nothing else has changed in your configuration)?

A. A text file containing the original source extract

B. Existing binary files

C. Existing UNL files

D. Existing data in the Hub database

Which field is an internal identifier that is generated by the Hub?

A. MemRecNo

B. MemIdNum

C. MemSeqNo

D. MemIdent

What is NOT part of the output of the Derive Data and Create UNLs (MPXDATA) job?

A. Binary Comparison Files

B. Comparison Strings (mpi_memcmpd)

C. Comparison Scores

D. Bucket Hash Assignments (mpi_membktd)

Which Bucket Generation Function Code would convert Social Security Number "145-39-2805" to "012345589"?

A. Sorted

B. String Range

C. Numeric Range

D. Equivalence

In which table would you find the list of standard Nicknames?

A. mpi_StrWord

B. mpi_StdNick

C. mpi_StrEqui

D. mpi_StdFunc

Which field contains the primary identifier that was generated by the source system?

A. MemRecNo

B. MemIdNum

C. MemSeqNo

D. MemIdent

Which table would store Edit Distance weights for comparing Driver's License combined with a Postal Code?

A. mpi_wgt2dim

B. mpi_wgtHead

C. mpi_wgt1dim

D. mpi_wgtNval

An "Attribute Type" can also be referred to as what?

A. Segment

B. AttrRecNo

C. SegAttrNo

D. AttrType

Which task type works with records that come from different sources?

A. Potential Overlay

B. Potential Duplicate

C. Potential Linkage

D. Review Identifier

How should you add a list of Anonymous Values to the database?

A. On the Strings tab in Workbench

B. As a Job in Workbench

C. Directly in the mpi_AnonList database table

D. Using the Inspector tool