Given a Customer Scenario, Recommend Approaches and Techniques for Consolidating Data Attributes from Multiple Sources. Discuss Criteria and Methodology for Picking the Winning Attributes (data Survivorship Rules). DATA-ARCHITECT Practice Questions (Page 5)

Questions 21–25

1. 21foundation · easy

   A data architect is consolidating customer data and needs to document the origin and transformation of each attribute in the master record. Which concept is directly supported by this documentation?

   • AData encryption
   • BData lineage
   • CData retention
   • DData masking
   Reveal Solution Discussion Select an answer first
2. 22application · medium

   A company is consolidating customer data from multiple sources into a new master data management (MDM) system. The downstream reporting team uses a data warehouse that receives daily feeds. The MDM system will now be the source for customer attributes. What impact should the data architect assess?

   • AThe need to update data lineage and ensure the warehouse feeds align with the new MDM source
   • BThe need to retire all source systems immediately
   • CThe need to re-architect the warehouse to use real-time data
   • DThe need to change the warehouse schema to match the MDM system exactly
   Reveal Solution Discussion Select an answer first
4. 23application · medium

   A manufacturing company is consolidating supplier data from a procurement system and a quality management system (QMS). The procurement system has the most complete supplier contact information. The QMS has the most accurate quality ratings. For the 'quality rating' attribute, which survivorship criterion is most appropriate?

   • ASource priority (QMS wins)
   • BMost recent update wins
   • CMost complete value wins
   • DAverage of the two values
   Reveal Solution Discussion Select an answer first
5. 24foundation · easy

   A data architect needs to consolidate customer attributes from multiple source systems into a single repository for analytics. The sources include a data warehouse, a data lake, and several operational databases. The architect wants to minimize data movement and provide a unified view without physically copying data into a new store. Which consolidation approach best fits this requirement?

   • AETL (Extract, Transform, Load)
   • BManual curation
   • CELT (Extract, Load, Transform)
   • DData virtualization
   Reveal Solution Discussion Select an answer first
6. 25foundation · easy

   A data architect is defining rules for consolidating customer attributes. For the 'credit limit' attribute, the architect specifies that the value from the system of record (the ERP system) should always be used over other sources. What type of rule is this?

   • AA data survivorship rule
   • BA data validation rule
   • CA data access rule
   • DA data retention rule
   Reveal Solution Discussion Select an answer first