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

Questions 6–10

1. 6foundation · easy

   A data architect is consolidating customer phone numbers from three sources. The architect wants to use the most recently updated phone number as the master value. Which survivorship criterion should be selected?

   • AMost complete
   • BSource priority
   • CMost recent
   • DHighest quality
   Reveal Solution Discussion Select an answer first
2. 7application · medium

   A retail company needs to consolidate product data from an ERP, a PIM, and a legacy spreadsheet into a single data warehouse for reporting. The data volumes are moderate, and the business needs the consolidated data available for reporting within 24 hours of source updates. Which consolidation approach is most appropriate?

   • AManual curation in the spreadsheet
   • BETL into the warehouse with scheduled nightly batches
   • CData virtualization with a live view across sources
   • DELT into the warehouse with real-time streaming
   Reveal Solution Discussion Select an answer first
4. 8application · medium

   A global bank is consolidating customer data from regional systems. The data governance policy requires that for EU customers, the 'country of residence' attribute must come from the system that is the legal source of truth for regulatory reporting. Which survivorship rule best aligns with this policy?

   • AUse the value from the system with the highest data quality score
   • BUse the regional system designated as the legal source of truth for EU customers
   • CUse the value from the system with the most complete data
   • DUse the most recently updated value from any regional system
   Reveal Solution Discussion Select an answer first
5. 9application · medium

   A healthcare provider is merging patient records from an EHR system and a patient portal. The EHR has complete, verified demographic data but is updated only at admission. The portal allows patients to update their address and phone anytime. For the patient's mobile phone number, which survivorship criterion is most appropriate?

   • ACompleteness (non-null wins)
   • BMost recent update wins
   • CAverage of the two values
   • DSource priority (EHR wins)
   Reveal Solution Discussion Select an answer first
6. 10foundation · easy

   A data architect is defining survivorship rules for customer data. The company's data governance policy states that the finance system is the authoritative source for financial attributes. How should the architect align the survivorship rules with this policy?

   • AUse the most recent value for all financial attributes
   • BSet the finance system as the highest priority source for financial attributes
   • CFlag all financial attribute conflicts for manual review
   • DAverage the values from all sources for financial attributes
   Reveal Solution Discussion Select an answer first