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 3)

Questions 11–15

1. 11foundation · easy

   Before implementing data consolidation rules, a data architect needs to understand how the consolidated data will affect downstream reports. Which activity directly addresses this need?

   • AAssessing the impact on downstream systems and processes
   • BCreating a data backup plan
   • CDefining data survivorship rules
   • DSelecting a data virtualization tool
   Reveal Solution Discussion Select an answer first
2. 12foundation · easy

   A company needs to consolidate customer data from multiple sources into a data warehouse for reporting. The data must be transformed and cleansed before loading to meet reporting requirements. Which consolidation approach is most appropriate for this scenario?

   • AETL (Extract, Transform, Load)
   • BData virtualization
   • CManual data entry
   • DELT (Extract, Load, Transform)
   Reveal Solution Discussion Select an answer first
4. 13application · medium

   A data architect is consolidating employee data from an HR system and a payroll system. The HR system is updated by employees themselves, while the payroll system is updated by HR staff. For the 'job title' attribute, which source should be considered more reliable?

   • AThe source with the most recent update
   • BThe HR system, because employees update their own data
   • CThe payroll system, because HR staff update it and it is used for compensation
   • DBoth sources equally, because they are both internal systems
   Reveal Solution Discussion Select an answer first
5. 14foundation · easy

   A data architect is consolidating customer addresses. The architect decides that the address from the CRM system should be used over the address from the legacy system, regardless of update date. Which survivorship criterion is being used?

   • ASource priority
   • BHighest quality
   • CMost recent
   • DMost complete
   Reveal Solution Discussion Select an answer first
6. 15application · medium

   A data architect is consolidating customer addresses from an order management system (OMS) and a loyalty program database. The OMS captures addresses at checkout, which are often shipping addresses. The loyalty database is updated when customers update their profile. For the 'billing address' attribute, which source should be considered more reliable?

   • AThe OMS, because it captures addresses at every transaction
   • BBoth sources equally, because they are both transactional systems
   • CThe loyalty program database, because customers actively maintain their profile
   • DThe source with the most complete address fields
   Reveal Solution Discussion Select an answer first