CDMP-RMD practice question 13 of 35

What activity is helpful in mapping source system data for MDM efforts?

Full set: 100 questions
Answer options
A: Data profiling Correct answer
B: ETL toolset
C: Process modeling
D: Data dictionary
E: Data modeling
Correct Answer:
A. Data profiling
Explanation

Data profiling is the activity of analyzing source data to discover its content, structure, and quality. For Master Data Management (MDM) efforts, this is a critical initial step. Profiling reveals the actual state of the data in source systems, including data types, value ranges, frequency of nulls, and adherence to patterns. This detailed understanding is essential for creating accurate source-to-target mapping rules, defining data cleansing and transformation logic, and ensuring that data from various sources can be successfully integrated into the master data model. It directly informs how to handle source data variations during the mapping process.

Why Incorrect

B. ETL toolset: This is a category of software (a tool) used to perform the data extraction and transformation, not the analytical activity of understanding the source data to define the mapping.
C. Process modeling: This activity focuses on documenting business workflows. While related, it does not provide the detailed data-level analysis needed to map specific data elements.
D. Data dictionary: This is an artifact or deliverable that documents metadata. It is often a result of analysis activities like profiling, not the activity itself.
E. Data modeling: This activity is primarily focused on designing the target master data schema, not on the analysis of the source data required to populate it.

References

1. DAMA International. (2017). DAMA-DMBOK: Data Management Body of Knowledge (2nd ed.). DAMA International.

Chapter 11, Section 3.3.2, Identify and Profile Sources: "Data profiling is a key technique for understanding the content and quality of source data. This understanding is necessary to map source data to the master data model and to design processes to improve data quality." (p. 358)

Chapter 8, Section 4.2, Data Profiling: "Data profiling is the analysis of data to establish its metadata... Profiling is used to... Assess data source suitability for a project (e.g., MDM, data warehouse, data conversion, or application migration)." (p. 267)

Scroll to Top