CDS Metadata & Master Data Management 3 — Questions and Answers
Question 1: Which metadata management practice ensures that a data element's meaning is consistent across different departments and systems?
- Schema normalization
- Business glossary maintenance (Correct answer)
- Index optimization
- Data archiving policy
Correct answer: Business glossary maintenance
A business glossary standardizes definitions and ensures all stakeholders share a common understanding of each data element.
Question 2: In an MDM coexistence style, which of the following is TRUE?
- Source systems are retired after the hub is deployed
- The hub publishes golden records back to source systems (Correct answer)
- Only the hub stores the authoritative version of master data
- Source systems never receive updates from the MDM hub
Correct answer: The hub publishes golden records back to source systems
In coexistence MDM, the hub creates golden records and distributes them back to participating source systems.
Question 3: A data steward notices the same vendor exists under three slightly different names across ERP, CRM, and procurement. This is an example of:
- Schema drift
- Data duplication / entity resolution problem (Correct answer)
- Metadata versioning conflict
- Master data latency
Correct answer: Data duplication / entity resolution problem
Multiple representations of the same real-world entity across systems is the core entity resolution problem that MDM is designed to solve.
Question 4: What is the role of a reference data set in Master Data Management?
- It stores transactional history for analytics
- It provides standardized code lists used to classify and validate master data (Correct answer)
- It acts as the MDM hub's backup copy
- It defines the ETL transformation logic
Correct answer: It provides standardized code lists used to classify and validate master data
Reference data (e.g., country codes, product categories, currency codes) provides the standardized values that classify and constrain master data attributes.
Question 5: Which technique is most commonly used in probabilistic matching within an MDM system?
- Exact SQL JOIN on primary key
- Fuzzy matching using weighted attribute scoring (Correct answer)
- Regular expression pattern filtering
- Hash-based key lookup
Correct answer: Fuzzy matching using weighted attribute scoring
Probabilistic matching assigns confidence scores based on weighted comparisons of multiple attributes like name, address, and date of birth.
Question 6: Which standard framework is most widely referenced for classifying and managing enterprise metadata?
- TOGAF ADM
- DAMA-DMBOK (Correct answer)
- ITIL v4
- ISO 9001
Correct answer: DAMA-DMBOK
DAMA-DMBOK (Data Management Body of Knowledge) is the primary reference framework for data management including metadata management.
Question 7: A data steward is asked to evaluate metadata completeness for a new dataset. Which dimension should they assess first?
- Whether the dataset has a physical index
- Whether required metadata fields (owner, definition, classification) are populated (Correct answer)
- Whether the dataset's file size is documented
- Whether the dataset is stored in columnar format
Correct answer: Whether required metadata fields (owner, definition, classification) are populated
Metadata completeness is measured by whether mandatory fields—such as owner, business definition, sensitivity classification—are populated.
CDS Metadata & Master Data Management 3
Which metadata management practice ensures that a data element's meaning is consistent across different departments and systems?