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

Questions 1–5

1. 1application · medium

   A telecom company is consolidating customer service records. For the 'service tier' attribute, the billing system says 'Premium' and the CRM says 'Standard'. The data governance team has designated the billing system as the system of record for service tier. What is the appropriate conflict resolution?

   • AUse the billing system's value and log the discrepancy for audit
   • BMerge the values as 'Premium Standard'
   • CFlag the record for manual review and do not populate the field
   • DUse the CRM's value because it is more customer-facing
   Reveal Solution Discussion Select an answer first
2. 2foundation · easy

   When consolidating customer data from multiple sources, a data architect needs to decide which source's value for 'email address' should be used in the master record. The architect decides that the value from the source with the most recent update timestamp will be used. What is this decision called?

   • AData profiling
   • BData masking
   • CData survivorship rule
   • DData lineage
   Reveal Solution Discussion Select an answer first
4. 3foundation · easy

   Before consolidating customer attributes from multiple source systems, a data architect needs to understand which source is most reliable for each attribute. Which activity directly supports this understanding?

   • AAnalyzing source systems for data quality, completeness, and reliability
   • BDefining data survivorship rules
   • CSelecting a data virtualization tool
   • DDesigning the target data model
   Reveal Solution Discussion Select an answer first
5. 4expert · hard

   A healthcare organization is consolidating patient data from multiple systems. The data governance policy requires that survivorship rules be documented and approved by the data steward. The data architect has proposed a rule that uses the most recent update for 'emergency contact'. The data steward is concerned about the rule's impact on patient safety. What should the data architect do?

   • AChange the rule to use the source with the highest data quality score
   • BEscalate the concern to the IT department
   • CImplement the rule as proposed because it is technically sound
   • DReview the rule with the data steward, considering whether the most recent update is always the most reliable for emergency contact
   Reveal Solution Discussion Select an answer first
6. 5expert · hard

   A retail company is consolidating customer data from an e-commerce platform and a loyalty program into a new MDM. The MDM will feed a recommendation engine that uses purchase history. The data architect must ensure that the consolidation does not break the recommendation engine's data lineage. What is the most important impact to assess?

   • AThe need to replace the recommendation engine with a new system
   • BHow the MDM's survivorship rules affect the purchase history attributes used by the recommendation engine
   • CThe need to migrate the recommendation engine to a different cloud provider
   • DThe cost of the MDM implementation
   Reveal Solution Discussion Select an answer first