Describe Metadata and Master Data Management DATA-ENGINEERING-OPTIMIZE Practice Questions (Page 3)

Questions 11–15

1. 11expert · hard

   A data governance team is designing a metadata strategy for a new data platform. They need to support both business users (who need to understand data meaning) and data engineers (who need to understand data structure and lineage). Which combination of metadata types should they prioritize?

   • AOnly technical metadata to keep it simple.
   • BBusiness metadata for definitions and technical metadata for schema and lineage.
   • COperational metadata for processing history and reference metadata for codes.
   • DOnly business metadata to focus on user needs.
   Reveal Solution Discussion Select an answer first
2. 12application · medium

   A manufacturing company has multiple ERP systems that manage supplier data. They want to ensure that supplier master data is consistent across all systems and that updates made in the MDM system are propagated back to the ERPs. Which MDM implementation style should they choose?

   • ACentralized style
   • BRegistry style
   • CConsolidation style
   • DCoexistence style
   Reveal Solution Discussion Select an answer first
4. 13application · medium

   A multinational corporation has multiple business units that maintain separate customer databases with inconsistent customer records. The data governance team wants to create a single, authoritative view of each customer to support cross-selling and reporting. Which approach should they implement?

   • AData lake to store all customer data in its raw form.
   • BMaster Data Management (MDM) to consolidate and manage customer master data.
   • CETL process to copy all customer data into a single data warehouse.
   • DData virtualization to query all databases in real-time without consolidation.
   Reveal Solution Discussion Select an answer first
5. 14application · medium

   A retail company ingests data from multiple sources into a data lake. The data governance team needs to automatically capture metadata when new data is added, including source system, timestamp, and schema changes. They also want to make this metadata searchable for data stewards. Which approach best meets these requirements?

   • AUse a metadata management tool that integrates with data ingestion pipelines to auto-capture and index metadata.
   • BManually document metadata in spreadsheets and share via email.
   • CStore metadata in a separate relational database and require data stewards to query it directly.
   • DRely on the data lake's built-in schema inference to generate all metadata automatically.
   Reveal Solution Discussion Select an answer first
6. 15foundation · easy

   Which of the following is a key component of a Master Data Management (MDM) solution?

   • AA data lake for raw data storage
   • BA real-time stream processing engine
   • CA machine learning model for prediction
   • DA central master data repository
   Reveal Solution Discussion Select an answer first