A Data Quality team repeatedly corrects invalid postal codes in the warehouse, but the same errors reappear after every nightly load. What is the most appropriate long-term response?

• A. Reduce the frequency of data loads
• B. Correct the source or integration process causing the defect
• C. Ignore the issue because cleansing already works
• D. Increase the number of cleansing scripts in the warehouse

Three source systems provide different telephone numbers for the same customer. An MDM hub selects one number according to approved source-priority rules. This is an example of:

• A. Survivorship
• B. Archiving
• C. Normalization
• D. Encryption

The process of translating plain text into complex codes to hide privileged information is:

• A. Encapsulation
• B. Exaggeration
• C. Elimination
• D. Encryption
• E. Enhancement

Data Staging areas are populated from source databases using extract functions, transformed and then:

• A. Made ready for metrics calculations and key performance indicators
• B. Made ready for review by a data modeller, for physical modelling
• C. Made ready for metadata repository loading
• D. Made ready and loaded into the data warehouse
• E. Made ready with advanced profiling and reported into a visualisation tool

A dataset contains every required customer record, but 8% of the telephone numbers belong to different people. Which statement is correct?

• A. Accuracy is irrelevant when completeness is high
• B. The dataset cannot be complete unless it is accurate
• C. The dataset can be complete but inaccurate
• D. Uniqueness and completeness are identical