CDMP-RMD practice question 13 of 35
What activity is helpful in mapping source system data for MDM efforts?
Full set: 100 questionsData 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.
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.
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)
Keep practicing
Take the free CDMP-RMD practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other CDMP-RMD practice questions
- Question 1Which is NOT considered a type of Master Data relationship?
- Question 2Which of the following is NOT part of MDM Lifecycle Management?
- Question 3When establishing a MOM. what is the benefit of doing data profiling?
- Question 4Which of the following are reasons why marketing is important to a MDM program?
- Question 5Master Data and metadata ran both he used to aggregate dat a. Master Data require* that t…
- Question 6The 3 primary categories of components in a MDM framework are:
